Classic ASP / Zoho CRM REST APIs / Updating an inventory module's record with external fields in the line items
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": [
' {
' "Product_Details": [
' {
' "id": "111111000000133071"
' },
' {
' "product": {
' "External_Product_ID": "12345678900"
' },
' "book": {
' "External_Pricebook_ID": "pricebook2"
' },
' "quantity": 20
' }
' ]
' }
' ]
' }
' 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].Product_Details[0].id","111111000000133071")
success = json.UpdateString("data[0].Product_Details[1].product.External_Product_ID","12345678900")
success = json.UpdateString("data[0].Product_Details[1].book.External_Pricebook_ID","pricebook2")
success = json.UpdateInt("data[0].Product_Details[1].quantity",20)
' Adds the "Authorization: Bearer <access_token>" header.
http.AuthToken = "<access_token>"
http.SetRequestHeader "X-EXTERNAL","Quotes.Product_Details.product.External_Product_ID, Quotes.Product_Details.book.External_Price_book_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/Quotes/quote1",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: Quotes.Product_Details.product.External_Product_ID, Quotes.Product_Details.book.External_Price_book_ID"
-d '{
"data": [
{
"Product_Details": [
{
"id": "111111000000133071"
},
{
"product": {
"External_Product_ID": "12345678900"
},
"book": {
"External_Pricebook_ID": "pricebook2"
},
"quantity": 20
}
]
}
]
}'
https://domain.com/crm/v2/Quotes/quote1
Postman Collection Item JSON
{
"name": "Updating an inventory module's record with external fields in the line items",
"request": {
"auth": {
"type": "bearer",
"bearer": [
{
"key": "token",
"value": "{{access-token}}",
"type": "string"
}
]
},
"method": "PUT",
"header": [
{
"key": "X-EXTERNAL",
"value": "Quotes.Product_Details.product.External_Product_ID, Quotes.Product_Details.book.External_Price_book_ID",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"data\": [\n {\n \"Product_Details\": [\n {\n \"id\": \"111111000000133071\"\n },\n {\n \"product\": {\n \"External_Product_ID\": \"12345678900\"\n },\n \"book\": {\n \"External_Pricebook_ID\": \"pricebook2\"\n },\n \"quantity\": 20\n }\n ]\n }\n ]\n}",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "{{api-domain}}/crm/v2/Quotes/quote1",
"host": [
"{{api-domain}}"
],
"path": [
"crm",
"v2",
"Quotes",
"quote1"
]
},
"description": "In this example, Quotes is the base module. To update the details in the Product_Details section, specify the external field's API name and the value in the product and book JSON objects."
},
"response": [
]
}
