VB.NET 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"

VB.NET Example

Dim rest As New Chilkat.Rest
Dim success As Boolean

'  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)
Dim bTls As Boolean = True
Dim port As Integer = 443
Dim bAutoReconnect As Boolean = True
success = rest.Connect("my-dynamics-domain.api.crm.dynamics.com",port,bTls,bAutoReconnect)
If (success <> True) Then
    Debug.WriteLine("ConnectFailReason: " & rest.ConnectFailReason)
    Debug.WriteLine(rest.LastErrorText)
    Exit Sub
End If


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

Dim sbResponseBody As New Chilkat.StringBuilder
success = rest.FullRequestNoBodySb("GET","/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)",sbResponseBody)
If (success <> True) Then
    Debug.WriteLine(rest.LastErrorText)
    Exit Sub
End If

Dim respStatusCode As Integer = rest.ResponseStatusCode
If (respStatusCode >= 400) Then
    Debug.WriteLine("Response Status Code = " & respStatusCode)
    Debug.WriteLine("Response Header:")
    Debug.WriteLine(rest.ResponseHeader)
    Debug.WriteLine("Response Body:")
    Debug.WriteLine(sbResponseBody.GetAsString())
    Exit Sub
End If


Dim jsonResponse As New Chilkat.JsonObject
jsonResponse.LoadSb(sbResponseBody)


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