PHP Extension 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"

PHP Extension Example

<?php

// The version number (9_5_0) should match version of the Chilkat extension used, omitting the micro-version number.
// For example, if using Chilkat v9.5.0.48, then include as shown here:
include("chilkat_9_5_0.php");

$rest = new CkRest();

//  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 = $rest->Connect('my-dynamics-domain.api.crm.dynamics.com',$port,$bTls,$bAutoReconnect);
if ($success != true) {
    print 'ConnectFailReason: ' . $rest->get_ConnectFailReason() . "\n";
    print $rest->lastErrorText() . "\n";
    exit;
}

$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 = new CkStringBuilder();
$success = $rest->FullRequestNoBodySb('GET','/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)',$sbResponseBody);
if ($success != true) {
    print $rest->lastErrorText() . "\n";
    exit;
}

$respStatusCode = $rest->get_ResponseStatusCode();
if ($respStatusCode >= 400) {
    print 'Response Status Code = ' . $respStatusCode . "\n";
    print 'Response Header:' . "\n";
    print $rest->responseHeader() . "\n";
    print 'Response Body:' . "\n";
    print $sbResponseBody->getAsString() . "\n";
    exit;
}

$jsonResponse = new CkJsonObject();
$jsonResponse->LoadSb($sbResponseBody);

$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
}