Chilkat Online Tools

Foxpro / Zoho CRM REST APIs / Price Books

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loResp

* 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')
loHttp = 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": [
*     {
*       "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"
*     }
*   ]
* }

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("data[0].Owner.id","{{user-id}}")
loJson.UpdateBool("data[0].Active",1)
loJson.UpdateInt("data[0].Pricing_Details[0].to_range",5)
loJson.UpdateInt("data[0].Pricing_Details[0].discount",0)
loJson.UpdateInt("data[0].Pricing_Details[0].from_range",1)
loJson.UpdateInt("data[0].Pricing_Details[1].to_range",11)
loJson.UpdateInt("data[0].Pricing_Details[1].discount",1)
loJson.UpdateInt("data[0].Pricing_Details[1].from_range",6)
loJson.UpdateInt("data[0].Pricing_Details[2].to_range",17)
loJson.UpdateInt("data[0].Pricing_Details[2].discount",2)
loJson.UpdateInt("data[0].Pricing_Details[2].from_range",12)
loJson.UpdateInt("data[0].Pricing_Details[3].to_range",23)
loJson.UpdateInt("data[0].Pricing_Details[3].discount",3)
loJson.UpdateInt("data[0].Pricing_Details[3].from_range",18)
loJson.UpdateInt("data[0].Pricing_Details[4].to_range",29)
loJson.UpdateInt("data[0].Pricing_Details[4].discount",4)
loJson.UpdateInt("data[0].Pricing_Details[4].from_range",24)
loJson.UpdateString("data[0].Pricing_Model","Differential")
loJson.UpdateString("data[0].Description","Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.")
loJson.UpdateString("data[0].Price_Book_Name","Price_Book_Name")

loHttp.SetRequestHeader("Authorization","{{authorization-token}}")
loHttp.SetRequestHeader("Content-Type","application/json")

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbRequestBody = CreateObject('Chilkat.StringBuilder')
loJson.EmitSb(loSbRequestBody)

loResp = loHttp.PTextSb("PUT","https://domain.com/crm/v2/Price_Books/{{record-id}}",loSbRequestBody,"utf-8","application/json",0,0)
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJson
    RELEASE loSbRequestBody
    CANCEL
ENDIF

? STR(loResp.StatusCode)
? loResp.BodyStr
RELEASE loResp

RELEASE loHttp
RELEASE loJson
RELEASE loSbRequestBody

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/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/Price_Books/{{record-id}}",
      "host": [
        "{{api-domain}}"
      ],
      "path": [
        "crm",
        "v2",
        "Price_Books",
        "{{record-id}}"
      ]
    },
    "description": "To update existing entities in the module."
  },
  "response": [
  ]
}