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

DataFlex Example

Use ChilkatAx-9.5.0-win32.pkg

Procedure Test
    Handle hoRest
    Boolean iSuccess
    Boolean iBTls
    Integer iPort
    Boolean iBAutoReconnect
    Variant vSbResponseBody
    Handle hoSbResponseBody
    Integer iRespStatusCode
    Handle hoJsonResponse
    String sOdataContext
    String sOdataEtag
    Integer iPaymenttermscode
    Integer iIndustrycode
    Integer iAddress1_latitude
    Boolean iMerged
    String sAccountnumber
    Integer iStatecode
    String sEmailaddress1
    Integer iExchangerate
    Integer iOpenrevenue_state
    String sTickersymbol
    String sName
    String sWebsiteurl
    Integer iOpendeals
    String sModifiedon
    String sV_owninguser_value
    String sV_primarycontactid_value
    Integer iImportsequencenumber
    String sAddress1_composite
    Integer iAddress1_longitude
    Boolean iDonotpostalmail
    Integer iAccountratingcode
    Integer iNumberofemployees
    Boolean iMarketingonly
    Integer iRevenue_base
    Integer iPreferredcontactmethodcode
    String sV_territoryid_value
    String sV_ownerid_value
    String sEntityimage
    String sDescription
    Integer iCustomersizecode
    String sEntityimage_url
    String sOpenrevenue_date
    Integer iOpenrevenue_base
    Boolean iDonotemail
    Integer iAddress2_shippingmethodcode
    Integer iEntityimage_timestamp
    Integer iTimezoneruleversionnumber
    Integer iRevenue
    Integer iAddress2_freighttermscode
    Integer iStatuscode
    String sCreatedon
    Integer iMsdyn_travelchargetype
    Integer iOpendeals_state
    Integer iOpenrevenue
    Boolean iDonotsendmm
    Boolean iDonotfax
    Boolean iDonotbulkpostalmail
    String sAddress1_country
    Integer iVersionnumber
    String sAddress1_line1
    String sAddress1_line2
    Boolean iCreditonhold
    String sTelephone1
    String sV_owningbusinessunit_value
    Boolean iDonotphone
    String sV_transactioncurrencyid_value
    String sAccountid
    Boolean iDonotbulkemail
    String sV_modifiedby_value
    Boolean iFollowemail
    Integer iBusinesstypecode
    String sV_createdby_value
    String sAddress1_city
    Integer iTerritorycode
    Integer iAddress2_addresstypecode
    Integer iOwnershipcode
    String sFax
    Boolean iMsdyn_taxexempt
    String sAddress1_addressid
    Boolean iParticipatesinworkflow
    Integer iAccountclassificationcode
    String sOverriddencreatedon
    String sAddress2_addressid
    String sAddress1_postalcode
    String sEntityimageid
    Integer iShippingmethodcode
    String sOpendeals_date
    String sLastusedincampaign
    String sAddress1_name
    String sV_msdyn_billingaccount_value
    String sCreditlimit
    String sV_msdyn_salestaxcode_value
    String sTelephone3
    String sMsdyn_externalaccountid
    String sAddress1_freighttermscode
    String sLastonholdtime
    String sAddress2_line1
    String sOnholdtime
    String sMsdyn_workorderinstructions
    String sAddress2_telephone1
    String sAddress1_fax
    String sV_createdonbehalfby_value
    String sAddress2_city
    String sAddress2_latitude
    String sCreditlimit_base
    String sAddress1_telephone2
    String sAging90_base
    String sAddress2_postalcode
    String sAddress2_name
    String sPrimarysatoriid
    String sV_masterid_value
    String sAging30
    String sAddress2_county
    String sV_originatingleadid_value
    String sEmailaddress3
    String sAddress1_shippingmethodcode
    String sInt_facebook
    String sAddress1_stateorprovince
    String sUtcconversiontimezonecode
    String sSharesoutstanding
    String sSic
    String sV_preferredsystemuserid_value
    String sAddress2_longitude
    String sV_defaultpricelevelid_value
    String sAddress1_primarycontactname
    String sAddress1_county
    String sAddress2_postofficebox
    String sV_preferredserviceid_value
    String sAddress1_upszone
    String sStageid
    String sAddress2_composite
    String sMarketcap
    String sAging60
    String sCustomertypecode
    String sMsdyn_travelcharge
    String sAddress1_postofficebox
    String sV_msdyn_preferredresource_value
    String sYominame
    String sAddress2_primarycontactname
    String sAddress2_country
    String sV_msdyn_serviceterritory_value
    String sTraversedpath
    String sInt_twitter
    String sAging90
    String sAddress1_telephone1
    String sMsdyn_taxexemptnumber
    String sAddress2_telephone3
    String sTelephone2
    String sV_owningteam_value
    String sAddress2_line2
    String sMsdyn_travelcharge_base
    String sPrimarytwitterid
    String sTimespentbymeonemailandmeetings
    String sV_modifiedbyexternalparty_value
    String sV_slaid_value
    String sFtpsiteurl
    String sV_preferredequipmentid_value
    String sProcessid
    String sAddress2_telephone2
    String sAddress1_addresstypecode
    String sAddress1_utcoffset
    String sV_parentaccountid_value
    String sV_createdbyexternalparty_value
    String sAddress2_fax
    String sAging60_base
    String sV_modifiedonbehalfby_value
    String sStockexchange
    String sPreferredappointmentdaycode
    String sAddress1_line3
    String sAging30_base
    String sAddress2_upszone
    String sV_slainvokedid_value
    String sAddress2_line3
    String sAddress2_utcoffset
    String sAddress2_stateorprovince
    String sPreferredappointmenttimecode
    String sEmailaddress2
    String sMarketcap_base
    String sAddress1_telephone3
    String sAccountcategorycode
    String sTemp1
    Integer iTemp1

    Get Create (RefClass(cComChilkatRest)) To hoRest
    If (Not(IsComObjectCreated(hoRest))) Begin
        Send CreateComObject of hoRest
    End

    //  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)
    Move True To iBTls
    Move 443 To iPort
    Move True To iBAutoReconnect
    Get ComConnect Of hoRest "my-dynamics-domain.api.crm.dynamics.com" iPort iBTls iBAutoReconnect To iSuccess
    If (iSuccess <> True) Begin
        Get ComConnectFailReason Of hoRest To iTemp1
        Showln "ConnectFailReason: " iTemp1
        Get ComLastErrorText Of hoRest To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get ComAddHeader Of hoRest "OData-MaxVersion" "4.0" To iSuccess
    Get ComAddHeader Of hoRest "Accept" "application/json" To iSuccess
    Get ComAddHeader Of hoRest "OData-Version" "4.0" To iSuccess
    Get ComAddHeader Of hoRest "Authorization" "Bearer DYNAMICS_CRM_ACCESS_TOKEN" To iSuccess

    Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponseBody
    If (Not(IsComObjectCreated(hoSbResponseBody))) Begin
        Send CreateComObject of hoSbResponseBody
    End
    Get pvComObject of hoSbResponseBody to vSbResponseBody
    Get ComFullRequestNoBodySb Of hoRest "GET" "/api/data/v9.0/accounts(aca19cdd-88df-e311-b8e5-6c3be5a8b200)" vSbResponseBody To iSuccess
    If (iSuccess <> True) Begin
        Get ComLastErrorText Of hoRest To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get ComResponseStatusCode Of hoRest To iRespStatusCode
    If (iRespStatusCode >= 400) Begin
        Showln "Response Status Code = " iRespStatusCode
        Showln "Response Header:"
        Get ComResponseHeader Of hoRest To sTemp1
        Showln sTemp1
        Showln "Response Body:"
        Get ComGetAsString Of hoSbResponseBody To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get Create (RefClass(cComChilkatJsonObject)) To hoJsonResponse
    If (Not(IsComObjectCreated(hoJsonResponse))) Begin
        Send CreateComObject of hoJsonResponse
    End
    Get pvComObject of hoSbResponseBody to vSbResponseBody
    Get ComLoadSb Of hoJsonResponse vSbResponseBody To iSuccess

    Get ComStringOf Of hoJsonResponse '"@odata.context"' To sOdataContext
    Get ComStringOf Of hoJsonResponse '"@odata.etag"' To sOdataEtag
    Get ComIntOf Of hoJsonResponse "paymenttermscode" To iPaymenttermscode
    Get ComIntOf Of hoJsonResponse "industrycode" To iIndustrycode
    Get ComIntOf Of hoJsonResponse "address1_latitude" To iAddress1_latitude
    Get ComBoolOf Of hoJsonResponse "merged" To iMerged
    Get ComStringOf Of hoJsonResponse "accountnumber" To sAccountnumber
    Get ComIntOf Of hoJsonResponse "statecode" To iStatecode
    Get ComStringOf Of hoJsonResponse "emailaddress1" To sEmailaddress1
    Get ComIntOf Of hoJsonResponse "exchangerate" To iExchangerate
    Get ComIntOf Of hoJsonResponse "openrevenue_state" To iOpenrevenue_state
    Get ComStringOf Of hoJsonResponse "tickersymbol" To sTickersymbol
    Get ComStringOf Of hoJsonResponse "name" To sName
    Get ComStringOf Of hoJsonResponse "websiteurl" To sWebsiteurl
    Get ComIntOf Of hoJsonResponse "opendeals" To iOpendeals
    Get ComStringOf Of hoJsonResponse "modifiedon" To sModifiedon
    Get ComStringOf Of hoJsonResponse "_owninguser_value" To sV_owninguser_value
    Get ComStringOf Of hoJsonResponse "_primarycontactid_value" To sV_primarycontactid_value
    Get ComIntOf Of hoJsonResponse "importsequencenumber" To iImportsequencenumber
    Get ComStringOf Of hoJsonResponse "address1_composite" To sAddress1_composite
    Get ComIntOf Of hoJsonResponse "address1_longitude" To iAddress1_longitude
    Get ComBoolOf Of hoJsonResponse "donotpostalmail" To iDonotpostalmail
    Get ComIntOf Of hoJsonResponse "accountratingcode" To iAccountratingcode
    Get ComIntOf Of hoJsonResponse "numberofemployees" To iNumberofemployees
    Get ComBoolOf Of hoJsonResponse "marketingonly" To iMarketingonly
    Get ComIntOf Of hoJsonResponse "revenue_base" To iRevenue_base
    Get ComIntOf Of hoJsonResponse "preferredcontactmethodcode" To iPreferredcontactmethodcode
    Get ComStringOf Of hoJsonResponse "_territoryid_value" To sV_territoryid_value
    Get ComStringOf Of hoJsonResponse "_ownerid_value" To sV_ownerid_value
    Get ComStringOf Of hoJsonResponse "entityimage" To sEntityimage
    Get ComStringOf Of hoJsonResponse "description" To sDescription
    Get ComIntOf Of hoJsonResponse "customersizecode" To iCustomersizecode
    Get ComStringOf Of hoJsonResponse "entityimage_url" To sEntityimage_url
    Get ComStringOf Of hoJsonResponse "openrevenue_date" To sOpenrevenue_date
    Get ComIntOf Of hoJsonResponse "openrevenue_base" To iOpenrevenue_base
    Get ComBoolOf Of hoJsonResponse "donotemail" To iDonotemail
    Get ComIntOf Of hoJsonResponse "address2_shippingmethodcode" To iAddress2_shippingmethodcode
    Get ComIntOf Of hoJsonResponse "entityimage_timestamp" To iEntityimage_timestamp
    Get ComIntOf Of hoJsonResponse "timezoneruleversionnumber" To iTimezoneruleversionnumber
    Get ComIntOf Of hoJsonResponse "revenue" To iRevenue
    Get ComIntOf Of hoJsonResponse "address2_freighttermscode" To iAddress2_freighttermscode
    Get ComIntOf Of hoJsonResponse "statuscode" To iStatuscode
    Get ComStringOf Of hoJsonResponse "createdon" To sCreatedon
    Get ComIntOf Of hoJsonResponse "msdyn_travelchargetype" To iMsdyn_travelchargetype
    Get ComIntOf Of hoJsonResponse "opendeals_state" To iOpendeals_state
    Get ComIntOf Of hoJsonResponse "openrevenue" To iOpenrevenue
    Get ComBoolOf Of hoJsonResponse "donotsendmm" To iDonotsendmm
    Get ComBoolOf Of hoJsonResponse "donotfax" To iDonotfax
    Get ComBoolOf Of hoJsonResponse "donotbulkpostalmail" To iDonotbulkpostalmail
    Get ComStringOf Of hoJsonResponse "address1_country" To sAddress1_country
    Get ComIntOf Of hoJsonResponse "versionnumber" To iVersionnumber
    Get ComStringOf Of hoJsonResponse "address1_line1" To sAddress1_line1
    Get ComStringOf Of hoJsonResponse "address1_line2" To sAddress1_line2
    Get ComBoolOf Of hoJsonResponse "creditonhold" To iCreditonhold
    Get ComStringOf Of hoJsonResponse "telephone1" To sTelephone1
    Get ComStringOf Of hoJsonResponse "_owningbusinessunit_value" To sV_owningbusinessunit_value
    Get ComBoolOf Of hoJsonResponse "donotphone" To iDonotphone
    Get ComStringOf Of hoJsonResponse "_transactioncurrencyid_value" To sV_transactioncurrencyid_value
    Get ComStringOf Of hoJsonResponse "accountid" To sAccountid
    Get ComBoolOf Of hoJsonResponse "donotbulkemail" To iDonotbulkemail
    Get ComStringOf Of hoJsonResponse "_modifiedby_value" To sV_modifiedby_value
    Get ComBoolOf Of hoJsonResponse "followemail" To iFollowemail
    Get ComIntOf Of hoJsonResponse "businesstypecode" To iBusinesstypecode
    Get ComStringOf Of hoJsonResponse "_createdby_value" To sV_createdby_value
    Get ComStringOf Of hoJsonResponse "address1_city" To sAddress1_city
    Get ComIntOf Of hoJsonResponse "territorycode" To iTerritorycode
    Get ComIntOf Of hoJsonResponse "address2_addresstypecode" To iAddress2_addresstypecode
    Get ComIntOf Of hoJsonResponse "ownershipcode" To iOwnershipcode
    Get ComStringOf Of hoJsonResponse "fax" To sFax
    Get ComBoolOf Of hoJsonResponse "msdyn_taxexempt" To iMsdyn_taxexempt
    Get ComStringOf Of hoJsonResponse "address1_addressid" To sAddress1_addressid
    Get ComBoolOf Of hoJsonResponse "participatesinworkflow" To iParticipatesinworkflow
    Get ComIntOf Of hoJsonResponse "accountclassificationcode" To iAccountclassificationcode
    Get ComStringOf Of hoJsonResponse "overriddencreatedon" To sOverriddencreatedon
    Get ComStringOf Of hoJsonResponse "address2_addressid" To sAddress2_addressid
    Get ComStringOf Of hoJsonResponse "address1_postalcode" To sAddress1_postalcode
    Get ComStringOf Of hoJsonResponse "entityimageid" To sEntityimageid
    Get ComIntOf Of hoJsonResponse "shippingmethodcode" To iShippingmethodcode
    Get ComStringOf Of hoJsonResponse "opendeals_date" To sOpendeals_date
    Get ComStringOf Of hoJsonResponse "lastusedincampaign" To sLastusedincampaign
    Get ComStringOf Of hoJsonResponse "address1_name" To sAddress1_name
    Get ComStringOf Of hoJsonResponse "_msdyn_billingaccount_value" To sV_msdyn_billingaccount_value
    Get ComStringOf Of hoJsonResponse "creditlimit" To sCreditlimit
    Get ComStringOf Of hoJsonResponse "_msdyn_salestaxcode_value" To sV_msdyn_salestaxcode_value
    Get ComStringOf Of hoJsonResponse "telephone3" To sTelephone3
    Get ComStringOf Of hoJsonResponse "msdyn_externalaccountid" To sMsdyn_externalaccountid
    Get ComStringOf Of hoJsonResponse "address1_freighttermscode" To sAddress1_freighttermscode
    Get ComStringOf Of hoJsonResponse "lastonholdtime" To sLastonholdtime
    Get ComStringOf Of hoJsonResponse "address2_line1" To sAddress2_line1
    Get ComStringOf Of hoJsonResponse "onholdtime" To sOnholdtime
    Get ComStringOf Of hoJsonResponse "msdyn_workorderinstructions" To sMsdyn_workorderinstructions
    Get ComStringOf Of hoJsonResponse "address2_telephone1" To sAddress2_telephone1
    Get ComStringOf Of hoJsonResponse "address1_fax" To sAddress1_fax
    Get ComStringOf Of hoJsonResponse "_createdonbehalfby_value" To sV_createdonbehalfby_value
    Get ComStringOf Of hoJsonResponse "address2_city" To sAddress2_city
    Get ComStringOf Of hoJsonResponse "address2_latitude" To sAddress2_latitude
    Get ComStringOf Of hoJsonResponse "creditlimit_base" To sCreditlimit_base
    Get ComStringOf Of hoJsonResponse "address1_telephone2" To sAddress1_telephone2
    Get ComStringOf Of hoJsonResponse "aging90_base" To sAging90_base
    Get ComStringOf Of hoJsonResponse "address2_postalcode" To sAddress2_postalcode
    Get ComStringOf Of hoJsonResponse "address2_name" To sAddress2_name
    Get ComStringOf Of hoJsonResponse "primarysatoriid" To sPrimarysatoriid
    Get ComStringOf Of hoJsonResponse "_masterid_value" To sV_masterid_value
    Get ComStringOf Of hoJsonResponse "aging30" To sAging30
    Get ComStringOf Of hoJsonResponse "address2_county" To sAddress2_county
    Get ComStringOf Of hoJsonResponse "_originatingleadid_value" To sV_originatingleadid_value
    Get ComStringOf Of hoJsonResponse "emailaddress3" To sEmailaddress3
    Get ComStringOf Of hoJsonResponse "address1_shippingmethodcode" To sAddress1_shippingmethodcode
    Get ComStringOf Of hoJsonResponse "int_facebook" To sInt_facebook
    Get ComStringOf Of hoJsonResponse "address1_stateorprovince" To sAddress1_stateorprovince
    Get ComStringOf Of hoJsonResponse "utcconversiontimezonecode" To sUtcconversiontimezonecode
    Get ComStringOf Of hoJsonResponse "sharesoutstanding" To sSharesoutstanding
    Get ComStringOf Of hoJsonResponse "sic" To sSic
    Get ComStringOf Of hoJsonResponse "_preferredsystemuserid_value" To sV_preferredsystemuserid_value
    Get ComStringOf Of hoJsonResponse "address2_longitude" To sAddress2_longitude
    Get ComStringOf Of hoJsonResponse "_defaultpricelevelid_value" To sV_defaultpricelevelid_value
    Get ComStringOf Of hoJsonResponse "address1_primarycontactname" To sAddress1_primarycontactname
    Get ComStringOf Of hoJsonResponse "address1_county" To sAddress1_county
    Get ComStringOf Of hoJsonResponse "address2_postofficebox" To sAddress2_postofficebox
    Get ComStringOf Of hoJsonResponse "_preferredserviceid_value" To sV_preferredserviceid_value
    Get ComStringOf Of hoJsonResponse "address1_upszone" To sAddress1_upszone
    Get ComStringOf Of hoJsonResponse "stageid" To sStageid
    Get ComStringOf Of hoJsonResponse "address2_composite" To sAddress2_composite
    Get ComStringOf Of hoJsonResponse "marketcap" To sMarketcap
    Get ComStringOf Of hoJsonResponse "aging60" To sAging60
    Get ComStringOf Of hoJsonResponse "customertypecode" To sCustomertypecode
    Get ComStringOf Of hoJsonResponse "msdyn_travelcharge" To sMsdyn_travelcharge
    Get ComStringOf Of hoJsonResponse "address1_postofficebox" To sAddress1_postofficebox
    Get ComStringOf Of hoJsonResponse "_msdyn_preferredresource_value" To sV_msdyn_preferredresource_value
    Get ComStringOf Of hoJsonResponse "yominame" To sYominame
    Get ComStringOf Of hoJsonResponse "address2_primarycontactname" To sAddress2_primarycontactname
    Get ComStringOf Of hoJsonResponse "address2_country" To sAddress2_country
    Get ComStringOf Of hoJsonResponse "_msdyn_serviceterritory_value" To sV_msdyn_serviceterritory_value
    Get ComStringOf Of hoJsonResponse "traversedpath" To sTraversedpath
    Get ComStringOf Of hoJsonResponse "int_twitter" To sInt_twitter
    Get ComStringOf Of hoJsonResponse "aging90" To sAging90
    Get ComStringOf Of hoJsonResponse "address1_telephone1" To sAddress1_telephone1
    Get ComStringOf Of hoJsonResponse "msdyn_taxexemptnumber" To sMsdyn_taxexemptnumber
    Get ComStringOf Of hoJsonResponse "address2_telephone3" To sAddress2_telephone3
    Get ComStringOf Of hoJsonResponse "telephone2" To sTelephone2
    Get ComStringOf Of hoJsonResponse "_owningteam_value" To sV_owningteam_value
    Get ComStringOf Of hoJsonResponse "address2_line2" To sAddress2_line2
    Get ComStringOf Of hoJsonResponse "msdyn_travelcharge_base" To sMsdyn_travelcharge_base
    Get ComStringOf Of hoJsonResponse "primarytwitterid" To sPrimarytwitterid
    Get ComStringOf Of hoJsonResponse "timespentbymeonemailandmeetings" To sTimespentbymeonemailandmeetings
    Get ComStringOf Of hoJsonResponse "_modifiedbyexternalparty_value" To sV_modifiedbyexternalparty_value
    Get ComStringOf Of hoJsonResponse "_slaid_value" To sV_slaid_value
    Get ComStringOf Of hoJsonResponse "ftpsiteurl" To sFtpsiteurl
    Get ComStringOf Of hoJsonResponse "_preferredequipmentid_value" To sV_preferredequipmentid_value
    Get ComStringOf Of hoJsonResponse "processid" To sProcessid
    Get ComStringOf Of hoJsonResponse "address2_telephone2" To sAddress2_telephone2
    Get ComStringOf Of hoJsonResponse "address1_addresstypecode" To sAddress1_addresstypecode
    Get ComStringOf Of hoJsonResponse "address1_utcoffset" To sAddress1_utcoffset
    Get ComStringOf Of hoJsonResponse "_parentaccountid_value" To sV_parentaccountid_value
    Get ComStringOf Of hoJsonResponse "_createdbyexternalparty_value" To sV_createdbyexternalparty_value
    Get ComStringOf Of hoJsonResponse "address2_fax" To sAddress2_fax
    Get ComStringOf Of hoJsonResponse "aging60_base" To sAging60_base
    Get ComStringOf Of hoJsonResponse "_modifiedonbehalfby_value" To sV_modifiedonbehalfby_value
    Get ComStringOf Of hoJsonResponse "stockexchange" To sStockexchange
    Get ComStringOf Of hoJsonResponse "preferredappointmentdaycode" To sPreferredappointmentdaycode
    Get ComStringOf Of hoJsonResponse "address1_line3" To sAddress1_line3
    Get ComStringOf Of hoJsonResponse "aging30_base" To sAging30_base
    Get ComStringOf Of hoJsonResponse "address2_upszone" To sAddress2_upszone
    Get ComStringOf Of hoJsonResponse "_slainvokedid_value" To sV_slainvokedid_value
    Get ComStringOf Of hoJsonResponse "address2_line3" To sAddress2_line3
    Get ComStringOf Of hoJsonResponse "address2_utcoffset" To sAddress2_utcoffset
    Get ComStringOf Of hoJsonResponse "address2_stateorprovince" To sAddress2_stateorprovince
    Get ComStringOf Of hoJsonResponse "preferredappointmenttimecode" To sPreferredappointmenttimecode
    Get ComStringOf Of hoJsonResponse "emailaddress2" To sEmailaddress2
    Get ComStringOf Of hoJsonResponse "marketcap_base" To sMarketcap_base
    Get ComStringOf Of hoJsonResponse "address1_telephone3" To sAddress1_telephone3
    Get ComStringOf Of hoJsonResponse "accountcategorycode" To sAccountcategorycode


End_Procedure

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
}