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

C Example

#include <C_CkRest.h>
#include <C_CkStringBuilder.h>
#include <C_CkJsonObject.h>

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

    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) {
        printf("ConnectFailReason: %d\n",CkRest_getConnectFailReason(rest));
        printf("%s\n",CkRest_lastErrorText(rest));
        CkRest_Dispose(rest);
        return;
    }

    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) {
        printf("%s\n",CkRest_lastErrorText(rest));
        CkRest_Dispose(rest);
        CkStringBuilder_Dispose(sbResponseBody);
        return;
    }

    respStatusCode = CkRest_getResponseStatusCode(rest);
    if (respStatusCode >= 400) {
        printf("Response Status Code = %d\n",respStatusCode);
        printf("Response Header:\n");
        printf("%s\n",CkRest_responseHeader(rest));
        printf("Response Body:\n");
        printf("%s\n",CkStringBuilder_getAsString(sbResponseBody));
        CkRest_Dispose(rest);
        CkStringBuilder_Dispose(sbResponseBody);
        return;
    }

    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
}