Delphi DLL 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 DLL Example

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

begin
rest := CkRest_Create();

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

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

sbResponseBody := CkStringBuilder_Create();
success := CkRest_FullRequestNoBodySb(rest,'GET','/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)',sbResponseBody);
if (success <> True) then
  begin
    Memo1.Lines.Add(CkRest__lastErrorText(rest));
    Exit;
  end;
respStatusCode := CkRest_getResponseStatusCode(rest);
if (respStatusCode >= 400) then
  begin
    Memo1.Lines.Add('Response Status Code = ' + IntToStr(respStatusCode));
    Memo1.Lines.Add('Response Header:');
    Memo1.Lines.Add(CkRest__responseHeader(rest));
    Memo1.Lines.Add('Response Body:');
    Memo1.Lines.Add(CkStringBuilder__getAsString(sbResponseBody));
    Exit;
  end;

jsonResponse := CkJsonObject_Create();
CkJsonObject_LoadSb(jsonResponse,sbResponseBody);

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

CkRest_Dispose(rest);
CkStringBuilder_Dispose(sbResponseBody);
CkJsonObject_Dispose(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
}