Visual FoxPro 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"

Visual FoxPro Example

LOCAL loRest
LOCAL lnSuccess
LOCAL lnBTls
LOCAL lnPort
LOCAL lnBAutoReconnect
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL loJsonResponse
LOCAL lcOdataContext
LOCAL lcOdataEtag
LOCAL lnPaymenttermscode
LOCAL lnIndustrycode
LOCAL lnAddress1_latitude
LOCAL lnMerged
LOCAL lcAccountnumber
LOCAL lnStatecode
LOCAL lcEmailaddress1
LOCAL lnExchangerate
LOCAL lnOpenrevenue_state
LOCAL lcTickersymbol
LOCAL lcName
LOCAL lcWebsiteurl
LOCAL lnOpendeals
LOCAL lcModifiedon
LOCAL lcV_owninguser_value
LOCAL lcV_primarycontactid_value
LOCAL lnImportsequencenumber
LOCAL lcAddress1_composite
LOCAL lnAddress1_longitude
LOCAL lnDonotpostalmail
LOCAL lnAccountratingcode
LOCAL lnNumberofemployees
LOCAL lnMarketingonly
LOCAL lnRevenue_base
LOCAL lnPreferredcontactmethodcode
LOCAL lcV_territoryid_value
LOCAL lcV_ownerid_value
LOCAL lcEntityimage
LOCAL lcDescription
LOCAL lnCustomersizecode
LOCAL lcEntityimage_url
LOCAL lcOpenrevenue_date
LOCAL lnOpenrevenue_base
LOCAL lnDonotemail
LOCAL lnAddress2_shippingmethodcode
LOCAL lnEntityimage_timestamp
LOCAL lnTimezoneruleversionnumber
LOCAL lnRevenue
LOCAL lnAddress2_freighttermscode
LOCAL lnStatuscode
LOCAL lcCreatedon
LOCAL lnMsdyn_travelchargetype
LOCAL lnOpendeals_state
LOCAL lnOpenrevenue
LOCAL lnDonotsendmm
LOCAL lnDonotfax
LOCAL lnDonotbulkpostalmail
LOCAL lcAddress1_country
LOCAL lnVersionnumber
LOCAL lcAddress1_line1
LOCAL lcAddress1_line2
LOCAL lnCreditonhold
LOCAL lcTelephone1
LOCAL lcV_owningbusinessunit_value
LOCAL lnDonotphone
LOCAL lcV_transactioncurrencyid_value
LOCAL lcAccountid
LOCAL lnDonotbulkemail
LOCAL lcV_modifiedby_value
LOCAL lnFollowemail
LOCAL lnBusinesstypecode
LOCAL lcV_createdby_value
LOCAL lcAddress1_city
LOCAL lnTerritorycode
LOCAL lnAddress2_addresstypecode
LOCAL lnOwnershipcode
LOCAL lcFax
LOCAL lnMsdyn_taxexempt
LOCAL lcAddress1_addressid
LOCAL lnParticipatesinworkflow
LOCAL lnAccountclassificationcode
LOCAL lcOverriddencreatedon
LOCAL lcAddress2_addressid
LOCAL lcAddress1_postalcode
LOCAL lcEntityimageid
LOCAL lnShippingmethodcode
LOCAL lcOpendeals_date
LOCAL lcLastusedincampaign
LOCAL lcAddress1_name
LOCAL lcV_msdyn_billingaccount_value
LOCAL lcCreditlimit
LOCAL lcV_msdyn_salestaxcode_value
LOCAL lcTelephone3
LOCAL lcMsdyn_externalaccountid
LOCAL lcAddress1_freighttermscode
LOCAL lcLastonholdtime
LOCAL lcAddress2_line1
LOCAL lcOnholdtime
LOCAL lcMsdyn_workorderinstructions
LOCAL lcAddress2_telephone1
LOCAL lcAddress1_fax
LOCAL lcV_createdonbehalfby_value
LOCAL lcAddress2_city
LOCAL lcAddress2_latitude
LOCAL lcCreditlimit_base
LOCAL lcAddress1_telephone2
LOCAL lcAging90_base
LOCAL lcAddress2_postalcode
LOCAL lcAddress2_name
LOCAL lcPrimarysatoriid
LOCAL lcV_masterid_value
LOCAL lcAging30
LOCAL lcAddress2_county
LOCAL lcV_originatingleadid_value
LOCAL lcEmailaddress3
LOCAL lcAddress1_shippingmethodcode
LOCAL lcInt_facebook
LOCAL lcAddress1_stateorprovince
LOCAL lcUtcconversiontimezonecode
LOCAL lcSharesoutstanding
LOCAL lcSic
LOCAL lcV_preferredsystemuserid_value
LOCAL lcAddress2_longitude
LOCAL lcV_defaultpricelevelid_value
LOCAL lcAddress1_primarycontactname
LOCAL lcAddress1_county
LOCAL lcAddress2_postofficebox
LOCAL lcV_preferredserviceid_value
LOCAL lcAddress1_upszone
LOCAL lcStageid
LOCAL lcAddress2_composite
LOCAL lcMarketcap
LOCAL lcAging60
LOCAL lcCustomertypecode
LOCAL lcMsdyn_travelcharge
LOCAL lcAddress1_postofficebox
LOCAL lcV_msdyn_preferredresource_value
LOCAL lcYominame
LOCAL lcAddress2_primarycontactname
LOCAL lcAddress2_country
LOCAL lcV_msdyn_serviceterritory_value
LOCAL lcTraversedpath
LOCAL lcInt_twitter
LOCAL lcAging90
LOCAL lcAddress1_telephone1
LOCAL lcMsdyn_taxexemptnumber
LOCAL lcAddress2_telephone3
LOCAL lcTelephone2
LOCAL lcV_owningteam_value
LOCAL lcAddress2_line2
LOCAL lcMsdyn_travelcharge_base
LOCAL lcPrimarytwitterid
LOCAL lcTimespentbymeonemailandmeetings
LOCAL lcV_modifiedbyexternalparty_value
LOCAL lcV_slaid_value
LOCAL lcFtpsiteurl
LOCAL lcV_preferredequipmentid_value
LOCAL lcProcessid
LOCAL lcAddress2_telephone2
LOCAL lcAddress1_addresstypecode
LOCAL lcAddress1_utcoffset
LOCAL lcV_parentaccountid_value
LOCAL lcV_createdbyexternalparty_value
LOCAL lcAddress2_fax
LOCAL lcAging60_base
LOCAL lcV_modifiedonbehalfby_value
LOCAL lcStockexchange
LOCAL lcPreferredappointmentdaycode
LOCAL lcAddress1_line3
LOCAL lcAging30_base
LOCAL lcAddress2_upszone
LOCAL lcV_slainvokedid_value
LOCAL lcAddress2_line3
LOCAL lcAddress2_utcoffset
LOCAL lcAddress2_stateorprovince
LOCAL lcPreferredappointmenttimecode
LOCAL lcEmailaddress2
LOCAL lcMarketcap_base
LOCAL lcAddress1_telephone3
LOCAL lcAccountcategorycode

loRest = CreateObject('Chilkat_9_5_0.Rest')

*  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)
lnBTls = 1
lnPort = 443
lnBAutoReconnect = 1
lnSuccess = loRest.Connect("my-dynamics-domain.api.crm.dynamics.com",lnPort,lnBTls,lnBAutoReconnect)
IF (lnSuccess <> 1) THEN
    ? "ConnectFailReason: " + STR(loRest.ConnectFailReason)
    ? loRest.LastErrorText
    RELEASE loRest
    CANCEL
ENDIF

loRest.AddHeader("OData-MaxVersion","4.0")
loRest.AddHeader("Accept","application/json")
loRest.AddHeader("OData-Version","4.0")
loRest.AddHeader("Authorization","Bearer DYNAMICS_CRM_ACCESS_TOKEN")

loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder')
lnSuccess = loRest.FullRequestNoBodySb("GET","/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)",loSbResponseBody)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loSbResponseBody
    CANCEL
ENDIF

lnRespStatusCode = loRest.ResponseStatusCode
IF (lnRespStatusCode >= 400) THEN
    ? "Response Status Code = " + STR(lnRespStatusCode)
    ? "Response Header:"
    ? loRest.ResponseHeader
    ? "Response Body:"
    ? loSbResponseBody.GetAsString()
    RELEASE loRest
    RELEASE loSbResponseBody
    CANCEL
ENDIF

loJsonResponse = CreateObject('Chilkat_9_5_0.JsonObject')
loJsonResponse.LoadSb(loSbResponseBody)

lcOdataContext = loJsonResponse.StringOf('"@odata.context"')
lcOdataEtag = loJsonResponse.StringOf('"@odata.etag"')
lnPaymenttermscode = loJsonResponse.IntOf("paymenttermscode")
lnIndustrycode = loJsonResponse.IntOf("industrycode")
lnAddress1_latitude = loJsonResponse.IntOf("address1_latitude")
lnMerged = loJsonResponse.BoolOf("merged")
lcAccountnumber = loJsonResponse.StringOf("accountnumber")
lnStatecode = loJsonResponse.IntOf("statecode")
lcEmailaddress1 = loJsonResponse.StringOf("emailaddress1")
lnExchangerate = loJsonResponse.IntOf("exchangerate")
lnOpenrevenue_state = loJsonResponse.IntOf("openrevenue_state")
lcTickersymbol = loJsonResponse.StringOf("tickersymbol")
lcName = loJsonResponse.StringOf("name")
lcWebsiteurl = loJsonResponse.StringOf("websiteurl")
lnOpendeals = loJsonResponse.IntOf("opendeals")
lcModifiedon = loJsonResponse.StringOf("modifiedon")
lcV_owninguser_value = loJsonResponse.StringOf("_owninguser_value")
lcV_primarycontactid_value = loJsonResponse.StringOf("_primarycontactid_value")
lnImportsequencenumber = loJsonResponse.IntOf("importsequencenumber")
lcAddress1_composite = loJsonResponse.StringOf("address1_composite")
lnAddress1_longitude = loJsonResponse.IntOf("address1_longitude")
lnDonotpostalmail = loJsonResponse.BoolOf("donotpostalmail")
lnAccountratingcode = loJsonResponse.IntOf("accountratingcode")
lnNumberofemployees = loJsonResponse.IntOf("numberofemployees")
lnMarketingonly = loJsonResponse.BoolOf("marketingonly")
lnRevenue_base = loJsonResponse.IntOf("revenue_base")
lnPreferredcontactmethodcode = loJsonResponse.IntOf("preferredcontactmethodcode")
lcV_territoryid_value = loJsonResponse.StringOf("_territoryid_value")
lcV_ownerid_value = loJsonResponse.StringOf("_ownerid_value")
lcEntityimage = loJsonResponse.StringOf("entityimage")
lcDescription = loJsonResponse.StringOf("description")
lnCustomersizecode = loJsonResponse.IntOf("customersizecode")
lcEntityimage_url = loJsonResponse.StringOf("entityimage_url")
lcOpenrevenue_date = loJsonResponse.StringOf("openrevenue_date")
lnOpenrevenue_base = loJsonResponse.IntOf("openrevenue_base")
lnDonotemail = loJsonResponse.BoolOf("donotemail")
lnAddress2_shippingmethodcode = loJsonResponse.IntOf("address2_shippingmethodcode")
lnEntityimage_timestamp = loJsonResponse.IntOf("entityimage_timestamp")
lnTimezoneruleversionnumber = loJsonResponse.IntOf("timezoneruleversionnumber")
lnRevenue = loJsonResponse.IntOf("revenue")
lnAddress2_freighttermscode = loJsonResponse.IntOf("address2_freighttermscode")
lnStatuscode = loJsonResponse.IntOf("statuscode")
lcCreatedon = loJsonResponse.StringOf("createdon")
lnMsdyn_travelchargetype = loJsonResponse.IntOf("msdyn_travelchargetype")
lnOpendeals_state = loJsonResponse.IntOf("opendeals_state")
lnOpenrevenue = loJsonResponse.IntOf("openrevenue")
lnDonotsendmm = loJsonResponse.BoolOf("donotsendmm")
lnDonotfax = loJsonResponse.BoolOf("donotfax")
lnDonotbulkpostalmail = loJsonResponse.BoolOf("donotbulkpostalmail")
lcAddress1_country = loJsonResponse.StringOf("address1_country")
lnVersionnumber = loJsonResponse.IntOf("versionnumber")
lcAddress1_line1 = loJsonResponse.StringOf("address1_line1")
lcAddress1_line2 = loJsonResponse.StringOf("address1_line2")
lnCreditonhold = loJsonResponse.BoolOf("creditonhold")
lcTelephone1 = loJsonResponse.StringOf("telephone1")
lcV_owningbusinessunit_value = loJsonResponse.StringOf("_owningbusinessunit_value")
lnDonotphone = loJsonResponse.BoolOf("donotphone")
lcV_transactioncurrencyid_value = loJsonResponse.StringOf("_transactioncurrencyid_value")
lcAccountid = loJsonResponse.StringOf("accountid")
lnDonotbulkemail = loJsonResponse.BoolOf("donotbulkemail")
lcV_modifiedby_value = loJsonResponse.StringOf("_modifiedby_value")
lnFollowemail = loJsonResponse.BoolOf("followemail")
lnBusinesstypecode = loJsonResponse.IntOf("businesstypecode")
lcV_createdby_value = loJsonResponse.StringOf("_createdby_value")
lcAddress1_city = loJsonResponse.StringOf("address1_city")
lnTerritorycode = loJsonResponse.IntOf("territorycode")
lnAddress2_addresstypecode = loJsonResponse.IntOf("address2_addresstypecode")
lnOwnershipcode = loJsonResponse.IntOf("ownershipcode")
lcFax = loJsonResponse.StringOf("fax")
lnMsdyn_taxexempt = loJsonResponse.BoolOf("msdyn_taxexempt")
lcAddress1_addressid = loJsonResponse.StringOf("address1_addressid")
lnParticipatesinworkflow = loJsonResponse.BoolOf("participatesinworkflow")
lnAccountclassificationcode = loJsonResponse.IntOf("accountclassificationcode")
lcOverriddencreatedon = loJsonResponse.StringOf("overriddencreatedon")
lcAddress2_addressid = loJsonResponse.StringOf("address2_addressid")
lcAddress1_postalcode = loJsonResponse.StringOf("address1_postalcode")
lcEntityimageid = loJsonResponse.StringOf("entityimageid")
lnShippingmethodcode = loJsonResponse.IntOf("shippingmethodcode")
lcOpendeals_date = loJsonResponse.StringOf("opendeals_date")
lcLastusedincampaign = loJsonResponse.StringOf("lastusedincampaign")
lcAddress1_name = loJsonResponse.StringOf("address1_name")
lcV_msdyn_billingaccount_value = loJsonResponse.StringOf("_msdyn_billingaccount_value")
lcCreditlimit = loJsonResponse.StringOf("creditlimit")
lcV_msdyn_salestaxcode_value = loJsonResponse.StringOf("_msdyn_salestaxcode_value")
lcTelephone3 = loJsonResponse.StringOf("telephone3")
lcMsdyn_externalaccountid = loJsonResponse.StringOf("msdyn_externalaccountid")
lcAddress1_freighttermscode = loJsonResponse.StringOf("address1_freighttermscode")
lcLastonholdtime = loJsonResponse.StringOf("lastonholdtime")
lcAddress2_line1 = loJsonResponse.StringOf("address2_line1")
lcOnholdtime = loJsonResponse.StringOf("onholdtime")
lcMsdyn_workorderinstructions = loJsonResponse.StringOf("msdyn_workorderinstructions")
lcAddress2_telephone1 = loJsonResponse.StringOf("address2_telephone1")
lcAddress1_fax = loJsonResponse.StringOf("address1_fax")
lcV_createdonbehalfby_value = loJsonResponse.StringOf("_createdonbehalfby_value")
lcAddress2_city = loJsonResponse.StringOf("address2_city")
lcAddress2_latitude = loJsonResponse.StringOf("address2_latitude")
lcCreditlimit_base = loJsonResponse.StringOf("creditlimit_base")
lcAddress1_telephone2 = loJsonResponse.StringOf("address1_telephone2")
lcAging90_base = loJsonResponse.StringOf("aging90_base")
lcAddress2_postalcode = loJsonResponse.StringOf("address2_postalcode")
lcAddress2_name = loJsonResponse.StringOf("address2_name")
lcPrimarysatoriid = loJsonResponse.StringOf("primarysatoriid")
lcV_masterid_value = loJsonResponse.StringOf("_masterid_value")
lcAging30 = loJsonResponse.StringOf("aging30")
lcAddress2_county = loJsonResponse.StringOf("address2_county")
lcV_originatingleadid_value = loJsonResponse.StringOf("_originatingleadid_value")
lcEmailaddress3 = loJsonResponse.StringOf("emailaddress3")
lcAddress1_shippingmethodcode = loJsonResponse.StringOf("address1_shippingmethodcode")
lcInt_facebook = loJsonResponse.StringOf("int_facebook")
lcAddress1_stateorprovince = loJsonResponse.StringOf("address1_stateorprovince")
lcUtcconversiontimezonecode = loJsonResponse.StringOf("utcconversiontimezonecode")
lcSharesoutstanding = loJsonResponse.StringOf("sharesoutstanding")
lcSic = loJsonResponse.StringOf("sic")
lcV_preferredsystemuserid_value = loJsonResponse.StringOf("_preferredsystemuserid_value")
lcAddress2_longitude = loJsonResponse.StringOf("address2_longitude")
lcV_defaultpricelevelid_value = loJsonResponse.StringOf("_defaultpricelevelid_value")
lcAddress1_primarycontactname = loJsonResponse.StringOf("address1_primarycontactname")
lcAddress1_county = loJsonResponse.StringOf("address1_county")
lcAddress2_postofficebox = loJsonResponse.StringOf("address2_postofficebox")
lcV_preferredserviceid_value = loJsonResponse.StringOf("_preferredserviceid_value")
lcAddress1_upszone = loJsonResponse.StringOf("address1_upszone")
lcStageid = loJsonResponse.StringOf("stageid")
lcAddress2_composite = loJsonResponse.StringOf("address2_composite")
lcMarketcap = loJsonResponse.StringOf("marketcap")
lcAging60 = loJsonResponse.StringOf("aging60")
lcCustomertypecode = loJsonResponse.StringOf("customertypecode")
lcMsdyn_travelcharge = loJsonResponse.StringOf("msdyn_travelcharge")
lcAddress1_postofficebox = loJsonResponse.StringOf("address1_postofficebox")
lcV_msdyn_preferredresource_value = loJsonResponse.StringOf("_msdyn_preferredresource_value")
lcYominame = loJsonResponse.StringOf("yominame")
lcAddress2_primarycontactname = loJsonResponse.StringOf("address2_primarycontactname")
lcAddress2_country = loJsonResponse.StringOf("address2_country")
lcV_msdyn_serviceterritory_value = loJsonResponse.StringOf("_msdyn_serviceterritory_value")
lcTraversedpath = loJsonResponse.StringOf("traversedpath")
lcInt_twitter = loJsonResponse.StringOf("int_twitter")
lcAging90 = loJsonResponse.StringOf("aging90")
lcAddress1_telephone1 = loJsonResponse.StringOf("address1_telephone1")
lcMsdyn_taxexemptnumber = loJsonResponse.StringOf("msdyn_taxexemptnumber")
lcAddress2_telephone3 = loJsonResponse.StringOf("address2_telephone3")
lcTelephone2 = loJsonResponse.StringOf("telephone2")
lcV_owningteam_value = loJsonResponse.StringOf("_owningteam_value")
lcAddress2_line2 = loJsonResponse.StringOf("address2_line2")
lcMsdyn_travelcharge_base = loJsonResponse.StringOf("msdyn_travelcharge_base")
lcPrimarytwitterid = loJsonResponse.StringOf("primarytwitterid")
lcTimespentbymeonemailandmeetings = loJsonResponse.StringOf("timespentbymeonemailandmeetings")
lcV_modifiedbyexternalparty_value = loJsonResponse.StringOf("_modifiedbyexternalparty_value")
lcV_slaid_value = loJsonResponse.StringOf("_slaid_value")
lcFtpsiteurl = loJsonResponse.StringOf("ftpsiteurl")
lcV_preferredequipmentid_value = loJsonResponse.StringOf("_preferredequipmentid_value")
lcProcessid = loJsonResponse.StringOf("processid")
lcAddress2_telephone2 = loJsonResponse.StringOf("address2_telephone2")
lcAddress1_addresstypecode = loJsonResponse.StringOf("address1_addresstypecode")
lcAddress1_utcoffset = loJsonResponse.StringOf("address1_utcoffset")
lcV_parentaccountid_value = loJsonResponse.StringOf("_parentaccountid_value")
lcV_createdbyexternalparty_value = loJsonResponse.StringOf("_createdbyexternalparty_value")
lcAddress2_fax = loJsonResponse.StringOf("address2_fax")
lcAging60_base = loJsonResponse.StringOf("aging60_base")
lcV_modifiedonbehalfby_value = loJsonResponse.StringOf("_modifiedonbehalfby_value")
lcStockexchange = loJsonResponse.StringOf("stockexchange")
lcPreferredappointmentdaycode = loJsonResponse.StringOf("preferredappointmentdaycode")
lcAddress1_line3 = loJsonResponse.StringOf("address1_line3")
lcAging30_base = loJsonResponse.StringOf("aging30_base")
lcAddress2_upszone = loJsonResponse.StringOf("address2_upszone")
lcV_slainvokedid_value = loJsonResponse.StringOf("_slainvokedid_value")
lcAddress2_line3 = loJsonResponse.StringOf("address2_line3")
lcAddress2_utcoffset = loJsonResponse.StringOf("address2_utcoffset")
lcAddress2_stateorprovince = loJsonResponse.StringOf("address2_stateorprovince")
lcPreferredappointmenttimecode = loJsonResponse.StringOf("preferredappointmenttimecode")
lcEmailaddress2 = loJsonResponse.StringOf("emailaddress2")
lcMarketcap_base = loJsonResponse.StringOf("marketcap_base")
lcAddress1_telephone3 = loJsonResponse.StringOf("address1_telephone3")
lcAccountcategorycode = loJsonResponse.StringOf("accountcategorycode")

RELEASE loRest
RELEASE loSbResponseBody
RELEASE loJsonResponse

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
}