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

Visual FoxPro Example

LOCAL loRest
LOCAL lnSuccess
LOCAL lnBTls
LOCAL lnPort
LOCAL lnBAutoReconnect
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL loJsonResponse
LOCAL lcOdataContext
LOCAL lcOdataEtag
LOCAL lnCustomertypecode
LOCAL lnAddress1_latitude
LOCAL lcBirthdate
LOCAL lnMerged
LOCAL lnGendercode
LOCAL lnTerritorycode
LOCAL lcEmailaddress1
LOCAL lnHaschildrencode
LOCAL lnPreferredappointmenttimecode
LOCAL lnIsbackofficecustomer
LOCAL lcModifiedon
LOCAL lcV_owninguser_value
LOCAL lnImportsequencenumber
LOCAL lcAddress1_composite
LOCAL lnAddress1_longitude
LOCAL lnMarketingonly
LOCAL lnDonotphone
LOCAL lnPreferredcontactmethodcode
LOCAL lnEducationcode
LOCAL lcV_ownerid_value
LOCAL lnCustomersizecode
LOCAL lcFirstname
LOCAL lnDonotpostalmail
LOCAL lcYomifullname
LOCAL lnAddress2_addresstypecode
LOCAL lnDonotemail
LOCAL lnAddress2_shippingmethodcode
LOCAL lcFullname
LOCAL lnTimezoneruleversionnumber
LOCAL lcAddress1_addressid
LOCAL lnAddress2_freighttermscode
LOCAL lnStatuscode
LOCAL lcCreatedon
LOCAL lcAddress1_stateorprovince
LOCAL lcLastname
LOCAL lnDonotsendmm
LOCAL lnDonotfax
LOCAL lnLeadsourcecode
LOCAL lcAddress1_country
LOCAL lnVersionnumber
LOCAL lcAddress1_line1
LOCAL lnCreditonhold
LOCAL lcTelephone1
LOCAL lcV_owningbusinessunit_value
LOCAL lcAddress3_addressid
LOCAL lnDonotbulkemail
LOCAL lcV_modifiedby_value
LOCAL lnFollowemail
LOCAL lnShippingmethodcode
LOCAL lcV_createdby_value
LOCAL lcAddress1_city
LOCAL lnDonotbulkpostalmail
LOCAL lcV_parentcustomerid_value
LOCAL lcContactid
LOCAL lnParticipatesinworkflow
LOCAL lnStatecode
LOCAL lcOverriddencreatedon
LOCAL lcAddress2_addressid
LOCAL lcAddress1_postalcode
LOCAL lnInt_kloutscore
LOCAL lcSpousesname
LOCAL lcEmailaddress3
LOCAL lcAddress3_telephone3
LOCAL lcMobilephone
LOCAL lcUtcconversiontimezonecode
LOCAL lcV_preferredserviceid_value
LOCAL lcAddress3_shippingmethodcode
LOCAL lcInt_twitterservice
LOCAL lcAnnualincome
LOCAL lcFax
LOCAL lcTelephone3
LOCAL lcAddress1_primarycontactname
LOCAL lcAddress3_city
LOCAL lcLastonholdtime
LOCAL lcAddress2_stateorprovince
LOCAL lcAddress2_line1
LOCAL lcAssistantphone
LOCAL lcLastusedincampaign
LOCAL lcAddress3_freighttermscode
LOCAL lcPager
LOCAL lcEmployeeid
LOCAL lcManagername
LOCAL lcAddress1_name
LOCAL lcDepartment
LOCAL lcAddress3_country
LOCAL lcAddress2_telephone1
LOCAL lcAddress2_primarycontactname
LOCAL lcAddress2_latitude
LOCAL lcAddress3_latitude
LOCAL lcAddress2_postalcode
LOCAL lcEntityimage_timestamp
LOCAL lcV_originatingleadid_value
LOCAL lcV_masterid_value
LOCAL lcV_createdonbehalfby_value
LOCAL lcAddress3_postofficebox
LOCAL lcSubscriptionid
LOCAL lcBusiness2
LOCAL lcAddress3_county
LOCAL lcAddress1_telephone2
LOCAL lcAddress1_freighttermscode
LOCAL lcAddress3_addresstypecode
LOCAL lcAddress1_addresstypecode
LOCAL lcAging90_base
LOCAL lcAddress3_primarycontactname
LOCAL lcFamilystatuscode
LOCAL lcHome2
LOCAL lcInt_kloutscoreservice
LOCAL lcAddress2_utcoffset
LOCAL lcAging60
LOCAL lcTelephone2
LOCAL lcYomimiddlename
LOCAL lcV_modifiedonbehalfby_value
LOCAL lcJobtitle
LOCAL lcAddress3_utcoffset
LOCAL lcAddress1_telephone3
LOCAL lcAddress2_line2
LOCAL lcCreditlimit_base
LOCAL lcAddress3_line1
LOCAL lcAddress1_county
LOCAL lcV_createdbyexternalparty_value
LOCAL lcEntityimageid
LOCAL lcProcessid
LOCAL lcInt_facebook
LOCAL lcDescription
LOCAL lcAddress1_fax
LOCAL lcAddress3_line2
LOCAL lcExternaluseridentifier
LOCAL lcInt_facebookservice
LOCAL lcAging30_base
LOCAL lcV_callback
LOCAL lcEmailaddress2
LOCAL lcAddress2_line3
LOCAL lcManagerphone
LOCAL lcWebsiteurl
LOCAL lcExchangerate
LOCAL lcAddress1_telephone1
LOCAL lcAddress3_composite
LOCAL lcAddress3_fax
LOCAL lcChildrensnames
LOCAL lcV_owningteam_value
LOCAL lcNumberofchildren
LOCAL lcAddress2_postofficebox
LOCAL lcAging90
LOCAL lcAging60_base
LOCAL lcV_transactioncurrencyid_value
LOCAL lcEntityimage
LOCAL lcV_modifiedbyexternalparty_value
LOCAL lcPaymenttermscode
LOCAL lcAddress3_name
LOCAL lcFtpsiteurl
LOCAL lcAddress1_shippingmethodcode
LOCAL lcV_preferredsystemuserid_value
LOCAL lcAddress2_telephone2
LOCAL lcV_slainvokedid_value
LOCAL lcAddress3_telephone1
LOCAL lcNickname
LOCAL lcAddress1_postofficebox
LOCAL lcV_preferredequipmentid_value
LOCAL lcAssistantname
LOCAL lcAddress2_country
LOCAL lcV_accountid_value
LOCAL lcAddress2_name
LOCAL lcStageid
LOCAL lcAddress3_longitude
LOCAL lcOnholdtime
LOCAL lcAddress2_telephone3
LOCAL lcAddress3_upszone
LOCAL lcAging30
LOCAL lcAddress2_upszone
LOCAL lcAddress1_upszone
LOCAL lcCreditlimit
LOCAL lcSalutation
LOCAL lcTraversedpath
LOCAL lcAccountrolecode
LOCAL lcAddress1_utcoffset
LOCAL lcGovernmentid
LOCAL lcAnnualincome_base
LOCAL lcAddress3_stateorprovince
LOCAL lcAddress3_postalcode
LOCAL lcAddress2_city
LOCAL lcMsdyn_gdproptout
LOCAL lcCompany
LOCAL lcAddress1_line2
LOCAL lcAddress2_longitude
LOCAL lcInt_twitter
LOCAL lcAddress3_telephone2
LOCAL lcYomifirstname
LOCAL lcAddress2_composite
LOCAL lcAddress2_county
LOCAL lcSuffix
LOCAL lcAnniversary
LOCAL lcV_parentcontactid_value
LOCAL lcAddress2_fax
LOCAL lcYomilastname
LOCAL lcPreferredappointmentdaycode
LOCAL lcEntityimage_url
LOCAL lcAddress1_line3
LOCAL lcV_defaultpricelevelid_value
LOCAL lcV_slaid_value
LOCAL lcMiddlename
LOCAL lcAddress3_line3
LOCAL lcTimespentbymeonemailandmeetings

loRest = CreateObject('Chilkat_9_5_0.Rest')

*  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/contacts(1fa1e5b9-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/contacts(1fa1e5b9-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"')
lnCustomertypecode = loJsonResponse.IntOf("customertypecode")
lnAddress1_latitude = loJsonResponse.IntOf("address1_latitude")
lcBirthdate = loJsonResponse.StringOf("birthdate")
lnMerged = loJsonResponse.BoolOf("merged")
lnGendercode = loJsonResponse.IntOf("gendercode")
lnTerritorycode = loJsonResponse.IntOf("territorycode")
lcEmailaddress1 = loJsonResponse.StringOf("emailaddress1")
lnHaschildrencode = loJsonResponse.IntOf("haschildrencode")
lnPreferredappointmenttimecode = loJsonResponse.IntOf("preferredappointmenttimecode")
lnIsbackofficecustomer = loJsonResponse.BoolOf("isbackofficecustomer")
lcModifiedon = loJsonResponse.StringOf("modifiedon")
lcV_owninguser_value = loJsonResponse.StringOf("_owninguser_value")
lnImportsequencenumber = loJsonResponse.IntOf("importsequencenumber")
lcAddress1_composite = loJsonResponse.StringOf("address1_composite")
lnAddress1_longitude = loJsonResponse.IntOf("address1_longitude")
lnMarketingonly = loJsonResponse.BoolOf("marketingonly")
lnDonotphone = loJsonResponse.BoolOf("donotphone")
lnPreferredcontactmethodcode = loJsonResponse.IntOf("preferredcontactmethodcode")
lnEducationcode = loJsonResponse.IntOf("educationcode")
lcV_ownerid_value = loJsonResponse.StringOf("_ownerid_value")
lnCustomersizecode = loJsonResponse.IntOf("customersizecode")
lcFirstname = loJsonResponse.StringOf("firstname")
lnDonotpostalmail = loJsonResponse.BoolOf("donotpostalmail")
lcYomifullname = loJsonResponse.StringOf("yomifullname")
lnAddress2_addresstypecode = loJsonResponse.IntOf("address2_addresstypecode")
lnDonotemail = loJsonResponse.BoolOf("donotemail")
lnAddress2_shippingmethodcode = loJsonResponse.IntOf("address2_shippingmethodcode")
lcFullname = loJsonResponse.StringOf("fullname")
lnTimezoneruleversionnumber = loJsonResponse.IntOf("timezoneruleversionnumber")
lcAddress1_addressid = loJsonResponse.StringOf("address1_addressid")
lnAddress2_freighttermscode = loJsonResponse.IntOf("address2_freighttermscode")
lnStatuscode = loJsonResponse.IntOf("statuscode")
lcCreatedon = loJsonResponse.StringOf("createdon")
lcAddress1_stateorprovince = loJsonResponse.StringOf("address1_stateorprovince")
lcLastname = loJsonResponse.StringOf("lastname")
lnDonotsendmm = loJsonResponse.BoolOf("donotsendmm")
lnDonotfax = loJsonResponse.BoolOf("donotfax")
lnLeadsourcecode = loJsonResponse.IntOf("leadsourcecode")
lcAddress1_country = loJsonResponse.StringOf("address1_country")
lnVersionnumber = loJsonResponse.IntOf("versionnumber")
lcAddress1_line1 = loJsonResponse.StringOf("address1_line1")
lnCreditonhold = loJsonResponse.BoolOf("creditonhold")
lcTelephone1 = loJsonResponse.StringOf("telephone1")
lcV_owningbusinessunit_value = loJsonResponse.StringOf("_owningbusinessunit_value")
lcAddress3_addressid = loJsonResponse.StringOf("address3_addressid")
lnDonotbulkemail = loJsonResponse.BoolOf("donotbulkemail")
lcV_modifiedby_value = loJsonResponse.StringOf("_modifiedby_value")
lnFollowemail = loJsonResponse.BoolOf("followemail")
lnShippingmethodcode = loJsonResponse.IntOf("shippingmethodcode")
lcV_createdby_value = loJsonResponse.StringOf("_createdby_value")
lcAddress1_city = loJsonResponse.StringOf("address1_city")
lnDonotbulkpostalmail = loJsonResponse.BoolOf("donotbulkpostalmail")
lcV_parentcustomerid_value = loJsonResponse.StringOf("_parentcustomerid_value")
lcContactid = loJsonResponse.StringOf("contactid")
lnParticipatesinworkflow = loJsonResponse.BoolOf("participatesinworkflow")
lnStatecode = loJsonResponse.IntOf("statecode")
lcOverriddencreatedon = loJsonResponse.StringOf("overriddencreatedon")
lcAddress2_addressid = loJsonResponse.StringOf("address2_addressid")
lcAddress1_postalcode = loJsonResponse.StringOf("address1_postalcode")
lnInt_kloutscore = loJsonResponse.IntOf("int_kloutscore")
lcSpousesname = loJsonResponse.StringOf("spousesname")
lcEmailaddress3 = loJsonResponse.StringOf("emailaddress3")
lcAddress3_telephone3 = loJsonResponse.StringOf("address3_telephone3")
lcMobilephone = loJsonResponse.StringOf("mobilephone")
lcUtcconversiontimezonecode = loJsonResponse.StringOf("utcconversiontimezonecode")
lcV_preferredserviceid_value = loJsonResponse.StringOf("_preferredserviceid_value")
lcAddress3_shippingmethodcode = loJsonResponse.StringOf("address3_shippingmethodcode")
lcInt_twitterservice = loJsonResponse.StringOf("int_twitterservice")
lcAnnualincome = loJsonResponse.StringOf("annualincome")
lcFax = loJsonResponse.StringOf("fax")
lcTelephone3 = loJsonResponse.StringOf("telephone3")
lcAddress1_primarycontactname = loJsonResponse.StringOf("address1_primarycontactname")
lcAddress3_city = loJsonResponse.StringOf("address3_city")
lcLastonholdtime = loJsonResponse.StringOf("lastonholdtime")
lcAddress2_stateorprovince = loJsonResponse.StringOf("address2_stateorprovince")
lcAddress2_line1 = loJsonResponse.StringOf("address2_line1")
lcAssistantphone = loJsonResponse.StringOf("assistantphone")
lcLastusedincampaign = loJsonResponse.StringOf("lastusedincampaign")
lcAddress3_freighttermscode = loJsonResponse.StringOf("address3_freighttermscode")
lcPager = loJsonResponse.StringOf("pager")
lcEmployeeid = loJsonResponse.StringOf("employeeid")
lcManagername = loJsonResponse.StringOf("managername")
lcAddress1_name = loJsonResponse.StringOf("address1_name")
lcDepartment = loJsonResponse.StringOf("department")
lcAddress3_country = loJsonResponse.StringOf("address3_country")
lcAddress2_telephone1 = loJsonResponse.StringOf("address2_telephone1")
lcAddress2_primarycontactname = loJsonResponse.StringOf("address2_primarycontactname")
lcAddress2_latitude = loJsonResponse.StringOf("address2_latitude")
lcAddress3_latitude = loJsonResponse.StringOf("address3_latitude")
lcAddress2_postalcode = loJsonResponse.StringOf("address2_postalcode")
lcEntityimage_timestamp = loJsonResponse.StringOf("entityimage_timestamp")
lcV_originatingleadid_value = loJsonResponse.StringOf("_originatingleadid_value")
lcV_masterid_value = loJsonResponse.StringOf("_masterid_value")
lcV_createdonbehalfby_value = loJsonResponse.StringOf("_createdonbehalfby_value")
lcAddress3_postofficebox = loJsonResponse.StringOf("address3_postofficebox")
lcSubscriptionid = loJsonResponse.StringOf("subscriptionid")
lcBusiness2 = loJsonResponse.StringOf("business2")
lcAddress3_county = loJsonResponse.StringOf("address3_county")
lcAddress1_telephone2 = loJsonResponse.StringOf("address1_telephone2")
lcAddress1_freighttermscode = loJsonResponse.StringOf("address1_freighttermscode")
lcAddress3_addresstypecode = loJsonResponse.StringOf("address3_addresstypecode")
lcAddress1_addresstypecode = loJsonResponse.StringOf("address1_addresstypecode")
lcAging90_base = loJsonResponse.StringOf("aging90_base")
lcAddress3_primarycontactname = loJsonResponse.StringOf("address3_primarycontactname")
lcFamilystatuscode = loJsonResponse.StringOf("familystatuscode")
lcHome2 = loJsonResponse.StringOf("home2")
lcInt_kloutscoreservice = loJsonResponse.StringOf("int_kloutscoreservice")
lcAddress2_utcoffset = loJsonResponse.StringOf("address2_utcoffset")
lcAging60 = loJsonResponse.StringOf("aging60")
lcTelephone2 = loJsonResponse.StringOf("telephone2")
lcYomimiddlename = loJsonResponse.StringOf("yomimiddlename")
lcV_modifiedonbehalfby_value = loJsonResponse.StringOf("_modifiedonbehalfby_value")
lcJobtitle = loJsonResponse.StringOf("jobtitle")
lcAddress3_utcoffset = loJsonResponse.StringOf("address3_utcoffset")
lcAddress1_telephone3 = loJsonResponse.StringOf("address1_telephone3")
lcAddress2_line2 = loJsonResponse.StringOf("address2_line2")
lcCreditlimit_base = loJsonResponse.StringOf("creditlimit_base")
lcAddress3_line1 = loJsonResponse.StringOf("address3_line1")
lcAddress1_county = loJsonResponse.StringOf("address1_county")
lcV_createdbyexternalparty_value = loJsonResponse.StringOf("_createdbyexternalparty_value")
lcEntityimageid = loJsonResponse.StringOf("entityimageid")
lcProcessid = loJsonResponse.StringOf("processid")
lcInt_facebook = loJsonResponse.StringOf("int_facebook")
lcDescription = loJsonResponse.StringOf("description")
lcAddress1_fax = loJsonResponse.StringOf("address1_fax")
lcAddress3_line2 = loJsonResponse.StringOf("address3_line2")
lcExternaluseridentifier = loJsonResponse.StringOf("externaluseridentifier")
lcInt_facebookservice = loJsonResponse.StringOf("int_facebookservice")
lcAging30_base = loJsonResponse.StringOf("aging30_base")
lcV_callback = loJsonResponse.StringOf("callback")
lcEmailaddress2 = loJsonResponse.StringOf("emailaddress2")
lcAddress2_line3 = loJsonResponse.StringOf("address2_line3")
lcManagerphone = loJsonResponse.StringOf("managerphone")
lcWebsiteurl = loJsonResponse.StringOf("websiteurl")
lcExchangerate = loJsonResponse.StringOf("exchangerate")
lcAddress1_telephone1 = loJsonResponse.StringOf("address1_telephone1")
lcAddress3_composite = loJsonResponse.StringOf("address3_composite")
lcAddress3_fax = loJsonResponse.StringOf("address3_fax")
lcChildrensnames = loJsonResponse.StringOf("childrensnames")
lcV_owningteam_value = loJsonResponse.StringOf("_owningteam_value")
lcNumberofchildren = loJsonResponse.StringOf("numberofchildren")
lcAddress2_postofficebox = loJsonResponse.StringOf("address2_postofficebox")
lcAging90 = loJsonResponse.StringOf("aging90")
lcAging60_base = loJsonResponse.StringOf("aging60_base")
lcV_transactioncurrencyid_value = loJsonResponse.StringOf("_transactioncurrencyid_value")
lcEntityimage = loJsonResponse.StringOf("entityimage")
lcV_modifiedbyexternalparty_value = loJsonResponse.StringOf("_modifiedbyexternalparty_value")
lcPaymenttermscode = loJsonResponse.StringOf("paymenttermscode")
lcAddress3_name = loJsonResponse.StringOf("address3_name")
lcFtpsiteurl = loJsonResponse.StringOf("ftpsiteurl")
lcAddress1_shippingmethodcode = loJsonResponse.StringOf("address1_shippingmethodcode")
lcV_preferredsystemuserid_value = loJsonResponse.StringOf("_preferredsystemuserid_value")
lcAddress2_telephone2 = loJsonResponse.StringOf("address2_telephone2")
lcV_slainvokedid_value = loJsonResponse.StringOf("_slainvokedid_value")
lcAddress3_telephone1 = loJsonResponse.StringOf("address3_telephone1")
lcNickname = loJsonResponse.StringOf("nickname")
lcAddress1_postofficebox = loJsonResponse.StringOf("address1_postofficebox")
lcV_preferredequipmentid_value = loJsonResponse.StringOf("_preferredequipmentid_value")
lcAssistantname = loJsonResponse.StringOf("assistantname")
lcAddress2_country = loJsonResponse.StringOf("address2_country")
lcV_accountid_value = loJsonResponse.StringOf("_accountid_value")
lcAddress2_name = loJsonResponse.StringOf("address2_name")
lcStageid = loJsonResponse.StringOf("stageid")
lcAddress3_longitude = loJsonResponse.StringOf("address3_longitude")
lcOnholdtime = loJsonResponse.StringOf("onholdtime")
lcAddress2_telephone3 = loJsonResponse.StringOf("address2_telephone3")
lcAddress3_upszone = loJsonResponse.StringOf("address3_upszone")
lcAging30 = loJsonResponse.StringOf("aging30")
lcAddress2_upszone = loJsonResponse.StringOf("address2_upszone")
lcAddress1_upszone = loJsonResponse.StringOf("address1_upszone")
lcCreditlimit = loJsonResponse.StringOf("creditlimit")
lcSalutation = loJsonResponse.StringOf("salutation")
lcTraversedpath = loJsonResponse.StringOf("traversedpath")
lcAccountrolecode = loJsonResponse.StringOf("accountrolecode")
lcAddress1_utcoffset = loJsonResponse.StringOf("address1_utcoffset")
lcGovernmentid = loJsonResponse.StringOf("governmentid")
lcAnnualincome_base = loJsonResponse.StringOf("annualincome_base")
lcAddress3_stateorprovince = loJsonResponse.StringOf("address3_stateorprovince")
lcAddress3_postalcode = loJsonResponse.StringOf("address3_postalcode")
lcAddress2_city = loJsonResponse.StringOf("address2_city")
lcMsdyn_gdproptout = loJsonResponse.StringOf("msdyn_gdproptout")
lcCompany = loJsonResponse.StringOf("company")
lcAddress1_line2 = loJsonResponse.StringOf("address1_line2")
lcAddress2_longitude = loJsonResponse.StringOf("address2_longitude")
lcInt_twitter = loJsonResponse.StringOf("int_twitter")
lcAddress3_telephone2 = loJsonResponse.StringOf("address3_telephone2")
lcYomifirstname = loJsonResponse.StringOf("yomifirstname")
lcAddress2_composite = loJsonResponse.StringOf("address2_composite")
lcAddress2_county = loJsonResponse.StringOf("address2_county")
lcSuffix = loJsonResponse.StringOf("suffix")
lcAnniversary = loJsonResponse.StringOf("anniversary")
lcV_parentcontactid_value = loJsonResponse.StringOf("_parentcontactid_value")
lcAddress2_fax = loJsonResponse.StringOf("address2_fax")
lcYomilastname = loJsonResponse.StringOf("yomilastname")
lcPreferredappointmentdaycode = loJsonResponse.StringOf("preferredappointmentdaycode")
lcEntityimage_url = loJsonResponse.StringOf("entityimage_url")
lcAddress1_line3 = loJsonResponse.StringOf("address1_line3")
lcV_defaultpricelevelid_value = loJsonResponse.StringOf("_defaultpricelevelid_value")
lcV_slaid_value = loJsonResponse.StringOf("_slaid_value")
lcMiddlename = loJsonResponse.StringOf("middlename")
lcAddress3_line3 = loJsonResponse.StringOf("address3_line3")
lcTimespentbymeonemailandmeetings = loJsonResponse.StringOf("timespentbymeonemailandmeetings")

RELEASE loRest
RELEASE loSbResponseBody
RELEASE loJsonResponse

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
}