Chilkat Online Tools

VB6 / Zoho CRM REST APIs / Price Books

Back to Collection Items

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As New ChilkatHttp
Dim success As Long

' 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": [
'     {
'       "Owner": {
'         "id": "{{user-id}}"
'       },
'       "Active": true,
'       "Pricing_Details": [
'         {
'           "to_range": 5,
'           "discount": 0,
'           "from_range": 1
'         },
'         {
'           "to_range": 11,
'           "discount": 1,
'           "from_range": 6
'         },
'         {
'           "to_range": 17,
'           "discount": 2,
'           "from_range": 12
'         },
'         {
'           "to_range": 23,
'           "discount": 3,
'           "from_range": 18
'         },
'         {
'           "to_range": 29,
'           "discount": 4,
'           "from_range": 24
'         }
'       ],
'       "Pricing_Model": "Differential",
'       "Description": "Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.",
'       "Price_Book_Name": "Price_Book_Name"
'     }
'   ]
' }

Dim json As New ChilkatJsonObject
success = json.UpdateString("data[0].Owner.id","{{user-id}}")
success = json.UpdateBool("data[0].Active",1)
success = json.UpdateInt("data[0].Pricing_Details[0].to_range",5)
success = json.UpdateInt("data[0].Pricing_Details[0].discount",0)
success = json.UpdateInt("data[0].Pricing_Details[0].from_range",1)
success = json.UpdateInt("data[0].Pricing_Details[1].to_range",11)
success = json.UpdateInt("data[0].Pricing_Details[1].discount",1)
success = json.UpdateInt("data[0].Pricing_Details[1].from_range",6)
success = json.UpdateInt("data[0].Pricing_Details[2].to_range",17)
success = json.UpdateInt("data[0].Pricing_Details[2].discount",2)
success = json.UpdateInt("data[0].Pricing_Details[2].from_range",12)
success = json.UpdateInt("data[0].Pricing_Details[3].to_range",23)
success = json.UpdateInt("data[0].Pricing_Details[3].discount",3)
success = json.UpdateInt("data[0].Pricing_Details[3].from_range",18)
success = json.UpdateInt("data[0].Pricing_Details[4].to_range",29)
success = json.UpdateInt("data[0].Pricing_Details[4].discount",4)
success = json.UpdateInt("data[0].Pricing_Details[4].from_range",24)
success = json.UpdateString("data[0].Pricing_Model","Differential")
success = json.UpdateString("data[0].Description","Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.")
success = json.UpdateString("data[0].Price_Book_Name","Price_Book_Name")

http.SetRequestHeader "Authorization","{{authorization-token}}"
http.SetRequestHeader "Content-Type","application/json"

Dim sbRequestBody As New ChilkatStringBuilder
success = json.EmitSb(sbRequestBody)

Dim resp As ChilkatHttpResponse
Set resp = http.PTextSb("PUT","https://domain.com/crm/v2.1/Price_Books/{{record-id}}",sbRequestBody,"utf-8","application/json",0,0)
If (http.LastMethodSuccess = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print resp.StatusCode
Debug.Print resp.BodyStr

Curl Command

curl -X PUT
	-H "Authorization: Bearer <access_token>"
	-H "Authorization: {{authorization-token}}"
	-H "Content-Type: application/json"
	-d '{
	"data": [
		{
			"Owner": {
				"id": "{{user-id}}"
			},
			"Active": true,
			"Pricing_Details": [
				{
					"to_range": 5,
					"discount": 0,
					"from_range": 1
				},
				{
					"to_range": 11,
					"discount": 1,
					"from_range": 6
				},
				{
					"to_range": 17,
					"discount": 2,
					"from_range": 12
				},
				{
					"to_range": 23,
					"discount": 3,
					"from_range": 18
				},
				{
					"to_range": 29,
					"discount": 4,
					"from_range": 24
				}
			],
			"Pricing_Model": "Differential",
			"Description": "Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.",
			"Price_Book_Name": "Price_Book_Name"
		}
	]
}'
https://domain.com/crm/v2.1/Price_Books/{{record-id}}

Postman Collection Item JSON

{
  "name": "Price Books",
  "request": {
    "method": "PUT",
    "header": [
      {
        "key": "Authorization",
        "value": "{{authorization-token}}"
      },
      {
        "key": "Content-Type",
        "value": "application/json"
      }
    ],
    "body": {
      "mode": "raw",
      "raw": "{\n\t\"data\": [\n\t\t{\n\t\t\t\"Owner\": {\n\t\t\t\t\"id\": \"{{user-id}}\"\n\t\t\t},\n\t\t\t\"Active\": true,\n\t\t\t\"Pricing_Details\": [\n\t\t\t\t{\n\t\t\t\t\t\"to_range\": 5,\n\t\t\t\t\t\"discount\": 0,\n\t\t\t\t\t\"from_range\": 1\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"to_range\": 11,\n\t\t\t\t\t\"discount\": 1,\n\t\t\t\t\t\"from_range\": 6\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"to_range\": 17,\n\t\t\t\t\t\"discount\": 2,\n\t\t\t\t\t\"from_range\": 12\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"to_range\": 23,\n\t\t\t\t\t\"discount\": 3,\n\t\t\t\t\t\"from_range\": 18\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"to_range\": 29,\n\t\t\t\t\t\"discount\": 4,\n\t\t\t\t\t\"from_range\": 24\n\t\t\t\t}\n\t\t\t],\n\t\t\t\"Pricing_Model\": \"Differential\",\n\t\t\t\"Description\": \"Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.\",\n\t\t\t\"Price_Book_Name\": \"Price_Book_Name\"\n\t\t}\n\t]\n}"
    },
    "url": {
      "raw": "{{api-domain}}/crm/v2.1/Price_Books/{{record-id}}",
      "host": [
        "{{api-domain}}"
      ],
      "path": [
        "crm",
        "v2.1",
        "Price_Books",
        "{{record-id}}"
      ]
    },
    "description": "To update existing entities in the module."
  },
  "response": [
  ]
}