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

PowerBuilder Example

integer li_rc
oleobject loo_Rest
integer li_Success
integer li_BTls
integer li_Port
integer li_BAutoReconnect
oleobject loo_SbResponseBody
integer li_RespStatusCode
oleobject loo_JsonResponse
string ls_OdataContext
string ls_OdataEtag
integer li_Customertypecode
integer li_Address1_latitude
string ls_Birthdate
integer li_Merged
integer li_Gendercode
integer li_Territorycode
string ls_Emailaddress1
integer li_Haschildrencode
integer li_Preferredappointmenttimecode
integer li_Isbackofficecustomer
string ls_Modifiedon
string ls_V_owninguser_value
integer li_Importsequencenumber
string ls_Address1_composite
integer li_Address1_longitude
integer li_Marketingonly
integer li_Donotphone
integer li_Preferredcontactmethodcode
integer li_Educationcode
string ls_V_ownerid_value
integer li_Customersizecode
string ls_Firstname
integer li_Donotpostalmail
string ls_Yomifullname
integer li_Address2_addresstypecode
integer li_Donotemail
integer li_Address2_shippingmethodcode
string ls_Fullname
integer li_Timezoneruleversionnumber
string ls_Address1_addressid
integer li_Address2_freighttermscode
integer li_Statuscode
string ls_Createdon
string ls_Address1_stateorprovince
string ls_Lastname
integer li_Donotsendmm
integer li_Donotfax
integer li_Leadsourcecode
string ls_Address1_country
integer li_Versionnumber
string ls_Address1_line1
integer li_Creditonhold
string ls_Telephone1
string ls_V_owningbusinessunit_value
string ls_Address3_addressid
integer li_Donotbulkemail
string ls_V_modifiedby_value
integer li_Followemail
integer li_Shippingmethodcode
string ls_V_createdby_value
string ls_Address1_city
integer li_Donotbulkpostalmail
string ls_V_parentcustomerid_value
string ls_Contactid
integer li_Participatesinworkflow
integer li_Statecode
string ls_Overriddencreatedon
string ls_Address2_addressid
string ls_Address1_postalcode
integer li_Int_kloutscore
string ls_Spousesname
string ls_Emailaddress3
string ls_Address3_telephone3
string ls_Mobilephone
string ls_Utcconversiontimezonecode
string ls_V_preferredserviceid_value
string ls_Address3_shippingmethodcode
string ls_Int_twitterservice
string ls_Annualincome
string ls_Fax
string ls_Telephone3
string ls_Address1_primarycontactname
string ls_Address3_city
string ls_Lastonholdtime
string ls_Address2_stateorprovince
string ls_Address2_line1
string ls_Assistantphone
string ls_Lastusedincampaign
string ls_Address3_freighttermscode
string ls_Pager
string ls_Employeeid
string ls_Managername
string ls_Address1_name
string ls_Department
string ls_Address3_country
string ls_Address2_telephone1
string ls_Address2_primarycontactname
string ls_Address2_latitude
string ls_Address3_latitude
string ls_Address2_postalcode
string ls_Entityimage_timestamp
string ls_V_originatingleadid_value
string ls_V_masterid_value
string ls_V_createdonbehalfby_value
string ls_Address3_postofficebox
string ls_Subscriptionid
string ls_Business2
string ls_Address3_county
string ls_Address1_telephone2
string ls_Address1_freighttermscode
string ls_Address3_addresstypecode
string ls_Address1_addresstypecode
string ls_Aging90_base
string ls_Address3_primarycontactname
string ls_Familystatuscode
string ls_Home2
string ls_Int_kloutscoreservice
string ls_Address2_utcoffset
string ls_Aging60
string ls_Telephone2
string ls_Yomimiddlename
string ls_V_modifiedonbehalfby_value
string ls_Jobtitle
string ls_Address3_utcoffset
string ls_Address1_telephone3
string ls_Address2_line2
string ls_Creditlimit_base
string ls_Address3_line1
string ls_Address1_county
string ls_V_createdbyexternalparty_value
string ls_Entityimageid
string ls_Processid
string ls_Int_facebook
string ls_Description
string ls_Address1_fax
string ls_Address3_line2
string ls_Externaluseridentifier
string ls_Int_facebookservice
string ls_Aging30_base
string ls_V_callback
string ls_Emailaddress2
string ls_Address2_line3
string ls_Managerphone
string ls_Websiteurl
string ls_Exchangerate
string ls_Address1_telephone1
string ls_Address3_composite
string ls_Address3_fax
string ls_Childrensnames
string ls_V_owningteam_value
string ls_Numberofchildren
string ls_Address2_postofficebox
string ls_Aging90
string ls_Aging60_base
string ls_V_transactioncurrencyid_value
string ls_Entityimage
string ls_V_modifiedbyexternalparty_value
string ls_Paymenttermscode
string ls_Address3_name
string ls_Ftpsiteurl
string ls_Address1_shippingmethodcode
string ls_V_preferredsystemuserid_value
string ls_Address2_telephone2
string ls_V_slainvokedid_value
string ls_Address3_telephone1
string ls_Nickname
string ls_Address1_postofficebox
string ls_V_preferredequipmentid_value
string ls_Assistantname
string ls_Address2_country
string ls_V_accountid_value
string ls_Address2_name
string ls_Stageid
string ls_Address3_longitude
string ls_Onholdtime
string ls_Address2_telephone3
string ls_Address3_upszone
string ls_Aging30
string ls_Address2_upszone
string ls_Address1_upszone
string ls_Creditlimit
string ls_Salutation
string ls_Traversedpath
string ls_Accountrolecode
string ls_Address1_utcoffset
string ls_Governmentid
string ls_Annualincome_base
string ls_Address3_stateorprovince
string ls_Address3_postalcode
string ls_Address2_city
string ls_Msdyn_gdproptout
string ls_Company
string ls_Address1_line2
string ls_Address2_longitude
string ls_Int_twitter
string ls_Address3_telephone2
string ls_Yomifirstname
string ls_Address2_composite
string ls_Address2_county
string ls_Suffix
string ls_Anniversary
string ls_V_parentcontactid_value
string ls_Address2_fax
string ls_Yomilastname
string ls_Preferredappointmentdaycode
string ls_Entityimage_url
string ls_Address1_line3
string ls_V_defaultpricelevelid_value
string ls_V_slaid_value
string ls_Middlename
string ls_Address3_line3
string ls_Timespentbymeonemailandmeetings

loo_Rest = create oleobject
li_rc = loo_Rest.ConnectToNewObject("Chilkat_9_5_0.Rest")
if li_rc < 0 then
    destroy loo_Rest
    MessageBox("Error","Connecting to COM object failed")
    return
end if

//  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/contacts(1fa1e5b9-88df-e311-b8e5-6c3be5a8b200)
li_BTls = 1
li_Port = 443
li_BAutoReconnect = 1
li_Success = loo_Rest.Connect("my-dynamics-domain.api.crm.dynamics.com",li_Port,li_BTls,li_BAutoReconnect)
if li_Success <> 1 then
    Write-Debug "ConnectFailReason: " + string(loo_Rest.ConnectFailReason)
    Write-Debug loo_Rest.LastErrorText
    destroy loo_Rest
    return
end if

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

loo_SbResponseBody = create oleobject
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")

li_Success = loo_Rest.FullRequestNoBodySb("GET","/api/data/v9.0/contacts(1fa1e5b9-88df-e311-b8e5-6c3be5a8b200)",loo_SbResponseBody)
if li_Success <> 1 then
    Write-Debug loo_Rest.LastErrorText
    destroy loo_Rest
    destroy loo_SbResponseBody
    return
end if

li_RespStatusCode = loo_Rest.ResponseStatusCode
if li_RespStatusCode >= 400 then
    Write-Debug "Response Status Code = " + string(li_RespStatusCode)
    Write-Debug "Response Header:"
    Write-Debug loo_Rest.ResponseHeader
    Write-Debug "Response Body:"
    Write-Debug loo_SbResponseBody.GetAsString()
    destroy loo_Rest
    destroy loo_SbResponseBody
    return
end if

loo_JsonResponse = create oleobject
li_rc = loo_JsonResponse.ConnectToNewObject("Chilkat_9_5_0.JsonObject")

loo_JsonResponse.LoadSb(loo_SbResponseBody)

ls_OdataContext = loo_JsonResponse.StringOf("\"@odata.context\"")
ls_OdataEtag = loo_JsonResponse.StringOf("\"@odata.etag\"")
li_Customertypecode = loo_JsonResponse.IntOf("customertypecode")
li_Address1_latitude = loo_JsonResponse.IntOf("address1_latitude")
ls_Birthdate = loo_JsonResponse.StringOf("birthdate")
li_Merged = loo_JsonResponse.BoolOf("merged")
li_Gendercode = loo_JsonResponse.IntOf("gendercode")
li_Territorycode = loo_JsonResponse.IntOf("territorycode")
ls_Emailaddress1 = loo_JsonResponse.StringOf("emailaddress1")
li_Haschildrencode = loo_JsonResponse.IntOf("haschildrencode")
li_Preferredappointmenttimecode = loo_JsonResponse.IntOf("preferredappointmenttimecode")
li_Isbackofficecustomer = loo_JsonResponse.BoolOf("isbackofficecustomer")
ls_Modifiedon = loo_JsonResponse.StringOf("modifiedon")
ls_V_owninguser_value = loo_JsonResponse.StringOf("_owninguser_value")
li_Importsequencenumber = loo_JsonResponse.IntOf("importsequencenumber")
ls_Address1_composite = loo_JsonResponse.StringOf("address1_composite")
li_Address1_longitude = loo_JsonResponse.IntOf("address1_longitude")
li_Marketingonly = loo_JsonResponse.BoolOf("marketingonly")
li_Donotphone = loo_JsonResponse.BoolOf("donotphone")
li_Preferredcontactmethodcode = loo_JsonResponse.IntOf("preferredcontactmethodcode")
li_Educationcode = loo_JsonResponse.IntOf("educationcode")
ls_V_ownerid_value = loo_JsonResponse.StringOf("_ownerid_value")
li_Customersizecode = loo_JsonResponse.IntOf("customersizecode")
ls_Firstname = loo_JsonResponse.StringOf("firstname")
li_Donotpostalmail = loo_JsonResponse.BoolOf("donotpostalmail")
ls_Yomifullname = loo_JsonResponse.StringOf("yomifullname")
li_Address2_addresstypecode = loo_JsonResponse.IntOf("address2_addresstypecode")
li_Donotemail = loo_JsonResponse.BoolOf("donotemail")
li_Address2_shippingmethodcode = loo_JsonResponse.IntOf("address2_shippingmethodcode")
ls_Fullname = loo_JsonResponse.StringOf("fullname")
li_Timezoneruleversionnumber = loo_JsonResponse.IntOf("timezoneruleversionnumber")
ls_Address1_addressid = loo_JsonResponse.StringOf("address1_addressid")
li_Address2_freighttermscode = loo_JsonResponse.IntOf("address2_freighttermscode")
li_Statuscode = loo_JsonResponse.IntOf("statuscode")
ls_Createdon = loo_JsonResponse.StringOf("createdon")
ls_Address1_stateorprovince = loo_JsonResponse.StringOf("address1_stateorprovince")
ls_Lastname = loo_JsonResponse.StringOf("lastname")
li_Donotsendmm = loo_JsonResponse.BoolOf("donotsendmm")
li_Donotfax = loo_JsonResponse.BoolOf("donotfax")
li_Leadsourcecode = loo_JsonResponse.IntOf("leadsourcecode")
ls_Address1_country = loo_JsonResponse.StringOf("address1_country")
li_Versionnumber = loo_JsonResponse.IntOf("versionnumber")
ls_Address1_line1 = loo_JsonResponse.StringOf("address1_line1")
li_Creditonhold = loo_JsonResponse.BoolOf("creditonhold")
ls_Telephone1 = loo_JsonResponse.StringOf("telephone1")
ls_V_owningbusinessunit_value = loo_JsonResponse.StringOf("_owningbusinessunit_value")
ls_Address3_addressid = loo_JsonResponse.StringOf("address3_addressid")
li_Donotbulkemail = loo_JsonResponse.BoolOf("donotbulkemail")
ls_V_modifiedby_value = loo_JsonResponse.StringOf("_modifiedby_value")
li_Followemail = loo_JsonResponse.BoolOf("followemail")
li_Shippingmethodcode = loo_JsonResponse.IntOf("shippingmethodcode")
ls_V_createdby_value = loo_JsonResponse.StringOf("_createdby_value")
ls_Address1_city = loo_JsonResponse.StringOf("address1_city")
li_Donotbulkpostalmail = loo_JsonResponse.BoolOf("donotbulkpostalmail")
ls_V_parentcustomerid_value = loo_JsonResponse.StringOf("_parentcustomerid_value")
ls_Contactid = loo_JsonResponse.StringOf("contactid")
li_Participatesinworkflow = loo_JsonResponse.BoolOf("participatesinworkflow")
li_Statecode = loo_JsonResponse.IntOf("statecode")
ls_Overriddencreatedon = loo_JsonResponse.StringOf("overriddencreatedon")
ls_Address2_addressid = loo_JsonResponse.StringOf("address2_addressid")
ls_Address1_postalcode = loo_JsonResponse.StringOf("address1_postalcode")
li_Int_kloutscore = loo_JsonResponse.IntOf("int_kloutscore")
ls_Spousesname = loo_JsonResponse.StringOf("spousesname")
ls_Emailaddress3 = loo_JsonResponse.StringOf("emailaddress3")
ls_Address3_telephone3 = loo_JsonResponse.StringOf("address3_telephone3")
ls_Mobilephone = loo_JsonResponse.StringOf("mobilephone")
ls_Utcconversiontimezonecode = loo_JsonResponse.StringOf("utcconversiontimezonecode")
ls_V_preferredserviceid_value = loo_JsonResponse.StringOf("_preferredserviceid_value")
ls_Address3_shippingmethodcode = loo_JsonResponse.StringOf("address3_shippingmethodcode")
ls_Int_twitterservice = loo_JsonResponse.StringOf("int_twitterservice")
ls_Annualincome = loo_JsonResponse.StringOf("annualincome")
ls_Fax = loo_JsonResponse.StringOf("fax")
ls_Telephone3 = loo_JsonResponse.StringOf("telephone3")
ls_Address1_primarycontactname = loo_JsonResponse.StringOf("address1_primarycontactname")
ls_Address3_city = loo_JsonResponse.StringOf("address3_city")
ls_Lastonholdtime = loo_JsonResponse.StringOf("lastonholdtime")
ls_Address2_stateorprovince = loo_JsonResponse.StringOf("address2_stateorprovince")
ls_Address2_line1 = loo_JsonResponse.StringOf("address2_line1")
ls_Assistantphone = loo_JsonResponse.StringOf("assistantphone")
ls_Lastusedincampaign = loo_JsonResponse.StringOf("lastusedincampaign")
ls_Address3_freighttermscode = loo_JsonResponse.StringOf("address3_freighttermscode")
ls_Pager = loo_JsonResponse.StringOf("pager")
ls_Employeeid = loo_JsonResponse.StringOf("employeeid")
ls_Managername = loo_JsonResponse.StringOf("managername")
ls_Address1_name = loo_JsonResponse.StringOf("address1_name")
ls_Department = loo_JsonResponse.StringOf("department")
ls_Address3_country = loo_JsonResponse.StringOf("address3_country")
ls_Address2_telephone1 = loo_JsonResponse.StringOf("address2_telephone1")
ls_Address2_primarycontactname = loo_JsonResponse.StringOf("address2_primarycontactname")
ls_Address2_latitude = loo_JsonResponse.StringOf("address2_latitude")
ls_Address3_latitude = loo_JsonResponse.StringOf("address3_latitude")
ls_Address2_postalcode = loo_JsonResponse.StringOf("address2_postalcode")
ls_Entityimage_timestamp = loo_JsonResponse.StringOf("entityimage_timestamp")
ls_V_originatingleadid_value = loo_JsonResponse.StringOf("_originatingleadid_value")
ls_V_masterid_value = loo_JsonResponse.StringOf("_masterid_value")
ls_V_createdonbehalfby_value = loo_JsonResponse.StringOf("_createdonbehalfby_value")
ls_Address3_postofficebox = loo_JsonResponse.StringOf("address3_postofficebox")
ls_Subscriptionid = loo_JsonResponse.StringOf("subscriptionid")
ls_Business2 = loo_JsonResponse.StringOf("business2")
ls_Address3_county = loo_JsonResponse.StringOf("address3_county")
ls_Address1_telephone2 = loo_JsonResponse.StringOf("address1_telephone2")
ls_Address1_freighttermscode = loo_JsonResponse.StringOf("address1_freighttermscode")
ls_Address3_addresstypecode = loo_JsonResponse.StringOf("address3_addresstypecode")
ls_Address1_addresstypecode = loo_JsonResponse.StringOf("address1_addresstypecode")
ls_Aging90_base = loo_JsonResponse.StringOf("aging90_base")
ls_Address3_primarycontactname = loo_JsonResponse.StringOf("address3_primarycontactname")
ls_Familystatuscode = loo_JsonResponse.StringOf("familystatuscode")
ls_Home2 = loo_JsonResponse.StringOf("home2")
ls_Int_kloutscoreservice = loo_JsonResponse.StringOf("int_kloutscoreservice")
ls_Address2_utcoffset = loo_JsonResponse.StringOf("address2_utcoffset")
ls_Aging60 = loo_JsonResponse.StringOf("aging60")
ls_Telephone2 = loo_JsonResponse.StringOf("telephone2")
ls_Yomimiddlename = loo_JsonResponse.StringOf("yomimiddlename")
ls_V_modifiedonbehalfby_value = loo_JsonResponse.StringOf("_modifiedonbehalfby_value")
ls_Jobtitle = loo_JsonResponse.StringOf("jobtitle")
ls_Address3_utcoffset = loo_JsonResponse.StringOf("address3_utcoffset")
ls_Address1_telephone3 = loo_JsonResponse.StringOf("address1_telephone3")
ls_Address2_line2 = loo_JsonResponse.StringOf("address2_line2")
ls_Creditlimit_base = loo_JsonResponse.StringOf("creditlimit_base")
ls_Address3_line1 = loo_JsonResponse.StringOf("address3_line1")
ls_Address1_county = loo_JsonResponse.StringOf("address1_county")
ls_V_createdbyexternalparty_value = loo_JsonResponse.StringOf("_createdbyexternalparty_value")
ls_Entityimageid = loo_JsonResponse.StringOf("entityimageid")
ls_Processid = loo_JsonResponse.StringOf("processid")
ls_Int_facebook = loo_JsonResponse.StringOf("int_facebook")
ls_Description = loo_JsonResponse.StringOf("description")
ls_Address1_fax = loo_JsonResponse.StringOf("address1_fax")
ls_Address3_line2 = loo_JsonResponse.StringOf("address3_line2")
ls_Externaluseridentifier = loo_JsonResponse.StringOf("externaluseridentifier")
ls_Int_facebookservice = loo_JsonResponse.StringOf("int_facebookservice")
ls_Aging30_base = loo_JsonResponse.StringOf("aging30_base")
ls_V_callback = loo_JsonResponse.StringOf("callback")
ls_Emailaddress2 = loo_JsonResponse.StringOf("emailaddress2")
ls_Address2_line3 = loo_JsonResponse.StringOf("address2_line3")
ls_Managerphone = loo_JsonResponse.StringOf("managerphone")
ls_Websiteurl = loo_JsonResponse.StringOf("websiteurl")
ls_Exchangerate = loo_JsonResponse.StringOf("exchangerate")
ls_Address1_telephone1 = loo_JsonResponse.StringOf("address1_telephone1")
ls_Address3_composite = loo_JsonResponse.StringOf("address3_composite")
ls_Address3_fax = loo_JsonResponse.StringOf("address3_fax")
ls_Childrensnames = loo_JsonResponse.StringOf("childrensnames")
ls_V_owningteam_value = loo_JsonResponse.StringOf("_owningteam_value")
ls_Numberofchildren = loo_JsonResponse.StringOf("numberofchildren")
ls_Address2_postofficebox = loo_JsonResponse.StringOf("address2_postofficebox")
ls_Aging90 = loo_JsonResponse.StringOf("aging90")
ls_Aging60_base = loo_JsonResponse.StringOf("aging60_base")
ls_V_transactioncurrencyid_value = loo_JsonResponse.StringOf("_transactioncurrencyid_value")
ls_Entityimage = loo_JsonResponse.StringOf("entityimage")
ls_V_modifiedbyexternalparty_value = loo_JsonResponse.StringOf("_modifiedbyexternalparty_value")
ls_Paymenttermscode = loo_JsonResponse.StringOf("paymenttermscode")
ls_Address3_name = loo_JsonResponse.StringOf("address3_name")
ls_Ftpsiteurl = loo_JsonResponse.StringOf("ftpsiteurl")
ls_Address1_shippingmethodcode = loo_JsonResponse.StringOf("address1_shippingmethodcode")
ls_V_preferredsystemuserid_value = loo_JsonResponse.StringOf("_preferredsystemuserid_value")
ls_Address2_telephone2 = loo_JsonResponse.StringOf("address2_telephone2")
ls_V_slainvokedid_value = loo_JsonResponse.StringOf("_slainvokedid_value")
ls_Address3_telephone1 = loo_JsonResponse.StringOf("address3_telephone1")
ls_Nickname = loo_JsonResponse.StringOf("nickname")
ls_Address1_postofficebox = loo_JsonResponse.StringOf("address1_postofficebox")
ls_V_preferredequipmentid_value = loo_JsonResponse.StringOf("_preferredequipmentid_value")
ls_Assistantname = loo_JsonResponse.StringOf("assistantname")
ls_Address2_country = loo_JsonResponse.StringOf("address2_country")
ls_V_accountid_value = loo_JsonResponse.StringOf("_accountid_value")
ls_Address2_name = loo_JsonResponse.StringOf("address2_name")
ls_Stageid = loo_JsonResponse.StringOf("stageid")
ls_Address3_longitude = loo_JsonResponse.StringOf("address3_longitude")
ls_Onholdtime = loo_JsonResponse.StringOf("onholdtime")
ls_Address2_telephone3 = loo_JsonResponse.StringOf("address2_telephone3")
ls_Address3_upszone = loo_JsonResponse.StringOf("address3_upszone")
ls_Aging30 = loo_JsonResponse.StringOf("aging30")
ls_Address2_upszone = loo_JsonResponse.StringOf("address2_upszone")
ls_Address1_upszone = loo_JsonResponse.StringOf("address1_upszone")
ls_Creditlimit = loo_JsonResponse.StringOf("creditlimit")
ls_Salutation = loo_JsonResponse.StringOf("salutation")
ls_Traversedpath = loo_JsonResponse.StringOf("traversedpath")
ls_Accountrolecode = loo_JsonResponse.StringOf("accountrolecode")
ls_Address1_utcoffset = loo_JsonResponse.StringOf("address1_utcoffset")
ls_Governmentid = loo_JsonResponse.StringOf("governmentid")
ls_Annualincome_base = loo_JsonResponse.StringOf("annualincome_base")
ls_Address3_stateorprovince = loo_JsonResponse.StringOf("address3_stateorprovince")
ls_Address3_postalcode = loo_JsonResponse.StringOf("address3_postalcode")
ls_Address2_city = loo_JsonResponse.StringOf("address2_city")
ls_Msdyn_gdproptout = loo_JsonResponse.StringOf("msdyn_gdproptout")
ls_Company = loo_JsonResponse.StringOf("company")
ls_Address1_line2 = loo_JsonResponse.StringOf("address1_line2")
ls_Address2_longitude = loo_JsonResponse.StringOf("address2_longitude")
ls_Int_twitter = loo_JsonResponse.StringOf("int_twitter")
ls_Address3_telephone2 = loo_JsonResponse.StringOf("address3_telephone2")
ls_Yomifirstname = loo_JsonResponse.StringOf("yomifirstname")
ls_Address2_composite = loo_JsonResponse.StringOf("address2_composite")
ls_Address2_county = loo_JsonResponse.StringOf("address2_county")
ls_Suffix = loo_JsonResponse.StringOf("suffix")
ls_Anniversary = loo_JsonResponse.StringOf("anniversary")
ls_V_parentcontactid_value = loo_JsonResponse.StringOf("_parentcontactid_value")
ls_Address2_fax = loo_JsonResponse.StringOf("address2_fax")
ls_Yomilastname = loo_JsonResponse.StringOf("yomilastname")
ls_Preferredappointmentdaycode = loo_JsonResponse.StringOf("preferredappointmentdaycode")
ls_Entityimage_url = loo_JsonResponse.StringOf("entityimage_url")
ls_Address1_line3 = loo_JsonResponse.StringOf("address1_line3")
ls_V_defaultpricelevelid_value = loo_JsonResponse.StringOf("_defaultpricelevelid_value")
ls_V_slaid_value = loo_JsonResponse.StringOf("_slaid_value")
ls_Middlename = loo_JsonResponse.StringOf("middlename")
ls_Address3_line3 = loo_JsonResponse.StringOf("address3_line3")
ls_Timespentbymeonemailandmeetings = loo_JsonResponse.StringOf("timespentbymeonemailandmeetings")


destroy loo_Rest
destroy loo_SbResponseBody
destroy loo_JsonResponse

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
}