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
li_rc = loo_Http.ConnectToNewObject("Chilkat_9_5_0.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}}"
// },
// "Parent_Account": {
// "id": "{{parent-account-id}}"
// },
// "Ownership": "Private",
// "Description": "Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.",
// "Account_Type": "Competitor",
// "Rating": "Active",
// "SIC_Code": 12792,
// "Shipping_State": "Shipping_State",
// "Website": "crm.zoho.com",
// "Employees": 12792,
// "Industry": "Data/Telecom OEM",
// "Account_Site": "Account_Site",
// "Phone": "988844559",
// "Billing_Country": "Billing_Country",
// "Account_Name": "Account_Name",
// "Account_Number": "1245681",
// "Ticker_Symbol": "Ticker_Symbol",
// "Billing_Street": "Billing_Street",
// "Billing_Code": "Billing_Code",
// "Shipping_City": "Shipping_City",
// "Shipping_Country": "Shipping_Country",
// "Shipping_Code": "Shipping_Code",
// "Billing_City": "Billing_City",
// "Billing_State": "Billing_State",
// "Fax": "Fax",
// "Annual_Revenue": 127.67,
// "Shipping_Street": "Shipping_Street"
// }
// ]
// }
loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
loo_Json.UpdateString("data[0].Owner.id","{{user-id}}")
loo_Json.UpdateString("data[0].Parent_Account.id","{{parent-account-id}}")
loo_Json.UpdateString("data[0].Ownership","Private")
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].Account_Type","Competitor")
loo_Json.UpdateString("data[0].Rating","Active")
loo_Json.UpdateInt("data[0].SIC_Code",12792)
loo_Json.UpdateString("data[0].Shipping_State","Shipping_State")
loo_Json.UpdateString("data[0].Website","crm.zoho.com")
loo_Json.UpdateInt("data[0].Employees",12792)
loo_Json.UpdateString("data[0].Industry","Data/Telecom OEM")
loo_Json.UpdateString("data[0].Account_Site","Account_Site")
loo_Json.UpdateString("data[0].Phone","988844559")
loo_Json.UpdateString("data[0].Billing_Country","Billing_Country")
loo_Json.UpdateString("data[0].Account_Name","Account_Name")
loo_Json.UpdateString("data[0].Account_Number","1245681")
loo_Json.UpdateString("data[0].Ticker_Symbol","Ticker_Symbol")
loo_Json.UpdateString("data[0].Billing_Street","Billing_Street")
loo_Json.UpdateString("data[0].Billing_Code","Billing_Code")
loo_Json.UpdateString("data[0].Shipping_City","Shipping_City")
loo_Json.UpdateString("data[0].Shipping_Country","Shipping_Country")
loo_Json.UpdateString("data[0].Shipping_Code","Shipping_Code")
loo_Json.UpdateString("data[0].Billing_City","Billing_City")
loo_Json.UpdateString("data[0].Billing_State","Billing_State")
loo_Json.UpdateString("data[0].Fax","Fax")
loo_Json.UpdateNumber("data[0].Annual_Revenue","127.67")
loo_Json.UpdateString("data[0].Shipping_Street","Shipping_Street")
loo_Http.SetRequestHeader("Authorization","{{authorization-token}}")
loo_Http.SetRequestHeader("Content-Type","application/json")
loo_Resp = loo_Http.PostJson3("https://domain.com/crm/v2/Accounts/upsert","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}}"
},
"Parent_Account": {
"id": "{{parent-account-id}}"
},
"Ownership": "Private",
"Description": "Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.",
"Account_Type": "Competitor",
"Rating": "Active",
"SIC_Code": 12792,
"Shipping_State": "Shipping_State",
"Website": "crm.zoho.com",
"Employees": 12792,
"Industry": "Data/Telecom OEM",
"Account_Site": "Account_Site",
"Phone": "988844559",
"Billing_Country": "Billing_Country",
"Account_Name": "Account_Name",
"Account_Number": "1245681",
"Ticker_Symbol": "Ticker_Symbol",
"Billing_Street": "Billing_Street",
"Billing_Code": "Billing_Code",
"Shipping_City": "Shipping_City",
"Shipping_Country": "Shipping_Country",
"Shipping_Code": "Shipping_Code",
"Billing_City": "Billing_City",
"Billing_State": "Billing_State",
"Fax": "Fax",
"Annual_Revenue": 127.67,
"Shipping_Street": "Shipping_Street"
}
]
}'
https://domain.com/crm/v2/Accounts/upsert
Postman Collection Item JSON
{
"name": "Accounts",
"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\"Parent_Account\": {\n\t\t\t\t\"id\": \"{{parent-account-id}}\"\n\t\t\t},\n\t\t\t\"Ownership\": \"Private\",\n\t\t\t\"Description\": \"Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.\",\n\t\t\t\"Account_Type\": \"Competitor\",\n\t\t\t\"Rating\": \"Active\",\n\t\t\t\"SIC_Code\": 12792,\n\t\t\t\"Shipping_State\": \"Shipping_State\",\n\t\t\t\"Website\": \"crm.zoho.com\",\n\t\t\t\"Employees\": 12792,\n\t\t\t\"Industry\": \"Data/Telecom OEM\",\n\t\t\t\"Account_Site\": \"Account_Site\",\n\t\t\t\"Phone\": \"988844559\",\n\t\t\t\"Billing_Country\": \"Billing_Country\",\n\t\t\t\"Account_Name\": \"Account_Name\",\n\t\t\t\"Account_Number\": \"1245681\",\n\t\t\t\"Ticker_Symbol\": \"Ticker_Symbol\",\n\t\t\t\"Billing_Street\": \"Billing_Street\",\n\t\t\t\"Billing_Code\": \"Billing_Code\",\n\t\t\t\"Shipping_City\": \"Shipping_City\",\n\t\t\t\"Shipping_Country\": \"Shipping_Country\",\n\t\t\t\"Shipping_Code\": \"Shipping_Code\",\n\t\t\t\"Billing_City\": \"Billing_City\",\n\t\t\t\"Billing_State\": \"Billing_State\",\n\t\t\t\"Fax\": \"Fax\",\n\t\t\t\"Annual_Revenue\": 127.67,\n\t\t\t\"Shipping_Street\": \"Shipping_Street\"\n\t\t}\n\t]\n}"
},
"url": {
"raw": "{{api-domain}}/crm/v2/Accounts/upsert",
"host": [
"{{api-domain}}"
],
"path": [
"crm",
"v2",
"Accounts",
"upsert"
]
},
"description": "To upsert Account records."
},
"response": [
]
}
