Chilkat Online Tools

Classic ASP / Zoho CRM REST APIs / Creating 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.

set http = Server.CreateObject("Chilkat_9_5_0.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": [
'     {
'       "External_Quote_ID": "quote1",
'       "Subject": "Quote 1",
'       "Product_Details": [
'         {
'           "product": {
'             "External_Product_ID": "12345678900"
'           },
'           "book": {
'             "External_Price_book_ID": "pricebook1"
'           },
'           "quantity": 100
'         }
'       ]
'     }
'   ]
' }

set json = Server.CreateObject("Chilkat_9_5_0.JsonObject")
success = json.UpdateString("data[0].External_Quote_ID","quote1")
success = json.UpdateString("data[0].Subject","Quote 1")
success = json.UpdateString("data[0].Product_Details[0].product.External_Product_ID","12345678900")
success = json.UpdateString("data[0].Product_Details[0].book.External_Price_book_ID","pricebook1")
success = json.UpdateInt("data[0].Product_Details[0].quantity",100)

' Adds the "Authorization: Bearer <access_token>" header.
http.AuthToken = "<access_token>"
http.SetRequestHeader "X-EXTERNAL","Quotes.External_ID"

' resp is a Chilkat_9_5_0.HttpResponse
Set resp = http.PostJson3("https://domain.com/crm/v2/Quotes","application/json",json)
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 POST
	-H "Authorization: Bearer <access_token>"
	-H "X-EXTERNAL: Quotes.External_ID"
	-d '{
    "data": [
        {
            "External_Quote_ID": "quote1",
            "Subject": "Quote 1",
            "Product_Details": [
                {
                    "product": {
                        "External_Product_ID": "12345678900"
                    },
                    "book": {
                        "External_Price_book_ID": "pricebook1"
                    },
                    "quantity": 100
                }
            ]
        }
    ]
}'
https://domain.com/crm/v2/Quotes

Postman Collection Item JSON

{
  "name": "Creating 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": "POST",
    "header": [
      {
        "key": "X-EXTERNAL",
        "value": "Quotes.External_ID",
        "type": "text"
      }
    ],
    "body": {
      "mode": "raw",
      "raw": "{\n    \"data\": [\n        {\n            \"External_Quote_ID\": \"quote1\",\n            \"Subject\": \"Quote 1\",\n            \"Product_Details\": [\n                {\n                    \"product\": {\n                        \"External_Product_ID\": \"12345678900\"\n                    },\n                    \"book\": {\n                        \"External_Price_book_ID\": \"pricebook1\"\n                    },\n                    \"quantity\": 100\n                }\n            ]\n        }\n    ]\n}",
      "options": {
        "raw": {
          "language": "json"
        }
      }
    },
    "url": {
      "raw": "{{api-domain}}/crm/v2/Quotes",
      "host": [
        "{{api-domain}}"
      ],
      "path": [
        "crm",
        "v2",
        "Quotes"
      ]
    },
    "description": "In this example, we will create a quote by using the external values in the Product_Details section that comprises the associated product and the price book. So, Quotes is the base module's API name, the API names of the external fields in the Products and Price Books modules are External_Product_ID and External_Price_book_ID, respectively."
  },
  "response": [
  ]
}