Tcl 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"

Tcl Example


load ./chilkat.dll

set rest [new_CkRest]

#  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)
set bTls 1
set port 443
set bAutoReconnect 1
set success [CkRest_Connect $rest "my-dynamics-domain.api.crm.dynamics.com" $port $bTls $bAutoReconnect]
if {[expr $success != 1]} then {
    puts "ConnectFailReason: [CkRest_ConnectFailReason $rest]"
    puts [CkRest_lastErrorText $rest]
    delete_CkRest $rest
    exit
}

CkRest_AddHeader $rest "OData-MaxVersion" "4.0"
CkRest_AddHeader $rest "Accept" "application/json"
CkRest_AddHeader $rest "OData-Version" "4.0"
CkRest_AddHeader $rest "Authorization" "Bearer DYNAMICS_CRM_ACCESS_TOKEN"

set sbResponseBody [new_CkStringBuilder]

set success [CkRest_FullRequestNoBodySb $rest "GET" "/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)" $sbResponseBody]
if {[expr $success != 1]} then {
    puts [CkRest_lastErrorText $rest]
    delete_CkRest $rest
    delete_CkStringBuilder $sbResponseBody
    exit
}

set respStatusCode [CkRest_ResponseStatusCode $rest]
if {[expr $respStatusCode >= 400]} then {
    puts "Response Status Code = $respStatusCode"
    puts "Response Header:"
    puts [CkRest_responseHeader $rest]
    puts "Response Body:"
    puts [CkStringBuilder_getAsString $sbResponseBody]
    delete_CkRest $rest
    delete_CkStringBuilder $sbResponseBody
    exit
}

set jsonResponse [new_CkJsonObject]

CkJsonObject_LoadSb $jsonResponse $sbResponseBody

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

delete_CkRest $rest
delete_CkStringBuilder $sbResponseBody
delete_CkJsonObject $jsonResponse

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
}