Back to Collection Items
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)
' 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 = 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": [
' {
' "Solution_Title": "sample",
' "Question": "This is a sample question",
' "Product_Name": {
' "name": "Sample Product",
' "id": "{{product_id}}"
' },
' "Answer": "This is a sample answer"
' }
' ]
' }
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateString("data[0].Solution_Title","sample")
success = json.UpdateString("data[0].Question","This is a sample question")
success = json.UpdateString("data[0].Product_Name.name","Sample Product")
success = json.UpdateString("data[0].Product_Name.id","{{product_id}}")
success = json.UpdateString("data[0].Answer","This is a sample answer")
' Adds the "Authorization: Bearer <access_token>" header.
http.AuthToken = "<access_token>"
' resp is a Chilkat.HttpResponse
Set resp = http.PostJson3("https://domain.com/crm/v2/Solutions/upsert","application/json",json)
If (http.LastMethodSuccess = 0) Then
outFile.WriteLine(http.LastErrorText)
WScript.Quit
End If
outFile.WriteLine(resp.StatusCode)
outFile.WriteLine(resp.BodyStr)
outFile.Close
Curl Command
curl -X POST
-H "Authorization: Bearer <access_token>"
-d '{
"data": [
{
"Solution_Title": "sample",
"Question": "This is a sample question",
"Product_Name": {
"name": "Sample Product",
"id": "{{product_id}}"
},
"Answer": "This is a sample answer"
}
]
}'
https://domain.com/crm/v2/Solutions/upsert
Postman Collection Item JSON
{
"name": "Solutions",
"request": {
"auth": {
"type": "bearer",
"bearer": [
{
"key": "token",
"value": "{{access-token}}",
"type": "string"
}
]
},
"method": "POST",
"header": [
],
"body": {
"mode": "raw",
"raw": "{\n \"data\": [\n {\n \"Solution_Title\": \"sample\",\n \"Question\": \"This is a sample question\",\n \"Product_Name\": {\n \"name\": \"Sample Product\",\n \"id\": \"{{product_id}}\"\n },\n \"Answer\": \"This is a sample answer\"\n }\n ]\n}",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "{{api-domain}}/crm/v2/Solutions/upsert",
"host": [
"{{api-domain}}"
],
"path": [
"crm",
"v2",
"Solutions",
"upsert"
]
},
"description": "To upsert records in the Solutions module."
},
"response": [
]
}