DataFlex Dynamics CRM: Retrieve a Single Contact

Back to Index

Returns the full contact record for a given contactid.

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/contacts(1fa1e5b9-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 iCustomertypecode
    Integer iAddress1_latitude
    String sBirthdate
    Boolean iMerged
    Integer iGendercode
    Integer iTerritorycode
    String sEmailaddress1
    Integer iHaschildrencode
    Integer iPreferredappointmenttimecode
    Boolean iIsbackofficecustomer
    String sModifiedon
    String sV_owninguser_value
    Integer iImportsequencenumber
    String sAddress1_composite
    Integer iAddress1_longitude
    Boolean iMarketingonly
    Boolean iDonotphone
    Integer iPreferredcontactmethodcode
    Integer iEducationcode
    String sV_ownerid_value
    Integer iCustomersizecode
    String sFirstname
    Boolean iDonotpostalmail
    String sYomifullname
    Integer iAddress2_addresstypecode
    Boolean iDonotemail
    Integer iAddress2_shippingmethodcode
    String sFullname
    Integer iTimezoneruleversionnumber
    String sAddress1_addressid
    Integer iAddress2_freighttermscode
    Integer iStatuscode
    String sCreatedon
    String sAddress1_stateorprovince
    String sLastname
    Boolean iDonotsendmm
    Boolean iDonotfax
    Integer iLeadsourcecode
    String sAddress1_country
    Integer iVersionnumber
    String sAddress1_line1
    Boolean iCreditonhold
    String sTelephone1
    String sV_owningbusinessunit_value
    String sAddress3_addressid
    Boolean iDonotbulkemail
    String sV_modifiedby_value
    Boolean iFollowemail
    Integer iShippingmethodcode
    String sV_createdby_value
    String sAddress1_city
    Boolean iDonotbulkpostalmail
    String sV_parentcustomerid_value
    String sContactid
    Boolean iParticipatesinworkflow
    Integer iStatecode
    String sOverriddencreatedon
    String sAddress2_addressid
    String sAddress1_postalcode
    Integer iInt_kloutscore
    String sSpousesname
    String sEmailaddress3
    String sAddress3_telephone3
    String sMobilephone
    String sUtcconversiontimezonecode
    String sV_preferredserviceid_value
    String sAddress3_shippingmethodcode
    String sInt_twitterservice
    String sAnnualincome
    String sFax
    String sTelephone3
    String sAddress1_primarycontactname
    String sAddress3_city
    String sLastonholdtime
    String sAddress2_stateorprovince
    String sAddress2_line1
    String sAssistantphone
    String sLastusedincampaign
    String sAddress3_freighttermscode
    String sPager
    String sEmployeeid
    String sManagername
    String sAddress1_name
    String sDepartment
    String sAddress3_country
    String sAddress2_telephone1
    String sAddress2_primarycontactname
    String sAddress2_latitude
    String sAddress3_latitude
    String sAddress2_postalcode
    String sEntityimage_timestamp
    String sV_originatingleadid_value
    String sV_masterid_value
    String sV_createdonbehalfby_value
    String sAddress3_postofficebox
    String sSubscriptionid
    String sBusiness2
    String sAddress3_county
    String sAddress1_telephone2
    String sAddress1_freighttermscode
    String sAddress3_addresstypecode
    String sAddress1_addresstypecode
    String sAging90_base
    String sAddress3_primarycontactname
    String sFamilystatuscode
    String sHome2
    String sInt_kloutscoreservice
    String sAddress2_utcoffset
    String sAging60
    String sTelephone2
    String sYomimiddlename
    String sV_modifiedonbehalfby_value
    String sJobtitle
    String sAddress3_utcoffset
    String sAddress1_telephone3
    String sAddress2_line2
    String sCreditlimit_base
    String sAddress3_line1
    String sAddress1_county
    String sV_createdbyexternalparty_value
    String sEntityimageid
    String sProcessid
    String sInt_facebook
    String sDescription
    String sAddress1_fax
    String sAddress3_line2
    String sExternaluseridentifier
    String sInt_facebookservice
    String sAging30_base
    String sV_callback
    String sEmailaddress2
    String sAddress2_line3
    String sManagerphone
    String sWebsiteurl
    String sExchangerate
    String sAddress1_telephone1
    String sAddress3_composite
    String sAddress3_fax
    String sChildrensnames
    String sV_owningteam_value
    String sNumberofchildren
    String sAddress2_postofficebox
    String sAging90
    String sAging60_base
    String sV_transactioncurrencyid_value
    String sEntityimage
    String sV_modifiedbyexternalparty_value
    String sPaymenttermscode
    String sAddress3_name
    String sFtpsiteurl
    String sAddress1_shippingmethodcode
    String sV_preferredsystemuserid_value
    String sAddress2_telephone2
    String sV_slainvokedid_value
    String sAddress3_telephone1
    String sNickname
    String sAddress1_postofficebox
    String sV_preferredequipmentid_value
    String sAssistantname
    String sAddress2_country
    String sV_accountid_value
    String sAddress2_name
    String sStageid
    String sAddress3_longitude
    String sOnholdtime
    String sAddress2_telephone3
    String sAddress3_upszone
    String sAging30
    String sAddress2_upszone
    String sAddress1_upszone
    String sCreditlimit
    String sSalutation
    String sTraversedpath
    String sAccountrolecode
    String sAddress1_utcoffset
    String sGovernmentid
    String sAnnualincome_base
    String sAddress3_stateorprovince
    String sAddress3_postalcode
    String sAddress2_city
    String sMsdyn_gdproptout
    String sCompany
    String sAddress1_line2
    String sAddress2_longitude
    String sInt_twitter
    String sAddress3_telephone2
    String sYomifirstname
    String sAddress2_composite
    String sAddress2_county
    String sSuffix
    String sAnniversary
    String sV_parentcontactid_value
    String sAddress2_fax
    String sYomilastname
    String sPreferredappointmentdaycode
    String sEntityimage_url
    String sAddress1_line3
    String sV_defaultpricelevelid_value
    String sV_slaid_value
    String sMiddlename
    String sAddress3_line3
    String sTimespentbymeonemailandmeetings
    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/contacts(1fa1e5b9-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/contacts(1fa1e5b9-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 "customertypecode" To iCustomertypecode
    Get ComIntOf Of hoJsonResponse "address1_latitude" To iAddress1_latitude
    Get ComStringOf Of hoJsonResponse "birthdate" To sBirthdate
    Get ComBoolOf Of hoJsonResponse "merged" To iMerged
    Get ComIntOf Of hoJsonResponse "gendercode" To iGendercode
    Get ComIntOf Of hoJsonResponse "territorycode" To iTerritorycode
    Get ComStringOf Of hoJsonResponse "emailaddress1" To sEmailaddress1
    Get ComIntOf Of hoJsonResponse "haschildrencode" To iHaschildrencode
    Get ComIntOf Of hoJsonResponse "preferredappointmenttimecode" To iPreferredappointmenttimecode
    Get ComBoolOf Of hoJsonResponse "isbackofficecustomer" To iIsbackofficecustomer
    Get ComStringOf Of hoJsonResponse "modifiedon" To sModifiedon
    Get ComStringOf Of hoJsonResponse "_owninguser_value" To sV_owninguser_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 "marketingonly" To iMarketingonly
    Get ComBoolOf Of hoJsonResponse "donotphone" To iDonotphone
    Get ComIntOf Of hoJsonResponse "preferredcontactmethodcode" To iPreferredcontactmethodcode
    Get ComIntOf Of hoJsonResponse "educationcode" To iEducationcode
    Get ComStringOf Of hoJsonResponse "_ownerid_value" To sV_ownerid_value
    Get ComIntOf Of hoJsonResponse "customersizecode" To iCustomersizecode
    Get ComStringOf Of hoJsonResponse "firstname" To sFirstname
    Get ComBoolOf Of hoJsonResponse "donotpostalmail" To iDonotpostalmail
    Get ComStringOf Of hoJsonResponse "yomifullname" To sYomifullname
    Get ComIntOf Of hoJsonResponse "address2_addresstypecode" To iAddress2_addresstypecode
    Get ComBoolOf Of hoJsonResponse "donotemail" To iDonotemail
    Get ComIntOf Of hoJsonResponse "address2_shippingmethodcode" To iAddress2_shippingmethodcode
    Get ComStringOf Of hoJsonResponse "fullname" To sFullname
    Get ComIntOf Of hoJsonResponse "timezoneruleversionnumber" To iTimezoneruleversionnumber
    Get ComStringOf Of hoJsonResponse "address1_addressid" To sAddress1_addressid
    Get ComIntOf Of hoJsonResponse "address2_freighttermscode" To iAddress2_freighttermscode
    Get ComIntOf Of hoJsonResponse "statuscode" To iStatuscode
    Get ComStringOf Of hoJsonResponse "createdon" To sCreatedon
    Get ComStringOf Of hoJsonResponse "address1_stateorprovince" To sAddress1_stateorprovince
    Get ComStringOf Of hoJsonResponse "lastname" To sLastname
    Get ComBoolOf Of hoJsonResponse "donotsendmm" To iDonotsendmm
    Get ComBoolOf Of hoJsonResponse "donotfax" To iDonotfax
    Get ComIntOf Of hoJsonResponse "leadsourcecode" To iLeadsourcecode
    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 ComBoolOf Of hoJsonResponse "creditonhold" To iCreditonhold
    Get ComStringOf Of hoJsonResponse "telephone1" To sTelephone1
    Get ComStringOf Of hoJsonResponse "_owningbusinessunit_value" To sV_owningbusinessunit_value
    Get ComStringOf Of hoJsonResponse "address3_addressid" To sAddress3_addressid
    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 "shippingmethodcode" To iShippingmethodcode
    Get ComStringOf Of hoJsonResponse "_createdby_value" To sV_createdby_value
    Get ComStringOf Of hoJsonResponse "address1_city" To sAddress1_city
    Get ComBoolOf Of hoJsonResponse "donotbulkpostalmail" To iDonotbulkpostalmail
    Get ComStringOf Of hoJsonResponse "_parentcustomerid_value" To sV_parentcustomerid_value
    Get ComStringOf Of hoJsonResponse "contactid" To sContactid
    Get ComBoolOf Of hoJsonResponse "participatesinworkflow" To iParticipatesinworkflow
    Get ComIntOf Of hoJsonResponse "statecode" To iStatecode
    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 ComIntOf Of hoJsonResponse "int_kloutscore" To iInt_kloutscore
    Get ComStringOf Of hoJsonResponse "spousesname" To sSpousesname
    Get ComStringOf Of hoJsonResponse "emailaddress3" To sEmailaddress3
    Get ComStringOf Of hoJsonResponse "address3_telephone3" To sAddress3_telephone3
    Get ComStringOf Of hoJsonResponse "mobilephone" To sMobilephone
    Get ComStringOf Of hoJsonResponse "utcconversiontimezonecode" To sUtcconversiontimezonecode
    Get ComStringOf Of hoJsonResponse "_preferredserviceid_value" To sV_preferredserviceid_value
    Get ComStringOf Of hoJsonResponse "address3_shippingmethodcode" To sAddress3_shippingmethodcode
    Get ComStringOf Of hoJsonResponse "int_twitterservice" To sInt_twitterservice
    Get ComStringOf Of hoJsonResponse "annualincome" To sAnnualincome
    Get ComStringOf Of hoJsonResponse "fax" To sFax
    Get ComStringOf Of hoJsonResponse "telephone3" To sTelephone3
    Get ComStringOf Of hoJsonResponse "address1_primarycontactname" To sAddress1_primarycontactname
    Get ComStringOf Of hoJsonResponse "address3_city" To sAddress3_city
    Get ComStringOf Of hoJsonResponse "lastonholdtime" To sLastonholdtime
    Get ComStringOf Of hoJsonResponse "address2_stateorprovince" To sAddress2_stateorprovince
    Get ComStringOf Of hoJsonResponse "address2_line1" To sAddress2_line1
    Get ComStringOf Of hoJsonResponse "assistantphone" To sAssistantphone
    Get ComStringOf Of hoJsonResponse "lastusedincampaign" To sLastusedincampaign
    Get ComStringOf Of hoJsonResponse "address3_freighttermscode" To sAddress3_freighttermscode
    Get ComStringOf Of hoJsonResponse "pager" To sPager
    Get ComStringOf Of hoJsonResponse "employeeid" To sEmployeeid
    Get ComStringOf Of hoJsonResponse "managername" To sManagername
    Get ComStringOf Of hoJsonResponse "address1_name" To sAddress1_name
    Get ComStringOf Of hoJsonResponse "department" To sDepartment
    Get ComStringOf Of hoJsonResponse "address3_country" To sAddress3_country
    Get ComStringOf Of hoJsonResponse "address2_telephone1" To sAddress2_telephone1
    Get ComStringOf Of hoJsonResponse "address2_primarycontactname" To sAddress2_primarycontactname
    Get ComStringOf Of hoJsonResponse "address2_latitude" To sAddress2_latitude
    Get ComStringOf Of hoJsonResponse "address3_latitude" To sAddress3_latitude
    Get ComStringOf Of hoJsonResponse "address2_postalcode" To sAddress2_postalcode
    Get ComStringOf Of hoJsonResponse "entityimage_timestamp" To sEntityimage_timestamp
    Get ComStringOf Of hoJsonResponse "_originatingleadid_value" To sV_originatingleadid_value
    Get ComStringOf Of hoJsonResponse "_masterid_value" To sV_masterid_value
    Get ComStringOf Of hoJsonResponse "_createdonbehalfby_value" To sV_createdonbehalfby_value
    Get ComStringOf Of hoJsonResponse "address3_postofficebox" To sAddress3_postofficebox
    Get ComStringOf Of hoJsonResponse "subscriptionid" To sSubscriptionid
    Get ComStringOf Of hoJsonResponse "business2" To sBusiness2
    Get ComStringOf Of hoJsonResponse "address3_county" To sAddress3_county
    Get ComStringOf Of hoJsonResponse "address1_telephone2" To sAddress1_telephone2
    Get ComStringOf Of hoJsonResponse "address1_freighttermscode" To sAddress1_freighttermscode
    Get ComStringOf Of hoJsonResponse "address3_addresstypecode" To sAddress3_addresstypecode
    Get ComStringOf Of hoJsonResponse "address1_addresstypecode" To sAddress1_addresstypecode
    Get ComStringOf Of hoJsonResponse "aging90_base" To sAging90_base
    Get ComStringOf Of hoJsonResponse "address3_primarycontactname" To sAddress3_primarycontactname
    Get ComStringOf Of hoJsonResponse "familystatuscode" To sFamilystatuscode
    Get ComStringOf Of hoJsonResponse "home2" To sHome2
    Get ComStringOf Of hoJsonResponse "int_kloutscoreservice" To sInt_kloutscoreservice
    Get ComStringOf Of hoJsonResponse "address2_utcoffset" To sAddress2_utcoffset
    Get ComStringOf Of hoJsonResponse "aging60" To sAging60
    Get ComStringOf Of hoJsonResponse "telephone2" To sTelephone2
    Get ComStringOf Of hoJsonResponse "yomimiddlename" To sYomimiddlename
    Get ComStringOf Of hoJsonResponse "_modifiedonbehalfby_value" To sV_modifiedonbehalfby_value
    Get ComStringOf Of hoJsonResponse "jobtitle" To sJobtitle
    Get ComStringOf Of hoJsonResponse "address3_utcoffset" To sAddress3_utcoffset
    Get ComStringOf Of hoJsonResponse "address1_telephone3" To sAddress1_telephone3
    Get ComStringOf Of hoJsonResponse "address2_line2" To sAddress2_line2
    Get ComStringOf Of hoJsonResponse "creditlimit_base" To sCreditlimit_base
    Get ComStringOf Of hoJsonResponse "address3_line1" To sAddress3_line1
    Get ComStringOf Of hoJsonResponse "address1_county" To sAddress1_county
    Get ComStringOf Of hoJsonResponse "_createdbyexternalparty_value" To sV_createdbyexternalparty_value
    Get ComStringOf Of hoJsonResponse "entityimageid" To sEntityimageid
    Get ComStringOf Of hoJsonResponse "processid" To sProcessid
    Get ComStringOf Of hoJsonResponse "int_facebook" To sInt_facebook
    Get ComStringOf Of hoJsonResponse "description" To sDescription
    Get ComStringOf Of hoJsonResponse "address1_fax" To sAddress1_fax
    Get ComStringOf Of hoJsonResponse "address3_line2" To sAddress3_line2
    Get ComStringOf Of hoJsonResponse "externaluseridentifier" To sExternaluseridentifier
    Get ComStringOf Of hoJsonResponse "int_facebookservice" To sInt_facebookservice
    Get ComStringOf Of hoJsonResponse "aging30_base" To sAging30_base
    Get ComStringOf Of hoJsonResponse "callback" To sV_callback
    Get ComStringOf Of hoJsonResponse "emailaddress2" To sEmailaddress2
    Get ComStringOf Of hoJsonResponse "address2_line3" To sAddress2_line3
    Get ComStringOf Of hoJsonResponse "managerphone" To sManagerphone
    Get ComStringOf Of hoJsonResponse "websiteurl" To sWebsiteurl
    Get ComStringOf Of hoJsonResponse "exchangerate" To sExchangerate
    Get ComStringOf Of hoJsonResponse "address1_telephone1" To sAddress1_telephone1
    Get ComStringOf Of hoJsonResponse "address3_composite" To sAddress3_composite
    Get ComStringOf Of hoJsonResponse "address3_fax" To sAddress3_fax
    Get ComStringOf Of hoJsonResponse "childrensnames" To sChildrensnames
    Get ComStringOf Of hoJsonResponse "_owningteam_value" To sV_owningteam_value
    Get ComStringOf Of hoJsonResponse "numberofchildren" To sNumberofchildren
    Get ComStringOf Of hoJsonResponse "address2_postofficebox" To sAddress2_postofficebox
    Get ComStringOf Of hoJsonResponse "aging90" To sAging90
    Get ComStringOf Of hoJsonResponse "aging60_base" To sAging60_base
    Get ComStringOf Of hoJsonResponse "_transactioncurrencyid_value" To sV_transactioncurrencyid_value
    Get ComStringOf Of hoJsonResponse "entityimage" To sEntityimage
    Get ComStringOf Of hoJsonResponse "_modifiedbyexternalparty_value" To sV_modifiedbyexternalparty_value
    Get ComStringOf Of hoJsonResponse "paymenttermscode" To sPaymenttermscode
    Get ComStringOf Of hoJsonResponse "address3_name" To sAddress3_name
    Get ComStringOf Of hoJsonResponse "ftpsiteurl" To sFtpsiteurl
    Get ComStringOf Of hoJsonResponse "address1_shippingmethodcode" To sAddress1_shippingmethodcode
    Get ComStringOf Of hoJsonResponse "_preferredsystemuserid_value" To sV_preferredsystemuserid_value
    Get ComStringOf Of hoJsonResponse "address2_telephone2" To sAddress2_telephone2
    Get ComStringOf Of hoJsonResponse "_slainvokedid_value" To sV_slainvokedid_value
    Get ComStringOf Of hoJsonResponse "address3_telephone1" To sAddress3_telephone1
    Get ComStringOf Of hoJsonResponse "nickname" To sNickname
    Get ComStringOf Of hoJsonResponse "address1_postofficebox" To sAddress1_postofficebox
    Get ComStringOf Of hoJsonResponse "_preferredequipmentid_value" To sV_preferredequipmentid_value
    Get ComStringOf Of hoJsonResponse "assistantname" To sAssistantname
    Get ComStringOf Of hoJsonResponse "address2_country" To sAddress2_country
    Get ComStringOf Of hoJsonResponse "_accountid_value" To sV_accountid_value
    Get ComStringOf Of hoJsonResponse "address2_name" To sAddress2_name
    Get ComStringOf Of hoJsonResponse "stageid" To sStageid
    Get ComStringOf Of hoJsonResponse "address3_longitude" To sAddress3_longitude
    Get ComStringOf Of hoJsonResponse "onholdtime" To sOnholdtime
    Get ComStringOf Of hoJsonResponse "address2_telephone3" To sAddress2_telephone3
    Get ComStringOf Of hoJsonResponse "address3_upszone" To sAddress3_upszone
    Get ComStringOf Of hoJsonResponse "aging30" To sAging30
    Get ComStringOf Of hoJsonResponse "address2_upszone" To sAddress2_upszone
    Get ComStringOf Of hoJsonResponse "address1_upszone" To sAddress1_upszone
    Get ComStringOf Of hoJsonResponse "creditlimit" To sCreditlimit
    Get ComStringOf Of hoJsonResponse "salutation" To sSalutation
    Get ComStringOf Of hoJsonResponse "traversedpath" To sTraversedpath
    Get ComStringOf Of hoJsonResponse "accountrolecode" To sAccountrolecode
    Get ComStringOf Of hoJsonResponse "address1_utcoffset" To sAddress1_utcoffset
    Get ComStringOf Of hoJsonResponse "governmentid" To sGovernmentid
    Get ComStringOf Of hoJsonResponse "annualincome_base" To sAnnualincome_base
    Get ComStringOf Of hoJsonResponse "address3_stateorprovince" To sAddress3_stateorprovince
    Get ComStringOf Of hoJsonResponse "address3_postalcode" To sAddress3_postalcode
    Get ComStringOf Of hoJsonResponse "address2_city" To sAddress2_city
    Get ComStringOf Of hoJsonResponse "msdyn_gdproptout" To sMsdyn_gdproptout
    Get ComStringOf Of hoJsonResponse "company" To sCompany
    Get ComStringOf Of hoJsonResponse "address1_line2" To sAddress1_line2
    Get ComStringOf Of hoJsonResponse "address2_longitude" To sAddress2_longitude
    Get ComStringOf Of hoJsonResponse "int_twitter" To sInt_twitter
    Get ComStringOf Of hoJsonResponse "address3_telephone2" To sAddress3_telephone2
    Get ComStringOf Of hoJsonResponse "yomifirstname" To sYomifirstname
    Get ComStringOf Of hoJsonResponse "address2_composite" To sAddress2_composite
    Get ComStringOf Of hoJsonResponse "address2_county" To sAddress2_county
    Get ComStringOf Of hoJsonResponse "suffix" To sSuffix
    Get ComStringOf Of hoJsonResponse "anniversary" To sAnniversary
    Get ComStringOf Of hoJsonResponse "_parentcontactid_value" To sV_parentcontactid_value
    Get ComStringOf Of hoJsonResponse "address2_fax" To sAddress2_fax
    Get ComStringOf Of hoJsonResponse "yomilastname" To sYomilastname
    Get ComStringOf Of hoJsonResponse "preferredappointmentdaycode" To sPreferredappointmentdaycode
    Get ComStringOf Of hoJsonResponse "entityimage_url" To sEntityimage_url
    Get ComStringOf Of hoJsonResponse "address1_line3" To sAddress1_line3
    Get ComStringOf Of hoJsonResponse "_defaultpricelevelid_value" To sV_defaultpricelevelid_value
    Get ComStringOf Of hoJsonResponse "_slaid_value" To sV_slaid_value
    Get ComStringOf Of hoJsonResponse "middlename" To sMiddlename
    Get ComStringOf Of hoJsonResponse "address3_line3" To sAddress3_line3
    Get ComStringOf Of hoJsonResponse "timespentbymeonemailandmeetings" To sTimespentbymeonemailandmeetings


End_Procedure

Sample JSON Response Body

{
  "@odata.context": "https://mydomain.api.crm.dynamics.com/api/data/v9.0/$metadata#contacts/$entity",
  "@odata.etag": "W/\"1162210\"",
  "customertypecode": 1,
  "address1_latitude": 35.82096,
  "birthdate": "1965-05-24",
  "merged": false,
  "gendercode": 1,
  "territorycode": 1,
  "emailaddress1": "tom@cohowinery.com",
  "haschildrencode": 1,
  "preferredappointmenttimecode": 1,
  "isbackofficecustomer": false,
  "modifiedon": "2018-03-12T16:09:53Z",
  "_owninguser_value": "55e68414-a277-42d6-ba36-d90484708a1d",
  "importsequencenumber": 104,
  "address1_composite": "4405 Balboa Court\r\nSanta Cruz, NM 72052\r\nUS",
  "address1_longitude": -106.21346,
  "marketingonly": false,
  "donotphone": false,
  "preferredcontactmethodcode": 1,
  "educationcode": 1,
  "_ownerid_value": "55e68414-a277-42d6-ba36-d90484708a1d",
  "customersizecode": 1,
  "firstname": "Tomasz",
  "donotpostalmail": false,
  "yomifullname": "Tomasz Bochenek",
  "address2_addresstypecode": 1,
  "donotemail": false,
  "address2_shippingmethodcode": 1,
  "fullname": "Tomasz Bochenek",
  "timezoneruleversionnumber": 0,
  "address1_addressid": "c3a917d8-1daa-463b-a4ac-f6d9878d7456",
  "address2_freighttermscode": 1,
  "statuscode": 1,
  "createdon": "2017-01-20T22:40:01Z",
  "address1_stateorprovince": "NM",
  "lastname": "Bochenek",
  "donotsendmm": false,
  "donotfax": false,
  "leadsourcecode": 1,
  "address1_country": "US",
  "versionnumber": 1162210,
  "address1_line1": "4405 Balboa Court",
  "creditonhold": false,
  "telephone1": "456-698-4581",
  "_owningbusinessunit_value": "c4106190-c81e-e811-a980-000d3a192e9a",
  "address3_addressid": "e3e5cc17-4990-4d08-8a4d-c16ca45217ab",
  "donotbulkemail": false,
  "_modifiedby_value": "e00ba668-e2de-47bc-8f92-ab9573f92ff4",
  "followemail": true,
  "shippingmethodcode": 1,
  "_createdby_value": "55e68414-a277-42d6-ba36-d90484708a1d",
  "address1_city": "Santa Cruz",
  "donotbulkpostalmail": false,
  "_parentcustomerid_value": "b0a19cdd-88df-e311-b8e5-6c3be5a8b200",
  "contactid": "1fa1e5b9-88df-e311-b8e5-6c3be5a8b200",
  "participatesinworkflow": false,
  "statecode": 0,
  "overriddencreatedon": "2018-03-03T12:22:25Z",
  "address2_addressid": "fee626cd-e834-4a68-a54e-b98c23847b2d",
  "address1_postalcode": "72052",
  "int_kloutscore": 90,
  "spousesname": null,
  "emailaddress3": null,
  "address3_telephone3": null,
  "mobilephone": null,
  "utcconversiontimezonecode": null,
  "_preferredserviceid_value": null,
  "address3_shippingmethodcode": null,
  "int_twitterservice": null,
  "annualincome": null,
  "fax": null,
  "telephone3": null,
  "address1_primarycontactname": null,
  "address3_city": null,
  "lastonholdtime": null,
  "address2_stateorprovince": null,
  "address2_line1": null,
  "assistantphone": null,
  "lastusedincampaign": null,
  "address3_freighttermscode": null,
  "pager": null,
  "employeeid": null,
  "managername": null,
  "address1_name": null,
  "department": null,
  "address3_country": null,
  "address2_telephone1": null,
  "address2_primarycontactname": null,
  "address2_latitude": null,
  "address3_latitude": null,
  "address2_postalcode": null,
  "entityimage_timestamp": null,
  "_originatingleadid_value": null,
  "_masterid_value": null,
  "_createdonbehalfby_value": null,
  "address3_postofficebox": null,
  "subscriptionid": null,
  "business2": null,
  "address3_county": null,
  "address1_telephone2": null,
  "address1_freighttermscode": null,
  "address3_addresstypecode": null,
  "address1_addresstypecode": null,
  "aging90_base": null,
  "address3_primarycontactname": null,
  "familystatuscode": null,
  "home2": null,
  "int_kloutscoreservice": null,
  "address2_utcoffset": null,
  "aging60": null,
  "telephone2": null,
  "yomimiddlename": null,
  "_modifiedonbehalfby_value": null,
  "jobtitle": null,
  "address3_utcoffset": null,
  "address1_telephone3": null,
  "address2_line2": null,
  "creditlimit_base": null,
  "address3_line1": null,
  "address1_county": null,
  "_createdbyexternalparty_value": null,
  "entityimageid": null,
  "processid": null,
  "int_facebook": null,
  "description": null,
  "address1_fax": null,
  "address3_line2": null,
  "externaluseridentifier": null,
  "int_facebookservice": null,
  "aging30_base": null,
  "callback": null,
  "emailaddress2": null,
  "address2_line3": null,
  "managerphone": null,
  "websiteurl": null,
  "exchangerate": null,
  "address1_telephone1": null,
  "address3_composite": null,
  "address3_fax": null,
  "childrensnames": null,
  "_owningteam_value": null,
  "numberofchildren": null,
  "address2_postofficebox": null,
  "aging90": null,
  "aging60_base": null,
  "_transactioncurrencyid_value": null,
  "entityimage": null,
  "_modifiedbyexternalparty_value": null,
  "paymenttermscode": null,
  "address3_name": null,
  "ftpsiteurl": null,
  "address1_shippingmethodcode": null,
  "_preferredsystemuserid_value": null,
  "address2_telephone2": null,
  "_slainvokedid_value": null,
  "address3_telephone1": null,
  "nickname": null,
  "address1_postofficebox": null,
  "_preferredequipmentid_value": null,
  "assistantname": null,
  "address2_country": null,
  "_accountid_value": null,
  "address2_name": null,
  "stageid": null,
  "address3_longitude": null,
  "onholdtime": null,
  "address2_telephone3": null,
  "address3_upszone": null,
  "aging30": null,
  "address2_upszone": null,
  "address1_upszone": null,
  "creditlimit": null,
  "salutation": null,
  "traversedpath": null,
  "accountrolecode": null,
  "address1_utcoffset": null,
  "governmentid": null,
  "annualincome_base": null,
  "address3_stateorprovince": null,
  "address3_postalcode": null,
  "address2_city": null,
  "msdyn_gdproptout": null,
  "company": null,
  "address1_line2": null,
  "address2_longitude": null,
  "int_twitter": null,
  "address3_telephone2": null,
  "yomifirstname": null,
  "address2_composite": null,
  "address2_county": null,
  "suffix": null,
  "anniversary": null,
  "_parentcontactid_value": null,
  "address2_fax": null,
  "yomilastname": null,
  "preferredappointmentdaycode": null,
  "entityimage_url": null,
  "address1_line3": null,
  "_defaultpricelevelid_value": null,
  "_slaid_value": null,
  "middlename": null,
  "address3_line3": null,
  "timespentbymeonemailandmeetings": null
}