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

PureBasic Example

IncludeFile "CkJsonObject.pb"
IncludeFile "CkStringBuilder.pb"
IncludeFile "CkRest.pb"

Procedure ChilkatExample()

    rest.i = CkRest::ckCreate()
    If rest.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    success.i

    ;  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)
    bTls.i = 1
    port.i = 443
    bAutoReconnect.i = 1
    success = CkRest::ckConnect(rest,"my-dynamics-domain.api.crm.dynamics.com",port,bTls,bAutoReconnect)
    If success <> 1
        Debug "ConnectFailReason: " + Str(CkRest::ckConnectFailReason(rest))
        Debug CkRest::ckLastErrorText(rest)
        CkRest::ckDispose(rest)
        ProcedureReturn
    EndIf

    CkRest::ckAddHeader(rest,"OData-MaxVersion","4.0")
    CkRest::ckAddHeader(rest,"Accept","application/json")
    CkRest::ckAddHeader(rest,"OData-Version","4.0")
    CkRest::ckAddHeader(rest,"Authorization","Bearer DYNAMICS_CRM_ACCESS_TOKEN")

    sbResponseBody.i = CkStringBuilder::ckCreate()
    If sbResponseBody.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    success = CkRest::ckFullRequestNoBodySb(rest,"GET","/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)",sbResponseBody)
    If success <> 1
        Debug CkRest::ckLastErrorText(rest)
        CkRest::ckDispose(rest)
        CkStringBuilder::ckDispose(sbResponseBody)
        ProcedureReturn
    EndIf

    respStatusCode.i = CkRest::ckResponseStatusCode(rest)
    If respStatusCode >= 400
        Debug "Response Status Code = " + Str(respStatusCode)
        Debug "Response Header:"
        Debug CkRest::ckResponseHeader(rest)
        Debug "Response Body:"
        Debug CkStringBuilder::ckGetAsString(sbResponseBody)
        CkRest::ckDispose(rest)
        CkStringBuilder::ckDispose(sbResponseBody)
        ProcedureReturn
    EndIf

    jsonResponse.i = CkJsonObject::ckCreate()
    If jsonResponse.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckLoadSb(jsonResponse,sbResponseBody)

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


    CkRest::ckDispose(rest)
    CkStringBuilder::ckDispose(sbResponseBody)
    CkJsonObject::ckDispose(jsonResponse)


    ProcedureReturn
EndProcedure

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
}