Chilkat Online Tools

Foxpro / Zoho CRM REST APIs / Products

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loJson
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}}"
*       },
*       "Handler": {
*         "id": "{{user-id}}"
*       },
*       "Vendor_Name": {
*         "id": "{{vendor-id}}"
*       },
*       "Product_Category": "Software",
*       "Qty_in_Demand": 1237.89,
*       "Description": "Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.",
*       "Commission_Rate": 1237.67,
*       "Product_Name": "Product_Name",
*       "Quantity_In_Stock": 12792,
*       "Sales_Start_Date": "2018-01-25",
*       "Tax": [
*         "Sales Tax"
*       ],
*       "Support_Start_Date": "2018-01-25",
*       "Product_Active": true,
*       "Usage_Unit": "Caton",
*       "Product_Code": "Product_Code",
*       "Qty_Ordered": 1237.89,
*       "Manufacturer": "LexPon Inc.",
*       "Qty_in_Stock": 1237.89,
*       "Support_Expiry_Date": "2018-01-25",
*       "Sales_End_Date": "2018-01-25",
*       "Unit_Price": 1237.67,
*       "Taxable": true,
*       "Reorder_Level": 1237.89
*     }
*   ]
* }

* 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.UpdateString("data[0].Handler.id","{{user-id}}")
loJson.UpdateString("data[0].Vendor_Name.id","{{vendor-id}}")
loJson.UpdateString("data[0].Product_Category","Software")
loJson.UpdateNumber("data[0].Qty_in_Demand","1237.89")
loJson.UpdateString("data[0].Description","Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.")
loJson.UpdateNumber("data[0].Commission_Rate","1237.67")
loJson.UpdateString("data[0].Product_Name","Product_Name")
loJson.UpdateInt("data[0].Quantity_In_Stock",12792)
loJson.UpdateString("data[0].Sales_Start_Date","2018-01-25")
loJson.UpdateString("data[0].Tax[0]","Sales Tax")
loJson.UpdateString("data[0].Support_Start_Date","2018-01-25")
loJson.UpdateBool("data[0].Product_Active",1)
loJson.UpdateString("data[0].Usage_Unit","Caton")
loJson.UpdateString("data[0].Product_Code","Product_Code")
loJson.UpdateNumber("data[0].Qty_Ordered","1237.89")
loJson.UpdateString("data[0].Manufacturer","LexPon Inc.")
loJson.UpdateNumber("data[0].Qty_in_Stock","1237.89")
loJson.UpdateString("data[0].Support_Expiry_Date","2018-01-25")
loJson.UpdateString("data[0].Sales_End_Date","2018-01-25")
loJson.UpdateNumber("data[0].Unit_Price","1237.67")
loJson.UpdateBool("data[0].Taxable",1)
loJson.UpdateNumber("data[0].Reorder_Level","1237.89")

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

loResp = loHttp.PostJson3("https://domain.com/crm/v2.1/Products","application/json",loJson)
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJson
    CANCEL
ENDIF

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

RELEASE loHttp
RELEASE loJson

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}}"
      },
      "Handler": {
        "id": "{{user-id}}"
      },
      "Vendor_Name": {
        "id": "{{vendor-id}}"
      },
      "Product_Category": "Software",
      "Qty_in_Demand": 1237.89,
      "Description": "Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.",
      "Commission_Rate": 1237.67,
      "Product_Name": "Product_Name",
      "Quantity_In_Stock": 12792,
      "Sales_Start_Date": "2018-01-25",
      "Tax": [
        "Sales Tax"
      ],
      "Support_Start_Date": "2018-01-25",
      "Product_Active": true,
      "Usage_Unit": "Caton",
      "Product_Code": "Product_Code",
      "Qty_Ordered": 1237.89,
      "Manufacturer": "LexPon Inc.",
      "Qty_in_Stock": 1237.89,
      "Support_Expiry_Date": "2018-01-25",
      "Sales_End_Date": "2018-01-25",
      "Unit_Price": 1237.67,
      "Taxable": true,
      "Reorder_Level": 1237.89
    }
  ]
}'
https://domain.com/crm/v2.1/Products

Postman Collection Item JSON

{
  "name": "Products",
  "request": {
    "method": "POST",
    "header": [
      {
        "key": "Authorization",
        "value": "{{authorization-token}}"
      },
      {
        "key": "Content-Type",
        "value": "application/json"
      }
    ],
    "body": {
      "mode": "raw",
      "raw": "{\n  \"data\": [\n    {\n      \"Owner\": {\n        \"id\": \"{{user-id}}\"\n      },\n      \"Handler\": {\n        \"id\": \"{{user-id}}\"\n      },\n      \"Vendor_Name\": {\n        \"id\": \"{{vendor-id}}\"\n      },\n      \"Product_Category\": \"Software\",\n      \"Qty_in_Demand\": 1237.89,\n      \"Description\": \"Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.\",\n      \"Commission_Rate\": 1237.67,\n      \"Product_Name\": \"Product_Name\",\n      \"Quantity_In_Stock\": 12792,\n      \"Sales_Start_Date\": \"2018-01-25\",\n      \"Tax\": [\n        \"Sales Tax\"\n      ],\n      \"Support_Start_Date\": \"2018-01-25\",\n      \"Product_Active\": true,\n      \"Usage_Unit\": \"Caton\",\n      \"Product_Code\": \"Product_Code\",\n      \"Qty_Ordered\": 1237.89,\n      \"Manufacturer\": \"LexPon Inc.\",\n      \"Qty_in_Stock\": 1237.89,\n      \"Support_Expiry_Date\": \"2018-01-25\",\n      \"Sales_End_Date\": \"2018-01-25\",\n      \"Unit_Price\": 1237.67,\n      \"Taxable\": true,\n      \"Reorder_Level\": 1237.89\n    }\n  ]\n}"
    },
    "url": {
      "raw": "{{api-domain}}/crm/v2.1/Products",
      "host": [
        "{{api-domain}}"
      ],
      "path": [
        "crm",
        "v2.1",
        "Products"
      ]
    },
    "description": "To add new entities to a module."
  },
  "response": [
  ]
}