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 Chilkat.Http
Dim success As Boolean
' 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"
' }
' ]
' }
Dim json As New Chilkat.JsonObject
json.UpdateString("data[0].Owner.id","{{user-id}}")
json.UpdateString("data[0].Parent_Account.id","{{parent-account-id}}")
json.UpdateString("data[0].Ownership","Private")
json.UpdateString("data[0].Description","Design your own layouts that align your business processes precisely. Assign them to profiles appropriately.")
json.UpdateString("data[0].Account_Type","Competitor")
json.UpdateString("data[0].Rating","Active")
json.UpdateInt("data[0].SIC_Code",12792)
json.UpdateString("data[0].Shipping_State","Shipping_State")
json.UpdateString("data[0].Website","crm.zoho.com")
json.UpdateInt("data[0].Employees",12792)
json.UpdateString("data[0].Industry","Data/Telecom OEM")
json.UpdateString("data[0].Account_Site","Account_Site")
json.UpdateString("data[0].Phone","988844559")
json.UpdateString("data[0].Billing_Country","Billing_Country")
json.UpdateString("data[0].Account_Name","Account_Name")
json.UpdateString("data[0].Account_Number","1245681")
json.UpdateString("data[0].Ticker_Symbol","Ticker_Symbol")
json.UpdateString("data[0].Billing_Street","Billing_Street")
json.UpdateString("data[0].Billing_Code","Billing_Code")
json.UpdateString("data[0].Shipping_City","Shipping_City")
json.UpdateString("data[0].Shipping_Country","Shipping_Country")
json.UpdateString("data[0].Shipping_Code","Shipping_Code")
json.UpdateString("data[0].Billing_City","Billing_City")
json.UpdateString("data[0].Billing_State","Billing_State")
json.UpdateString("data[0].Fax","Fax")
json.UpdateNumber("data[0].Annual_Revenue","127.67")
json.UpdateString("data[0].Shipping_Street","Shipping_Street")
http.SetRequestHeader("Authorization","{{authorization-token}}")
http.SetRequestHeader("Content-Type","application/json")
Dim resp As Chilkat.HttpResponse = http.PostJson3("https://domain.com/crm/v2/Accounts/upsert","application/json",json)
If (http.LastMethodSuccess = False) Then
Debug.WriteLine(http.LastErrorText)
Exit Sub
End If
Debug.WriteLine(resp.StatusCode)
Debug.WriteLine(resp.BodyStr)
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": [
]
}
