Delphi ActiveX 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"

Delphi ActiveX Example

var
rest: TChilkatRest;
success: Integer;
bTls: Integer;
port: Integer;
bAutoReconnect: Integer;
sbResponseBody: TChilkatStringBuilder;
respStatusCode: Integer;
jsonResponse: TChilkatJsonObject;
odataContext: WideString;
odataEtag: WideString;
paymenttermscode: Integer;
industrycode: Integer;
address1_latitude: Integer;
merged: Integer;
accountnumber: WideString;
statecode: Integer;
emailaddress1: WideString;
exchangerate: Integer;
openrevenue_state: Integer;
tickersymbol: WideString;
name: WideString;
websiteurl: WideString;
opendeals: Integer;
modifiedon: WideString;
v_owninguser_value: WideString;
v_primarycontactid_value: WideString;
importsequencenumber: Integer;
address1_composite: WideString;
address1_longitude: Integer;
donotpostalmail: Integer;
accountratingcode: Integer;
numberofemployees: Integer;
marketingonly: Integer;
revenue_base: Integer;
preferredcontactmethodcode: Integer;
v_territoryid_value: WideString;
v_ownerid_value: WideString;
entityimage: WideString;
description: WideString;
customersizecode: Integer;
entityimage_url: WideString;
openrevenue_date: WideString;
openrevenue_base: Integer;
donotemail: Integer;
address2_shippingmethodcode: Integer;
entityimage_timestamp: Integer;
timezoneruleversionnumber: Integer;
revenue: Integer;
address2_freighttermscode: Integer;
statuscode: Integer;
createdon: WideString;
msdyn_travelchargetype: Integer;
opendeals_state: Integer;
openrevenue: Integer;
donotsendmm: Integer;
donotfax: Integer;
donotbulkpostalmail: Integer;
address1_country: WideString;
versionnumber: Integer;
address1_line1: WideString;
address1_line2: WideString;
creditonhold: Integer;
telephone1: WideString;
v_owningbusinessunit_value: WideString;
donotphone: Integer;
v_transactioncurrencyid_value: WideString;
accountid: WideString;
donotbulkemail: Integer;
v_modifiedby_value: WideString;
followemail: Integer;
businesstypecode: Integer;
v_createdby_value: WideString;
address1_city: WideString;
territorycode: Integer;
address2_addresstypecode: Integer;
ownershipcode: Integer;
fax: WideString;
msdyn_taxexempt: Integer;
address1_addressid: WideString;
participatesinworkflow: Integer;
accountclassificationcode: Integer;
overriddencreatedon: WideString;
address2_addressid: WideString;
address1_postalcode: WideString;
entityimageid: WideString;
shippingmethodcode: Integer;
opendeals_date: WideString;
lastusedincampaign: WideString;
address1_name: WideString;
v_msdyn_billingaccount_value: WideString;
creditlimit: WideString;
v_msdyn_salestaxcode_value: WideString;
telephone3: WideString;
msdyn_externalaccountid: WideString;
address1_freighttermscode: WideString;
lastonholdtime: WideString;
address2_line1: WideString;
onholdtime: WideString;
msdyn_workorderinstructions: WideString;
address2_telephone1: WideString;
address1_fax: WideString;
v_createdonbehalfby_value: WideString;
address2_city: WideString;
address2_latitude: WideString;
creditlimit_base: WideString;
address1_telephone2: WideString;
aging90_base: WideString;
address2_postalcode: WideString;
address2_name: WideString;
primarysatoriid: WideString;
v_masterid_value: WideString;
aging30: WideString;
address2_county: WideString;
v_originatingleadid_value: WideString;
emailaddress3: WideString;
address1_shippingmethodcode: WideString;
int_facebook: WideString;
address1_stateorprovince: WideString;
utcconversiontimezonecode: WideString;
sharesoutstanding: WideString;
sic: WideString;
v_preferredsystemuserid_value: WideString;
address2_longitude: WideString;
v_defaultpricelevelid_value: WideString;
address1_primarycontactname: WideString;
address1_county: WideString;
address2_postofficebox: WideString;
v_preferredserviceid_value: WideString;
address1_upszone: WideString;
stageid: WideString;
address2_composite: WideString;
marketcap: WideString;
aging60: WideString;
customertypecode: WideString;
msdyn_travelcharge: WideString;
address1_postofficebox: WideString;
v_msdyn_preferredresource_value: WideString;
yominame: WideString;
address2_primarycontactname: WideString;
address2_country: WideString;
v_msdyn_serviceterritory_value: WideString;
traversedpath: WideString;
int_twitter: WideString;
aging90: WideString;
address1_telephone1: WideString;
msdyn_taxexemptnumber: WideString;
address2_telephone3: WideString;
telephone2: WideString;
v_owningteam_value: WideString;
address2_line2: WideString;
msdyn_travelcharge_base: WideString;
primarytwitterid: WideString;
timespentbymeonemailandmeetings: WideString;
v_modifiedbyexternalparty_value: WideString;
v_slaid_value: WideString;
ftpsiteurl: WideString;
v_preferredequipmentid_value: WideString;
processid: WideString;
address2_telephone2: WideString;
address1_addresstypecode: WideString;
address1_utcoffset: WideString;
v_parentaccountid_value: WideString;
v_createdbyexternalparty_value: WideString;
address2_fax: WideString;
aging60_base: WideString;
v_modifiedonbehalfby_value: WideString;
stockexchange: WideString;
preferredappointmentdaycode: WideString;
address1_line3: WideString;
aging30_base: WideString;
address2_upszone: WideString;
v_slainvokedid_value: WideString;
address2_line3: WideString;
address2_utcoffset: WideString;
address2_stateorprovince: WideString;
preferredappointmenttimecode: WideString;
emailaddress2: WideString;
marketcap_base: WideString;
address1_telephone3: WideString;
accountcategorycode: WideString;

begin
rest := TChilkatRest.Create(Self);

//  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)
bTls := 1;
port := 443;
bAutoReconnect := 1;
success := rest.Connect('my-dynamics-domain.api.crm.dynamics.com',port,bTls,bAutoReconnect);
if (success <> 1) then
  begin
    Memo1.Lines.Add('ConnectFailReason: ' + IntToStr(rest.ConnectFailReason));
    Memo1.Lines.Add(rest.LastErrorText);
    Exit;
  end;

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');

sbResponseBody := TChilkatStringBuilder.Create(Self);
success := rest.FullRequestNoBodySb('GET','/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)',sbResponseBody.ControlInterface);
if (success <> 1) then
  begin
    Memo1.Lines.Add(rest.LastErrorText);
    Exit;
  end;
respStatusCode := rest.ResponseStatusCode;
if (respStatusCode >= 400) then
  begin
    Memo1.Lines.Add('Response Status Code = ' + IntToStr(respStatusCode));
    Memo1.Lines.Add('Response Header:');
    Memo1.Lines.Add(rest.ResponseHeader);
    Memo1.Lines.Add('Response Body:');
    Memo1.Lines.Add(sbResponseBody.GetAsString());
    Exit;
  end;

jsonResponse := TChilkatJsonObject.Create(Self);
jsonResponse.LoadSb(sbResponseBody.ControlInterface);

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