Xojo Plugin Dynamics CRM: Retrieve a Single Account

Back to Index

This example returns data for an account entity instance with the primary key value equal to aca19cdd-88df-e311-b8e5-6c3be5a8b200. (This is for the Blue Yonder Airlines sample data.)

Documentation: https://msdn.microsoft.com/en-us/library/gg334767.aspx#Basic query example

CURL Command

curl -X GET https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200) \
  -H "Accept: application/json" \
  -H "OData-MaxVersion: 4.0"  \
  -H "OData-Version: 4.0" \
  -H "Authorization: Bearer DYNAMICS_CRM_ACCESS_TOKEN"

Xojo Plugin Example

Dim rest As New Chilkat.Rest
Dim success As Boolean

//  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)
Dim bTls As Boolean
bTls = True
Dim port As Int32
port = 443
Dim bAutoReconnect As Boolean
bAutoReconnect = True
success = rest.Connect("my-dynamics-domain.api.crm.dynamics.com",port,bTls,bAutoReconnect)
If (success <> True) Then
    System.DebugLog("ConnectFailReason: " + Str(rest.ConnectFailReason))
    System.DebugLog(rest.LastErrorText)
    Return
End If

rest.AddHeader("OData-MaxVersion","4.0")
rest.AddHeader("Accept","application/json")
rest.AddHeader("OData-Version","4.0")
rest.AddHeader("Authorization","Bearer DYNAMICS_CRM_ACCESS_TOKEN")

Dim sbResponseBody As New Chilkat.StringBuilder
success = rest.FullRequestNoBodySb("GET","/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)",sbResponseBody)
If (success <> True) Then
    System.DebugLog(rest.LastErrorText)
    Return
End If

Dim respStatusCode As Int32
respStatusCode = rest.ResponseStatusCode
If (respStatusCode >= 400) Then
    System.DebugLog("Response Status Code = " + Str(respStatusCode))
    System.DebugLog("Response Header:")
    System.DebugLog(rest.ResponseHeader)
    System.DebugLog("Response Body:")
    System.DebugLog(sbResponseBody.GetAsString())
    Return
End If

Dim jsonResponse As New Chilkat.JsonObject
jsonResponse.LoadSb(sbResponseBody)

Dim odataContext As String
odataContext = jsonResponse.StringOf("""@odata.context""")
Dim odataEtag As String
odataEtag = jsonResponse.StringOf("""@odata.etag""")
Dim paymenttermscode As Int32
paymenttermscode = jsonResponse.IntOf("paymenttermscode")
Dim industrycode As Int32
industrycode = jsonResponse.IntOf("industrycode")
Dim address1_latitude As Int32
address1_latitude = jsonResponse.IntOf("address1_latitude")
Dim merged As Boolean
merged = jsonResponse.BoolOf("merged")
Dim accountnumber As String
accountnumber = jsonResponse.StringOf("accountnumber")
Dim statecode As Int32
statecode = jsonResponse.IntOf("statecode")
Dim emailaddress1 As String
emailaddress1 = jsonResponse.StringOf("emailaddress1")
Dim exchangerate As Int32
exchangerate = jsonResponse.IntOf("exchangerate")
Dim openrevenue_state As Int32
openrevenue_state = jsonResponse.IntOf("openrevenue_state")
Dim tickersymbol As String
tickersymbol = jsonResponse.StringOf("tickersymbol")
Dim name As String
name = jsonResponse.StringOf("name")
Dim websiteurl As String
websiteurl = jsonResponse.StringOf("websiteurl")
Dim opendeals As Int32
opendeals = jsonResponse.IntOf("opendeals")
Dim modifiedon As String
modifiedon = jsonResponse.StringOf("modifiedon")
Dim v_owninguser_value As String
v_owninguser_value = jsonResponse.StringOf("_owninguser_value")
Dim v_primarycontactid_value As String
v_primarycontactid_value = jsonResponse.StringOf("_primarycontactid_value")
Dim importsequencenumber As Int32
importsequencenumber = jsonResponse.IntOf("importsequencenumber")
Dim address1_composite As String
address1_composite = jsonResponse.StringOf("address1_composite")
Dim address1_longitude As Int32
address1_longitude = jsonResponse.IntOf("address1_longitude")
Dim donotpostalmail As Boolean
donotpostalmail = jsonResponse.BoolOf("donotpostalmail")
Dim accountratingcode As Int32
accountratingcode = jsonResponse.IntOf("accountratingcode")
Dim numberofemployees As Int32
numberofemployees = jsonResponse.IntOf("numberofemployees")
Dim marketingonly As Boolean
marketingonly = jsonResponse.BoolOf("marketingonly")
Dim revenue_base As Int32
revenue_base = jsonResponse.IntOf("revenue_base")
Dim preferredcontactmethodcode As Int32
preferredcontactmethodcode = jsonResponse.IntOf("preferredcontactmethodcode")
Dim v_territoryid_value As String
v_territoryid_value = jsonResponse.StringOf("_territoryid_value")
Dim v_ownerid_value As String
v_ownerid_value = jsonResponse.StringOf("_ownerid_value")
Dim entityimage As String
entityimage = jsonResponse.StringOf("entityimage")
Dim description As String
description = jsonResponse.StringOf("description")
Dim customersizecode As Int32
customersizecode = jsonResponse.IntOf("customersizecode")
Dim entityimage_url As String
entityimage_url = jsonResponse.StringOf("entityimage_url")
Dim openrevenue_date As String
openrevenue_date = jsonResponse.StringOf("openrevenue_date")
Dim openrevenue_base As Int32
openrevenue_base = jsonResponse.IntOf("openrevenue_base")
Dim donotemail As Boolean
donotemail = jsonResponse.BoolOf("donotemail")
Dim address2_shippingmethodcode As Int32
address2_shippingmethodcode = jsonResponse.IntOf("address2_shippingmethodcode")
Dim entityimage_timestamp As Int32
entityimage_timestamp = jsonResponse.IntOf("entityimage_timestamp")
Dim timezoneruleversionnumber As Int32
timezoneruleversionnumber = jsonResponse.IntOf("timezoneruleversionnumber")
Dim revenue As Int32
revenue = jsonResponse.IntOf("revenue")
Dim address2_freighttermscode As Int32
address2_freighttermscode = jsonResponse.IntOf("address2_freighttermscode")
Dim statuscode As Int32
statuscode = jsonResponse.IntOf("statuscode")
Dim createdon As String
createdon = jsonResponse.StringOf("createdon")
Dim msdyn_travelchargetype As Int32
msdyn_travelchargetype = jsonResponse.IntOf("msdyn_travelchargetype")
Dim opendeals_state As Int32
opendeals_state = jsonResponse.IntOf("opendeals_state")
Dim openrevenue As Int32
openrevenue = jsonResponse.IntOf("openrevenue")
Dim donotsendmm As Boolean
donotsendmm = jsonResponse.BoolOf("donotsendmm")
Dim donotfax As Boolean
donotfax = jsonResponse.BoolOf("donotfax")
Dim donotbulkpostalmail As Boolean
donotbulkpostalmail = jsonResponse.BoolOf("donotbulkpostalmail")
Dim address1_country As String
address1_country = jsonResponse.StringOf("address1_country")
Dim versionnumber As Int32
versionnumber = jsonResponse.IntOf("versionnumber")
Dim address1_line1 As String
address1_line1 = jsonResponse.StringOf("address1_line1")
Dim address1_line2 As String
address1_line2 = jsonResponse.StringOf("address1_line2")
Dim creditonhold As Boolean
creditonhold = jsonResponse.BoolOf("creditonhold")
Dim telephone1 As String
telephone1 = jsonResponse.StringOf("telephone1")
Dim v_owningbusinessunit_value As String
v_owningbusinessunit_value = jsonResponse.StringOf("_owningbusinessunit_value")
Dim donotphone As Boolean
donotphone = jsonResponse.BoolOf("donotphone")
Dim v_transactioncurrencyid_value As String
v_transactioncurrencyid_value = jsonResponse.StringOf("_transactioncurrencyid_value")
Dim accountid As String
accountid = jsonResponse.StringOf("accountid")
Dim donotbulkemail As Boolean
donotbulkemail = jsonResponse.BoolOf("donotbulkemail")
Dim v_modifiedby_value As String
v_modifiedby_value = jsonResponse.StringOf("_modifiedby_value")
Dim followemail As Boolean
followemail = jsonResponse.BoolOf("followemail")
Dim businesstypecode As Int32
businesstypecode = jsonResponse.IntOf("businesstypecode")
Dim v_createdby_value As String
v_createdby_value = jsonResponse.StringOf("_createdby_value")
Dim address1_city As String
address1_city = jsonResponse.StringOf("address1_city")
Dim territorycode As Int32
territorycode = jsonResponse.IntOf("territorycode")
Dim address2_addresstypecode As Int32
address2_addresstypecode = jsonResponse.IntOf("address2_addresstypecode")
Dim ownershipcode As Int32
ownershipcode = jsonResponse.IntOf("ownershipcode")
Dim fax As String
fax = jsonResponse.StringOf("fax")
Dim msdyn_taxexempt As Boolean
msdyn_taxexempt = jsonResponse.BoolOf("msdyn_taxexempt")
Dim address1_addressid As String
address1_addressid = jsonResponse.StringOf("address1_addressid")
Dim participatesinworkflow As Boolean
participatesinworkflow = jsonResponse.BoolOf("participatesinworkflow")
Dim accountclassificationcode As Int32
accountclassificationcode = jsonResponse.IntOf("accountclassificationcode")
Dim overriddencreatedon As String
overriddencreatedon = jsonResponse.StringOf("overriddencreatedon")
Dim address2_addressid As String
address2_addressid = jsonResponse.StringOf("address2_addressid")
Dim address1_postalcode As String
address1_postalcode = jsonResponse.StringOf("address1_postalcode")
Dim entityimageid As String
entityimageid = jsonResponse.StringOf("entityimageid")
Dim shippingmethodcode As Int32
shippingmethodcode = jsonResponse.IntOf("shippingmethodcode")
Dim opendeals_date As String
opendeals_date = jsonResponse.StringOf("opendeals_date")
Dim lastusedincampaign As String
lastusedincampaign = jsonResponse.StringOf("lastusedincampaign")
Dim address1_name As String
address1_name = jsonResponse.StringOf("address1_name")
Dim v_msdyn_billingaccount_value As String
v_msdyn_billingaccount_value = jsonResponse.StringOf("_msdyn_billingaccount_value")
Dim creditlimit As String
creditlimit = jsonResponse.StringOf("creditlimit")
Dim v_msdyn_salestaxcode_value As String
v_msdyn_salestaxcode_value = jsonResponse.StringOf("_msdyn_salestaxcode_value")
Dim telephone3 As String
telephone3 = jsonResponse.StringOf("telephone3")
Dim msdyn_externalaccountid As String
msdyn_externalaccountid = jsonResponse.StringOf("msdyn_externalaccountid")
Dim address1_freighttermscode As String
address1_freighttermscode = jsonResponse.StringOf("address1_freighttermscode")
Dim lastonholdtime As String
lastonholdtime = jsonResponse.StringOf("lastonholdtime")
Dim address2_line1 As String
address2_line1 = jsonResponse.StringOf("address2_line1")
Dim onholdtime As String
onholdtime = jsonResponse.StringOf("onholdtime")
Dim msdyn_workorderinstructions As String
msdyn_workorderinstructions = jsonResponse.StringOf("msdyn_workorderinstructions")
Dim address2_telephone1 As String
address2_telephone1 = jsonResponse.StringOf("address2_telephone1")
Dim address1_fax As String
address1_fax = jsonResponse.StringOf("address1_fax")
Dim v_createdonbehalfby_value As String
v_createdonbehalfby_value = jsonResponse.StringOf("_createdonbehalfby_value")
Dim address2_city As String
address2_city = jsonResponse.StringOf("address2_city")
Dim address2_latitude As String
address2_latitude = jsonResponse.StringOf("address2_latitude")
Dim creditlimit_base As String
creditlimit_base = jsonResponse.StringOf("creditlimit_base")
Dim address1_telephone2 As String
address1_telephone2 = jsonResponse.StringOf("address1_telephone2")
Dim aging90_base As String
aging90_base = jsonResponse.StringOf("aging90_base")
Dim address2_postalcode As String
address2_postalcode = jsonResponse.StringOf("address2_postalcode")
Dim address2_name As String
address2_name = jsonResponse.StringOf("address2_name")
Dim primarysatoriid As String
primarysatoriid = jsonResponse.StringOf("primarysatoriid")
Dim v_masterid_value As String
v_masterid_value = jsonResponse.StringOf("_masterid_value")
Dim aging30 As String
aging30 = jsonResponse.StringOf("aging30")
Dim address2_county As String
address2_county = jsonResponse.StringOf("address2_county")
Dim v_originatingleadid_value As String
v_originatingleadid_value = jsonResponse.StringOf("_originatingleadid_value")
Dim emailaddress3 As String
emailaddress3 = jsonResponse.StringOf("emailaddress3")
Dim address1_shippingmethodcode As String
address1_shippingmethodcode = jsonResponse.StringOf("address1_shippingmethodcode")
Dim int_facebook As String
int_facebook = jsonResponse.StringOf("int_facebook")
Dim address1_stateorprovince As String
address1_stateorprovince = jsonResponse.StringOf("address1_stateorprovince")
Dim utcconversiontimezonecode As String
utcconversiontimezonecode = jsonResponse.StringOf("utcconversiontimezonecode")
Dim sharesoutstanding As String
sharesoutstanding = jsonResponse.StringOf("sharesoutstanding")
Dim sic As String
sic = jsonResponse.StringOf("sic")
Dim v_preferredsystemuserid_value As String
v_preferredsystemuserid_value = jsonResponse.StringOf("_preferredsystemuserid_value")
Dim address2_longitude As String
address2_longitude = jsonResponse.StringOf("address2_longitude")
Dim v_defaultpricelevelid_value As String
v_defaultpricelevelid_value = jsonResponse.StringOf("_defaultpricelevelid_value")
Dim address1_primarycontactname As String
address1_primarycontactname = jsonResponse.StringOf("address1_primarycontactname")
Dim address1_county As String
address1_county = jsonResponse.StringOf("address1_county")
Dim address2_postofficebox As String
address2_postofficebox = jsonResponse.StringOf("address2_postofficebox")
Dim v_preferredserviceid_value As String
v_preferredserviceid_value = jsonResponse.StringOf("_preferredserviceid_value")
Dim address1_upszone As String
address1_upszone = jsonResponse.StringOf("address1_upszone")
Dim stageid As String
stageid = jsonResponse.StringOf("stageid")
Dim address2_composite As String
address2_composite = jsonResponse.StringOf("address2_composite")
Dim marketcap As String
marketcap = jsonResponse.StringOf("marketcap")
Dim aging60 As String
aging60 = jsonResponse.StringOf("aging60")
Dim customertypecode As String
customertypecode = jsonResponse.StringOf("customertypecode")
Dim msdyn_travelcharge As String
msdyn_travelcharge = jsonResponse.StringOf("msdyn_travelcharge")
Dim address1_postofficebox As String
address1_postofficebox = jsonResponse.StringOf("address1_postofficebox")
Dim v_msdyn_preferredresource_value As String
v_msdyn_preferredresource_value = jsonResponse.StringOf("_msdyn_preferredresource_value")
Dim yominame As String
yominame = jsonResponse.StringOf("yominame")
Dim address2_primarycontactname As String
address2_primarycontactname = jsonResponse.StringOf("address2_primarycontactname")
Dim address2_country As String
address2_country = jsonResponse.StringOf("address2_country")
Dim v_msdyn_serviceterritory_value As String
v_msdyn_serviceterritory_value = jsonResponse.StringOf("_msdyn_serviceterritory_value")
Dim traversedpath As String
traversedpath = jsonResponse.StringOf("traversedpath")
Dim int_twitter As String
int_twitter = jsonResponse.StringOf("int_twitter")
Dim aging90 As String
aging90 = jsonResponse.StringOf("aging90")
Dim address1_telephone1 As String
address1_telephone1 = jsonResponse.StringOf("address1_telephone1")
Dim msdyn_taxexemptnumber As String
msdyn_taxexemptnumber = jsonResponse.StringOf("msdyn_taxexemptnumber")
Dim address2_telephone3 As String
address2_telephone3 = jsonResponse.StringOf("address2_telephone3")
Dim telephone2 As String
telephone2 = jsonResponse.StringOf("telephone2")
Dim v_owningteam_value As String
v_owningteam_value = jsonResponse.StringOf("_owningteam_value")
Dim address2_line2 As String
address2_line2 = jsonResponse.StringOf("address2_line2")
Dim msdyn_travelcharge_base As String
msdyn_travelcharge_base = jsonResponse.StringOf("msdyn_travelcharge_base")
Dim primarytwitterid As String
primarytwitterid = jsonResponse.StringOf("primarytwitterid")
Dim timespentbymeonemailandmeetings As String
timespentbymeonemailandmeetings = jsonResponse.StringOf("timespentbymeonemailandmeetings")
Dim v_modifiedbyexternalparty_value As String
v_modifiedbyexternalparty_value = jsonResponse.StringOf("_modifiedbyexternalparty_value")
Dim v_slaid_value As String
v_slaid_value = jsonResponse.StringOf("_slaid_value")
Dim ftpsiteurl As String
ftpsiteurl = jsonResponse.StringOf("ftpsiteurl")
Dim v_preferredequipmentid_value As String
v_preferredequipmentid_value = jsonResponse.StringOf("_preferredequipmentid_value")
Dim processid As String
processid = jsonResponse.StringOf("processid")
Dim address2_telephone2 As String
address2_telephone2 = jsonResponse.StringOf("address2_telephone2")
Dim address1_addresstypecode As String
address1_addresstypecode = jsonResponse.StringOf("address1_addresstypecode")
Dim address1_utcoffset As String
address1_utcoffset = jsonResponse.StringOf("address1_utcoffset")
Dim v_parentaccountid_value As String
v_parentaccountid_value = jsonResponse.StringOf("_parentaccountid_value")
Dim v_createdbyexternalparty_value As String
v_createdbyexternalparty_value = jsonResponse.StringOf("_createdbyexternalparty_value")
Dim address2_fax As String
address2_fax = jsonResponse.StringOf("address2_fax")
Dim aging60_base As String
aging60_base = jsonResponse.StringOf("aging60_base")
Dim v_modifiedonbehalfby_value As String
v_modifiedonbehalfby_value = jsonResponse.StringOf("_modifiedonbehalfby_value")
Dim stockexchange As String
stockexchange = jsonResponse.StringOf("stockexchange")
Dim preferredappointmentdaycode As String
preferredappointmentdaycode = jsonResponse.StringOf("preferredappointmentdaycode")
Dim address1_line3 As String
address1_line3 = jsonResponse.StringOf("address1_line3")
Dim aging30_base As String
aging30_base = jsonResponse.StringOf("aging30_base")
Dim address2_upszone As String
address2_upszone = jsonResponse.StringOf("address2_upszone")
Dim v_slainvokedid_value As String
v_slainvokedid_value = jsonResponse.StringOf("_slainvokedid_value")
Dim address2_line3 As String
address2_line3 = jsonResponse.StringOf("address2_line3")
Dim address2_utcoffset As String
address2_utcoffset = jsonResponse.StringOf("address2_utcoffset")
Dim address2_stateorprovince As String
address2_stateorprovince = jsonResponse.StringOf("address2_stateorprovince")
Dim preferredappointmenttimecode As String
preferredappointmenttimecode = jsonResponse.StringOf("preferredappointmenttimecode")
Dim emailaddress2 As String
emailaddress2 = jsonResponse.StringOf("emailaddress2")
Dim marketcap_base As String
marketcap_base = jsonResponse.StringOf("marketcap_base")
Dim address1_telephone3 As String
address1_telephone3 = jsonResponse.StringOf("address1_telephone3")
Dim accountcategorycode As String
accountcategorycode = jsonResponse.StringOf("accountcategorycode")

Sample JSON Response Body

{
  "@odata.context": "https://mydomain.api.crm.dynamics.com/api/data/v8.2/$metadata#accounts/$entity",
  "@odata.etag": "W/\"1817216\"",
  "paymenttermscode": 1,
  "industrycode": 30,
  "address1_latitude": -33.79655,
  "merged": false,
  "accountnumber": "ACTBBDC3",
  "statecode": 0,
  "emailaddress1": "brian@blueyonderairlines.com",
  "exchangerate": 1.0000000000,
  "openrevenue_state": 1,
  "tickersymbol": "BYAY",
  "name": "Blue Yonder Airlines",
  "websiteurl": "http://blueyonderairlines.com",
  "opendeals": 2,
  "modifiedon": "2018-03-12T16:09:34Z",
  "_owninguser_value": "55e68414-a277-42d6-ba36-d90484708a1d",
  "_primarycontactid_value": "4da0e5b9-88df-e311-b8e5-6c3be5a8b200",
  "importsequencenumber": 105,
  "address1_composite": "111100 Epping Road\r\nNorth Ryde NSW 0001\r\nSydney 0200\r\nAustralia",
  "address1_longitude": 151.13837,
  "donotpostalmail": false,
  "accountratingcode": 1,
  "numberofemployees": 1876,
  "marketingonly": false,
  "revenue_base": 120000000.0000,
  "preferredcontactmethodcode": 1,
  "_territoryid_value": "3337fc3f-62ef-e411-80eb-c4346bace124",
  "_ownerid_value": "55e68414-a277-42d6-ba36-d90484708a1d",
  "entityimage": "/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACQAJADASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDUooor60/NgooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAq5Y6Xe6if8ARoHdR1boo/Gtrw74dF8FvLxT9n/5Zx/3/c+1b2p+IrDRR9mhQSTKMCOPAVfqe1efVxb5/Z0Vdnr4bLo+z9rXlyx/FnPx+ENTYZaS3T2LEn9BUc3hTVY1JXyZPZXOf1Ap8ni/Umb5EgRfTaT/AFqW38YXqMPPgikTvtypqL4ta6GtsC/d1Xmc9c2k9tIY7iJ42HZhioK9Igu9M8TWjRlQ2B8yOMOvuP8AEVx2t6LLpF0MEvA/3Hx+h962oYvnl7OatI5sVlzpQ9rSlzQfUyKKKK7TzAooooAKKKKACiiigArS03RL7VCDBFiLvI5wv/1/wqbQNK/tS9PmA/Z4+X9/QfjXWa1r1vosKW0EStNt+VBwqjtn/CuHEYmUZ+ypK8vyPWweBpypuvXdor8TNh8EIFBuLty3cRqAB+easjwXY7lInuDggkEggj8q5q51/Vrpjm7eMf3Yvlx+XNQw6xqkD71v7gn0eQsPyNYOhinq5HQsXgouyg2jrvEWq/2RYJBbYSaQbUx/Co6kVwRJJJJJJ6k1avr6e/uRPcMGcKFGBgYFVK68LQ9lHXfqcGOxnt56fCtgooorqOAntLuayuUngcpIhyD6+xrv/wB14j8Pdh5q/wDfDD/6/wClec12XgmYta3kJPCOrD8Qf8K87H07RVVbo9nK6zc3QlrGSehx8iNFI0bjDKSpHuKbW14j06W01m4kELiCR96vj5SSMnn65rFrroVFOCkup52IpOlUlB9GFFFFbHOFFFFABVyDTdQuVDQ2kzqejBDj866jwz4diWBb++RXdxujRhwo9T71av8AxbY2kpit43nK8Fk4X8+9efPGSc3CjHmsexSy2EaaqYifKnsuo7wvYy6fpmJ4zHK7szKeoxwP5frXEX1y95fz3EjFmkcn8Ow/Kuvj8aWc4KTRyRMR94/Mv6c/pXENgMQOmanBwqe1lOorNlY+rSdGFKlK8Vf+mJRRRXpHihRRRQAUUUUAFaWk6vcaPI7QIjrJjerg84z0PbqazaKmcIzjyyV0aUqs6U1ODs0ehaZrtjrqNbSoElI+aKTkMPb1rm/Emgf2VMJ4ATayHAB/gPp9KxIpXhlSWNisiHcrDqDXoOV1/wANZZRmWMgj+647/mK8ycHhailH4Xuj3aVVY2jKM178VdPued0UpGCQexpK9U+eCrmnQLdanbQPyryqGHqM81Tq1p9yLTUbedvuxyKzfTPNZ1r+zdtzWhy+0jzbXR2Xiq9az0dYIjtM7bCR2UDn+grg673xPZNfaKtxEN7QnzAF53LjnH8/wrgq48By8mm99T1M05+a72srBRRRXoHjBRRRQAUUUUAFFFFABRRRTAK9A8LKV8OqW4BZyPpmuK0/T59Ru0ghXqcs3ZR6mu31a5h0Pw55UOA2zyYh6kjr/WvMxs1Nxpx3bPcy+m6anVnpFI4CYgzyEdCxx+dMoor0onjVHeVwooooIOu8N+JYooVsr5wgXiOQ9Meh/wAa1L3wxpl+/nxFo2fkmEjB98f4V57ViG9urYYguZYx6I5FcFTBvn56UuVs9ejmcfZqnXhzJbdyxrFhHpupPbROzqqqct15FZ9STTzXEhknleRzwWc5NR1201JRSk7s8yrKMptwVl0QUUUVRmFFFFABRRRQB1Wm+GLS9soJ3nmVpIw5AIwM1oR+C9PRgXuJ2A7ZAz+lcfHqF/FGqR3k6KowqrIQAKc+pag4w97cMPQyGvOlQxDbtLQ9mGLw0Yq8Ls7q4vtJ8O2xijEaNjIij5Zvr/ia4jVdVn1W686X5VHCRg8KKokknJOSeppK2oYSNJ8zd5dznxeYzrrkS5YrogooorrPOCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP/Z",
  "description": "Blue Yonder Airlines strives to be the most preferred domestic carrier in the United States. Our goal is to provide unmatched standards of travel for our customers, ensure consistent long-term returns for the investors, and provide our employees with an environment for excellence and growth. Blue Yonder Airlines will achieve our goals by offering consistent, high quality service, and reliable, safe, and efficient operations.",
  "customersizecode": 1,
  "entityimage_url": "/Image/download.aspx?Entity=account&Attribute=entityimage&Id=aca19cdd-88df-e311-b8e5-6c3be5a8b200&Timestamp=636564677747626460",
  "openrevenue_date": "2018-04-26T10:02:54Z",
  "openrevenue_base": 5004500.0000,
  "donotemail": false,
  "address2_shippingmethodcode": 1,
  "entityimage_timestamp": 636564677747626460,
  "timezoneruleversionnumber": 0,
  "revenue": 120000000.0000,
  "address2_freighttermscode": 1,
  "statuscode": 1,
  "createdon": "2017-01-20T22:39:16Z",
  "msdyn_travelchargetype": 690970003,
  "opendeals_state": 1,
  "openrevenue": 5004500.0000,
  "donotsendmm": false,
  "donotfax": false,
  "donotbulkpostalmail": false,
  "address1_country": "Australia",
  "versionnumber": 1817216,
  "address1_line1": "111100 Epping Road",
  "address1_line2": "North Ryde NSW 0001",
  "creditonhold": false,
  "telephone1": "555-0135",
  "_owningbusinessunit_value": "c4106190-c81e-e811-a980-000d3a192e9a",
  "donotphone": false,
  "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a",
  "accountid": "aca19cdd-88df-e311-b8e5-6c3be5a8b200",
  "donotbulkemail": false,
  "_modifiedby_value": "e00ba668-e2de-47bc-8f92-ab9573f92ff4",
  "followemail": true,
  "businesstypecode": 1,
  "_createdby_value": "55e68414-a277-42d6-ba36-d90484708a1d",
  "address1_city": "Sydney",
  "territorycode": 1,
  "address2_addresstypecode": 1,
  "ownershipcode": 3,
  "fax": "612-4444-5556",
  "msdyn_taxexempt": false,
  "address1_addressid": "14e08187-8029-4d87-b40c-51c4cfbbdf83",
  "participatesinworkflow": false,
  "accountclassificationcode": 1,
  "overriddencreatedon": "2018-03-03T12:21:52Z",
  "address2_addressid": "5d8eb6c2-7793-41d2-bba1-a8e5bde5a98c",
  "address1_postalcode": "0200",
  "entityimageid": "0bf270bb-0f26-e811-a953-000d3a1c53e4",
  "shippingmethodcode": 1,
  "opendeals_date": "2018-04-26T10:02:54Z",
  "lastusedincampaign": null,
  "address1_name": null,
  "_msdyn_billingaccount_value": null,
  "creditlimit": null,
  "_msdyn_salestaxcode_value": null,
  "telephone3": null,
  "msdyn_externalaccountid": null,
  "address1_freighttermscode": null,
  "lastonholdtime": null,
  "address2_line1": null,
  "onholdtime": null,
  "msdyn_workorderinstructions": null,
  "address2_telephone1": null,
  "address1_fax": null,
  "_createdonbehalfby_value": null,
  "address2_city": null,
  "address2_latitude": null,
  "creditlimit_base": null,
  "address1_telephone2": null,
  "aging90_base": null,
  "address2_postalcode": null,
  "address2_name": null,
  "primarysatoriid": null,
  "_masterid_value": null,
  "aging30": null,
  "address2_county": null,
  "_originatingleadid_value": null,
  "emailaddress3": null,
  "address1_shippingmethodcode": null,
  "int_facebook": null,
  "address1_stateorprovince": null,
  "utcconversiontimezonecode": null,
  "sharesoutstanding": null,
  "sic": null,
  "_preferredsystemuserid_value": null,
  "address2_longitude": null,
  "_defaultpricelevelid_value": null,
  "address1_primarycontactname": null,
  "address1_county": null,
  "address2_postofficebox": null,
  "_preferredserviceid_value": null,
  "address1_upszone": null,
  "stageid": null,
  "address2_composite": null,
  "marketcap": null,
  "aging60": null,
  "customertypecode": null,
  "msdyn_travelcharge": null,
  "address1_postofficebox": null,
  "_msdyn_preferredresource_value": null,
  "yominame": null,
  "address2_primarycontactname": null,
  "address2_country": null,
  "_msdyn_serviceterritory_value": null,
  "traversedpath": null,
  "int_twitter": null,
  "aging90": null,
  "address1_telephone1": null,
  "msdyn_taxexemptnumber": null,
  "address2_telephone3": null,
  "telephone2": null,
  "_owningteam_value": null,
  "address2_line2": null,
  "msdyn_travelcharge_base": null,
  "primarytwitterid": null,
  "timespentbymeonemailandmeetings": null,
  "_modifiedbyexternalparty_value": null,
  "_slaid_value": null,
  "ftpsiteurl": null,
  "_preferredequipmentid_value": null,
  "processid": null,
  "address2_telephone2": null,
  "address1_addresstypecode": null,
  "address1_utcoffset": null,
  "_parentaccountid_value": null,
  "_createdbyexternalparty_value": null,
  "address2_fax": null,
  "aging60_base": null,
  "_modifiedonbehalfby_value": null,
  "stockexchange": null,
  "preferredappointmentdaycode": null,
  "address1_line3": null,
  "aging30_base": null,
  "address2_upszone": null,
  "_slainvokedid_value": null,
  "address2_line3": null,
  "address2_utcoffset": null,
  "address2_stateorprovince": null,
  "preferredappointmenttimecode": null,
  "emailaddress2": null,
  "marketcap_base": null,
  "address1_telephone3": null,
  "accountcategorycode": null
}