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

Tcl Example


load ./chilkat.dll

set rest [new_CkRest]

#  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/contacts(1fa1e5b9-88df-e311-b8e5-6c3be5a8b200)
set bTls 1
set port 443
set bAutoReconnect 1
set success [CkRest_Connect $rest "my-dynamics-domain.api.crm.dynamics.com" $port $bTls $bAutoReconnect]
if {[expr $success != 1]} then {
    puts "ConnectFailReason: [CkRest_ConnectFailReason $rest]"
    puts [CkRest_lastErrorText $rest]
    delete_CkRest $rest
    exit
}

CkRest_AddHeader $rest "OData-MaxVersion" "4.0"
CkRest_AddHeader $rest "Accept" "application/json"
CkRest_AddHeader $rest "OData-Version" "4.0"
CkRest_AddHeader $rest "Authorization" "Bearer DYNAMICS_CRM_ACCESS_TOKEN"

set sbResponseBody [new_CkStringBuilder]

set success [CkRest_FullRequestNoBodySb $rest "GET" "/api/data/v9.0/contacts(1fa1e5b9-88df-e311-b8e5-6c3be5a8b200)" $sbResponseBody]
if {[expr $success != 1]} then {
    puts [CkRest_lastErrorText $rest]
    delete_CkRest $rest
    delete_CkStringBuilder $sbResponseBody
    exit
}

set respStatusCode [CkRest_ResponseStatusCode $rest]
if {[expr $respStatusCode >= 400]} then {
    puts "Response Status Code = $respStatusCode"
    puts "Response Header:"
    puts [CkRest_responseHeader $rest]
    puts "Response Body:"
    puts [CkStringBuilder_getAsString $sbResponseBody]
    delete_CkRest $rest
    delete_CkStringBuilder $sbResponseBody
    exit
}

set jsonResponse [new_CkJsonObject]

CkJsonObject_LoadSb $jsonResponse $sbResponseBody

set odataContext [CkJsonObject_stringOf $jsonResponse "\"@odata.context\""]
set odataEtag [CkJsonObject_stringOf $jsonResponse "\"@odata.etag\""]
set customertypecode [CkJsonObject_IntOf $jsonResponse "customertypecode"]
set address1_latitude [CkJsonObject_IntOf $jsonResponse "address1_latitude"]
set birthdate [CkJsonObject_stringOf $jsonResponse "birthdate"]
set merged [CkJsonObject_BoolOf $jsonResponse "merged"]
set gendercode [CkJsonObject_IntOf $jsonResponse "gendercode"]
set territorycode [CkJsonObject_IntOf $jsonResponse "territorycode"]
set emailaddress1 [CkJsonObject_stringOf $jsonResponse "emailaddress1"]
set haschildrencode [CkJsonObject_IntOf $jsonResponse "haschildrencode"]
set preferredappointmenttimecode [CkJsonObject_IntOf $jsonResponse "preferredappointmenttimecode"]
set isbackofficecustomer [CkJsonObject_BoolOf $jsonResponse "isbackofficecustomer"]
set modifiedon [CkJsonObject_stringOf $jsonResponse "modifiedon"]
set v_owninguser_value [CkJsonObject_stringOf $jsonResponse "_owninguser_value"]
set importsequencenumber [CkJsonObject_IntOf $jsonResponse "importsequencenumber"]
set address1_composite [CkJsonObject_stringOf $jsonResponse "address1_composite"]
set address1_longitude [CkJsonObject_IntOf $jsonResponse "address1_longitude"]
set marketingonly [CkJsonObject_BoolOf $jsonResponse "marketingonly"]
set donotphone [CkJsonObject_BoolOf $jsonResponse "donotphone"]
set preferredcontactmethodcode [CkJsonObject_IntOf $jsonResponse "preferredcontactmethodcode"]
set educationcode [CkJsonObject_IntOf $jsonResponse "educationcode"]
set v_ownerid_value [CkJsonObject_stringOf $jsonResponse "_ownerid_value"]
set customersizecode [CkJsonObject_IntOf $jsonResponse "customersizecode"]
set firstname [CkJsonObject_stringOf $jsonResponse "firstname"]
set donotpostalmail [CkJsonObject_BoolOf $jsonResponse "donotpostalmail"]
set yomifullname [CkJsonObject_stringOf $jsonResponse "yomifullname"]
set address2_addresstypecode [CkJsonObject_IntOf $jsonResponse "address2_addresstypecode"]
set donotemail [CkJsonObject_BoolOf $jsonResponse "donotemail"]
set address2_shippingmethodcode [CkJsonObject_IntOf $jsonResponse "address2_shippingmethodcode"]
set fullname [CkJsonObject_stringOf $jsonResponse "fullname"]
set timezoneruleversionnumber [CkJsonObject_IntOf $jsonResponse "timezoneruleversionnumber"]
set address1_addressid [CkJsonObject_stringOf $jsonResponse "address1_addressid"]
set address2_freighttermscode [CkJsonObject_IntOf $jsonResponse "address2_freighttermscode"]
set statuscode [CkJsonObject_IntOf $jsonResponse "statuscode"]
set createdon [CkJsonObject_stringOf $jsonResponse "createdon"]
set address1_stateorprovince [CkJsonObject_stringOf $jsonResponse "address1_stateorprovince"]
set lastname [CkJsonObject_stringOf $jsonResponse "lastname"]
set donotsendmm [CkJsonObject_BoolOf $jsonResponse "donotsendmm"]
set donotfax [CkJsonObject_BoolOf $jsonResponse "donotfax"]
set leadsourcecode [CkJsonObject_IntOf $jsonResponse "leadsourcecode"]
set address1_country [CkJsonObject_stringOf $jsonResponse "address1_country"]
set versionnumber [CkJsonObject_IntOf $jsonResponse "versionnumber"]
set address1_line1 [CkJsonObject_stringOf $jsonResponse "address1_line1"]
set creditonhold [CkJsonObject_BoolOf $jsonResponse "creditonhold"]
set telephone1 [CkJsonObject_stringOf $jsonResponse "telephone1"]
set v_owningbusinessunit_value [CkJsonObject_stringOf $jsonResponse "_owningbusinessunit_value"]
set address3_addressid [CkJsonObject_stringOf $jsonResponse "address3_addressid"]
set donotbulkemail [CkJsonObject_BoolOf $jsonResponse "donotbulkemail"]
set v_modifiedby_value [CkJsonObject_stringOf $jsonResponse "_modifiedby_value"]
set followemail [CkJsonObject_BoolOf $jsonResponse "followemail"]
set shippingmethodcode [CkJsonObject_IntOf $jsonResponse "shippingmethodcode"]
set v_createdby_value [CkJsonObject_stringOf $jsonResponse "_createdby_value"]
set address1_city [CkJsonObject_stringOf $jsonResponse "address1_city"]
set donotbulkpostalmail [CkJsonObject_BoolOf $jsonResponse "donotbulkpostalmail"]
set v_parentcustomerid_value [CkJsonObject_stringOf $jsonResponse "_parentcustomerid_value"]
set contactid [CkJsonObject_stringOf $jsonResponse "contactid"]
set participatesinworkflow [CkJsonObject_BoolOf $jsonResponse "participatesinworkflow"]
set statecode [CkJsonObject_IntOf $jsonResponse "statecode"]
set overriddencreatedon [CkJsonObject_stringOf $jsonResponse "overriddencreatedon"]
set address2_addressid [CkJsonObject_stringOf $jsonResponse "address2_addressid"]
set address1_postalcode [CkJsonObject_stringOf $jsonResponse "address1_postalcode"]
set int_kloutscore [CkJsonObject_IntOf $jsonResponse "int_kloutscore"]
set spousesname [CkJsonObject_stringOf $jsonResponse "spousesname"]
set emailaddress3 [CkJsonObject_stringOf $jsonResponse "emailaddress3"]
set address3_telephone3 [CkJsonObject_stringOf $jsonResponse "address3_telephone3"]
set mobilephone [CkJsonObject_stringOf $jsonResponse "mobilephone"]
set utcconversiontimezonecode [CkJsonObject_stringOf $jsonResponse "utcconversiontimezonecode"]
set v_preferredserviceid_value [CkJsonObject_stringOf $jsonResponse "_preferredserviceid_value"]
set address3_shippingmethodcode [CkJsonObject_stringOf $jsonResponse "address3_shippingmethodcode"]
set int_twitterservice [CkJsonObject_stringOf $jsonResponse "int_twitterservice"]
set annualincome [CkJsonObject_stringOf $jsonResponse "annualincome"]
set fax [CkJsonObject_stringOf $jsonResponse "fax"]
set telephone3 [CkJsonObject_stringOf $jsonResponse "telephone3"]
set address1_primarycontactname [CkJsonObject_stringOf $jsonResponse "address1_primarycontactname"]
set address3_city [CkJsonObject_stringOf $jsonResponse "address3_city"]
set lastonholdtime [CkJsonObject_stringOf $jsonResponse "lastonholdtime"]
set address2_stateorprovince [CkJsonObject_stringOf $jsonResponse "address2_stateorprovince"]
set address2_line1 [CkJsonObject_stringOf $jsonResponse "address2_line1"]
set assistantphone [CkJsonObject_stringOf $jsonResponse "assistantphone"]
set lastusedincampaign [CkJsonObject_stringOf $jsonResponse "lastusedincampaign"]
set address3_freighttermscode [CkJsonObject_stringOf $jsonResponse "address3_freighttermscode"]
set pager [CkJsonObject_stringOf $jsonResponse "pager"]
set employeeid [CkJsonObject_stringOf $jsonResponse "employeeid"]
set managername [CkJsonObject_stringOf $jsonResponse "managername"]
set address1_name [CkJsonObject_stringOf $jsonResponse "address1_name"]
set department [CkJsonObject_stringOf $jsonResponse "department"]
set address3_country [CkJsonObject_stringOf $jsonResponse "address3_country"]
set address2_telephone1 [CkJsonObject_stringOf $jsonResponse "address2_telephone1"]
set address2_primarycontactname [CkJsonObject_stringOf $jsonResponse "address2_primarycontactname"]
set address2_latitude [CkJsonObject_stringOf $jsonResponse "address2_latitude"]
set address3_latitude [CkJsonObject_stringOf $jsonResponse "address3_latitude"]
set address2_postalcode [CkJsonObject_stringOf $jsonResponse "address2_postalcode"]
set entityimage_timestamp [CkJsonObject_stringOf $jsonResponse "entityimage_timestamp"]
set v_originatingleadid_value [CkJsonObject_stringOf $jsonResponse "_originatingleadid_value"]
set v_masterid_value [CkJsonObject_stringOf $jsonResponse "_masterid_value"]
set v_createdonbehalfby_value [CkJsonObject_stringOf $jsonResponse "_createdonbehalfby_value"]
set address3_postofficebox [CkJsonObject_stringOf $jsonResponse "address3_postofficebox"]
set subscriptionid [CkJsonObject_stringOf $jsonResponse "subscriptionid"]
set business2 [CkJsonObject_stringOf $jsonResponse "business2"]
set address3_county [CkJsonObject_stringOf $jsonResponse "address3_county"]
set address1_telephone2 [CkJsonObject_stringOf $jsonResponse "address1_telephone2"]
set address1_freighttermscode [CkJsonObject_stringOf $jsonResponse "address1_freighttermscode"]
set address3_addresstypecode [CkJsonObject_stringOf $jsonResponse "address3_addresstypecode"]
set address1_addresstypecode [CkJsonObject_stringOf $jsonResponse "address1_addresstypecode"]
set aging90_base [CkJsonObject_stringOf $jsonResponse "aging90_base"]
set address3_primarycontactname [CkJsonObject_stringOf $jsonResponse "address3_primarycontactname"]
set familystatuscode [CkJsonObject_stringOf $jsonResponse "familystatuscode"]
set home2 [CkJsonObject_stringOf $jsonResponse "home2"]
set int_kloutscoreservice [CkJsonObject_stringOf $jsonResponse "int_kloutscoreservice"]
set address2_utcoffset [CkJsonObject_stringOf $jsonResponse "address2_utcoffset"]
set aging60 [CkJsonObject_stringOf $jsonResponse "aging60"]
set telephone2 [CkJsonObject_stringOf $jsonResponse "telephone2"]
set yomimiddlename [CkJsonObject_stringOf $jsonResponse "yomimiddlename"]
set v_modifiedonbehalfby_value [CkJsonObject_stringOf $jsonResponse "_modifiedonbehalfby_value"]
set jobtitle [CkJsonObject_stringOf $jsonResponse "jobtitle"]
set address3_utcoffset [CkJsonObject_stringOf $jsonResponse "address3_utcoffset"]
set address1_telephone3 [CkJsonObject_stringOf $jsonResponse "address1_telephone3"]
set address2_line2 [CkJsonObject_stringOf $jsonResponse "address2_line2"]
set creditlimit_base [CkJsonObject_stringOf $jsonResponse "creditlimit_base"]
set address3_line1 [CkJsonObject_stringOf $jsonResponse "address3_line1"]
set address1_county [CkJsonObject_stringOf $jsonResponse "address1_county"]
set v_createdbyexternalparty_value [CkJsonObject_stringOf $jsonResponse "_createdbyexternalparty_value"]
set entityimageid [CkJsonObject_stringOf $jsonResponse "entityimageid"]
set processid [CkJsonObject_stringOf $jsonResponse "processid"]
set int_facebook [CkJsonObject_stringOf $jsonResponse "int_facebook"]
set description [CkJsonObject_stringOf $jsonResponse "description"]
set address1_fax [CkJsonObject_stringOf $jsonResponse "address1_fax"]
set address3_line2 [CkJsonObject_stringOf $jsonResponse "address3_line2"]
set externaluseridentifier [CkJsonObject_stringOf $jsonResponse "externaluseridentifier"]
set int_facebookservice [CkJsonObject_stringOf $jsonResponse "int_facebookservice"]
set aging30_base [CkJsonObject_stringOf $jsonResponse "aging30_base"]
set v_callback [CkJsonObject_stringOf $jsonResponse "callback"]
set emailaddress2 [CkJsonObject_stringOf $jsonResponse "emailaddress2"]
set address2_line3 [CkJsonObject_stringOf $jsonResponse "address2_line3"]
set managerphone [CkJsonObject_stringOf $jsonResponse "managerphone"]
set websiteurl [CkJsonObject_stringOf $jsonResponse "websiteurl"]
set exchangerate [CkJsonObject_stringOf $jsonResponse "exchangerate"]
set address1_telephone1 [CkJsonObject_stringOf $jsonResponse "address1_telephone1"]
set address3_composite [CkJsonObject_stringOf $jsonResponse "address3_composite"]
set address3_fax [CkJsonObject_stringOf $jsonResponse "address3_fax"]
set childrensnames [CkJsonObject_stringOf $jsonResponse "childrensnames"]
set v_owningteam_value [CkJsonObject_stringOf $jsonResponse "_owningteam_value"]
set numberofchildren [CkJsonObject_stringOf $jsonResponse "numberofchildren"]
set address2_postofficebox [CkJsonObject_stringOf $jsonResponse "address2_postofficebox"]
set aging90 [CkJsonObject_stringOf $jsonResponse "aging90"]
set aging60_base [CkJsonObject_stringOf $jsonResponse "aging60_base"]
set v_transactioncurrencyid_value [CkJsonObject_stringOf $jsonResponse "_transactioncurrencyid_value"]
set entityimage [CkJsonObject_stringOf $jsonResponse "entityimage"]
set v_modifiedbyexternalparty_value [CkJsonObject_stringOf $jsonResponse "_modifiedbyexternalparty_value"]
set paymenttermscode [CkJsonObject_stringOf $jsonResponse "paymenttermscode"]
set address3_name [CkJsonObject_stringOf $jsonResponse "address3_name"]
set ftpsiteurl [CkJsonObject_stringOf $jsonResponse "ftpsiteurl"]
set address1_shippingmethodcode [CkJsonObject_stringOf $jsonResponse "address1_shippingmethodcode"]
set v_preferredsystemuserid_value [CkJsonObject_stringOf $jsonResponse "_preferredsystemuserid_value"]
set address2_telephone2 [CkJsonObject_stringOf $jsonResponse "address2_telephone2"]
set v_slainvokedid_value [CkJsonObject_stringOf $jsonResponse "_slainvokedid_value"]
set address3_telephone1 [CkJsonObject_stringOf $jsonResponse "address3_telephone1"]
set nickname [CkJsonObject_stringOf $jsonResponse "nickname"]
set address1_postofficebox [CkJsonObject_stringOf $jsonResponse "address1_postofficebox"]
set v_preferredequipmentid_value [CkJsonObject_stringOf $jsonResponse "_preferredequipmentid_value"]
set assistantname [CkJsonObject_stringOf $jsonResponse "assistantname"]
set address2_country [CkJsonObject_stringOf $jsonResponse "address2_country"]
set v_accountid_value [CkJsonObject_stringOf $jsonResponse "_accountid_value"]
set address2_name [CkJsonObject_stringOf $jsonResponse "address2_name"]
set stageid [CkJsonObject_stringOf $jsonResponse "stageid"]
set address3_longitude [CkJsonObject_stringOf $jsonResponse "address3_longitude"]
set onholdtime [CkJsonObject_stringOf $jsonResponse "onholdtime"]
set address2_telephone3 [CkJsonObject_stringOf $jsonResponse "address2_telephone3"]
set address3_upszone [CkJsonObject_stringOf $jsonResponse "address3_upszone"]
set aging30 [CkJsonObject_stringOf $jsonResponse "aging30"]
set address2_upszone [CkJsonObject_stringOf $jsonResponse "address2_upszone"]
set address1_upszone [CkJsonObject_stringOf $jsonResponse "address1_upszone"]
set creditlimit [CkJsonObject_stringOf $jsonResponse "creditlimit"]
set salutation [CkJsonObject_stringOf $jsonResponse "salutation"]
set traversedpath [CkJsonObject_stringOf $jsonResponse "traversedpath"]
set accountrolecode [CkJsonObject_stringOf $jsonResponse "accountrolecode"]
set address1_utcoffset [CkJsonObject_stringOf $jsonResponse "address1_utcoffset"]
set governmentid [CkJsonObject_stringOf $jsonResponse "governmentid"]
set annualincome_base [CkJsonObject_stringOf $jsonResponse "annualincome_base"]
set address3_stateorprovince [CkJsonObject_stringOf $jsonResponse "address3_stateorprovince"]
set address3_postalcode [CkJsonObject_stringOf $jsonResponse "address3_postalcode"]
set address2_city [CkJsonObject_stringOf $jsonResponse "address2_city"]
set msdyn_gdproptout [CkJsonObject_stringOf $jsonResponse "msdyn_gdproptout"]
set company [CkJsonObject_stringOf $jsonResponse "company"]
set address1_line2 [CkJsonObject_stringOf $jsonResponse "address1_line2"]
set address2_longitude [CkJsonObject_stringOf $jsonResponse "address2_longitude"]
set int_twitter [CkJsonObject_stringOf $jsonResponse "int_twitter"]
set address3_telephone2 [CkJsonObject_stringOf $jsonResponse "address3_telephone2"]
set yomifirstname [CkJsonObject_stringOf $jsonResponse "yomifirstname"]
set address2_composite [CkJsonObject_stringOf $jsonResponse "address2_composite"]
set address2_county [CkJsonObject_stringOf $jsonResponse "address2_county"]
set suffix [CkJsonObject_stringOf $jsonResponse "suffix"]
set anniversary [CkJsonObject_stringOf $jsonResponse "anniversary"]
set v_parentcontactid_value [CkJsonObject_stringOf $jsonResponse "_parentcontactid_value"]
set address2_fax [CkJsonObject_stringOf $jsonResponse "address2_fax"]
set yomilastname [CkJsonObject_stringOf $jsonResponse "yomilastname"]
set preferredappointmentdaycode [CkJsonObject_stringOf $jsonResponse "preferredappointmentdaycode"]
set entityimage_url [CkJsonObject_stringOf $jsonResponse "entityimage_url"]
set address1_line3 [CkJsonObject_stringOf $jsonResponse "address1_line3"]
set v_defaultpricelevelid_value [CkJsonObject_stringOf $jsonResponse "_defaultpricelevelid_value"]
set v_slaid_value [CkJsonObject_stringOf $jsonResponse "_slaid_value"]
set middlename [CkJsonObject_stringOf $jsonResponse "middlename"]
set address3_line3 [CkJsonObject_stringOf $jsonResponse "address3_line3"]
set timespentbymeonemailandmeetings [CkJsonObject_stringOf $jsonResponse "timespentbymeonemailandmeetings"]

delete_CkRest $rest
delete_CkStringBuilder $sbResponseBody
delete_CkJsonObject $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
}