Chilkat Online Tools

PowerBuilder / Zoho CRM REST APIs / Price Books

Back to Collection Items

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Json
oleobject loo_Resp

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

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// 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"
//     }
//   ]
// }

loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

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

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

loo_Resp = loo_Http.PostJson3("https://domain.com/crm/v2.1/Price_Books","application/json",loo_Json)
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_Json
    return
end if

Write-Debug string(loo_Resp.StatusCode)
Write-Debug loo_Resp.BodyStr
destroy loo_Resp


destroy loo_Http
destroy loo_Json

Curl Command

curl -X POST
	-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

Postman Collection Item JSON

{
  "name": "Price Books",
  "request": {
    "method": "POST",
    "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",
      "host": [
        "{{api-domain}}"
      ],
      "path": [
        "crm",
        "v2.1",
        "Price_Books"
      ]
    },
    "description": "To add new entities to a module."
  },
  "response": [
  ]
}