Classic ASP / Zoho CRM REST APIs / Updating a subform lookup record through an external field in the associated module
Back to Collection Items
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = Server.CreateObject("Chilkat.Http")
' Use this online tool to generate code from sample JSON: Generate Code to Create JSON
' The following JSON is sent in the request body.
' {
' "data": [
' {
' "Subform_External": [
' {
' "Deal_Lookup": {
' "External_Deal_ID": "userdeal1"
' }
' }
' ]
' }
' ]
' }
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = Server.CreateObject("Chilkat.JsonObject")
success = json.UpdateString("data[0].Subform_External[0].Deal_Lookup.External_Deal_ID","userdeal1")
' Adds the "Authorization: Bearer <access_token>" header.
http.AuthToken = "<access_token>"
http.SetRequestHeader "X-EXTERNAL","Contacts.External_Contact_ID,Contacts.Subform_External.Deal_Lookup.External_Deal_ID"
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbRequestBody = Server.CreateObject("Chilkat.StringBuilder")
success = json.EmitSb(sbRequestBody)
' resp is a Chilkat.HttpResponse
Set resp = http.PTextSb("PUT","https://domain.com/crm/v2/Contacts/extcontact2",sbRequestBody,"utf-8","application/json",0,0)
If (http.LastMethodSuccess = 0) Then
Response.Write "<pre>" & Server.HTMLEncode( http.LastErrorText) & "</pre>"
Response.End
End If
Response.Write "<pre>" & Server.HTMLEncode( resp.StatusCode) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( resp.BodyStr) & "</pre>"
%>
</body>
</html>
Curl Command
curl -X PUT
-H "Authorization: Bearer <access_token>"
-H "X-EXTERNAL: Contacts.External_Contact_ID,Contacts.Subform_External.Deal_Lookup.External_Deal_ID"
-d '{
"data": [
{
"Subform_External": [
{
"Deal_Lookup": {
"External_Deal_ID": "userdeal1"
}
}
]
}
]
}'
https://domain.com/crm/v2/Contacts/extcontact2
Postman Collection Item JSON
{
"name": "Updating a subform lookup record through an external field in the associated module",
"request": {
"auth": {
"type": "bearer",
"bearer": [
{
"key": "token",
"value": "{{access-token}}",
"type": "string"
}
]
},
"method": "PUT",
"header": [
{
"key": "X-EXTERNAL",
"value": "Contacts.External_Contact_ID,Contacts.Subform_External.Deal_Lookup.External_Deal_ID",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"data\": [\n {\n \"Subform_External\": [\n {\n \"Deal_Lookup\": {\n \"External_Deal_ID\": \"userdeal1\"\n }\n }\n ]\n }\n ]\n}",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "{{api-domain}}/crm/v2/Contacts/extcontact2",
"host": [
"{{api-domain}}"
],
"path": [
"crm",
"v2",
"Contacts",
"extcontact2"
]
},
"description": "Specify the external field's API name and its value in the lookup field JSON object of the Subform."
},
"response": [
]
}