Chilkat Online Tools

Foxpro / Salesforce Platform APIs / Create Order (Evergreen & Termed)

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.

* {
*   "allOrNone": true,
*   "compositeRequest": [
*     {
*       "method": "POST",
*       "url": "/services/data/v{{version}}/sobjects/Order",
*       "referenceId": "refOrder",
*       "body": {
*         "AccountId": "{{defaultAccount}}",
*         "EffectiveDate": "2022-01-01",
*         "Pricebook2Id": "{{standardPricebook}}",
*         "BillToContactId": "{{defaultBillToContact}}",
*         "Status": "Draft"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v{{version}}/sobjects/AppUsageAssignment",
*       "referenceId": "refAppTag",
*       "body": {
*         "AppUsageType": "SubscriptionManagement",
*         "RecordId": "@{refOrder.id}"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v{{version}}/sobjects/OrderAction",
*       "referenceId": "refOrderAction",
*       "body": {
*         "OrderId": "@{refOrder.id}",
*         "Type": "New Sale"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v{{version}}/sobjects/OrderItem",
*       "referenceId": "Item_1_Evergreen",
*       "body": {
*         "OrderId": "@{refOrder.id}",
*         "OrderActionId": "@{refOrderAction.id}",
*         "PricebookEntryId": "{{VirtualRouterEvergrnPBE}}",
*         "Quantity": 2.0,
*         "UnitPrice": 25.0,
*         "NetUnitPrice": 25.0,
*         "TotalLineAmount": 50.0,
*         "PeriodBoundary": "Anniversary",
*         "BillingFrequency2": "Monthly",
*         "ServiceDate": "2022-02-01",
*         "TaxTreatmentId": "{{defaultTaxTreatment}}"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v{{version}}/sobjects/OrderItem",
*       "referenceId": "Item_2_termed",
*       "body": {
*         "OrderId": "@{refOrder.id}",
*         "OrderActionId": "@{refOrderAction.id}",
*         "PricebookEntryId": "{{VirtualRouterTermedPBE}}",
*         "Quantity": 10.0,
*         "UnitPrice": 50.0,
*         "NetUnitPrice": 50.0,
*         "TotalLineAmount": 500.0,
*         "PeriodBoundary": "Anniversary",
*         "BillingFrequency2": "Monthly",
*         "PricingTermCount": 12.0,
*         "ServiceDate": "2022-02-01",
*         "EndDate": "2023-01-01",
*         "TaxTreatmentId": "{{defaultTaxTreatment}}"
*       }
*     }
*   ]
* }

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateBool("allOrNone",1)
loJson.UpdateString("compositeRequest[0].method","POST")
loJson.UpdateString("compositeRequest[0].url","/services/data/v{{version}}/sobjects/Order")
loJson.UpdateString("compositeRequest[0].referenceId","refOrder")
loJson.UpdateString("compositeRequest[0].body.AccountId","{{defaultAccount}}")
loJson.UpdateString("compositeRequest[0].body.EffectiveDate","2022-01-01")
loJson.UpdateString("compositeRequest[0].body.Pricebook2Id","{{standardPricebook}}")
loJson.UpdateString("compositeRequest[0].body.BillToContactId","{{defaultBillToContact}}")
loJson.UpdateString("compositeRequest[0].body.Status","Draft")
loJson.UpdateString("compositeRequest[1].method","POST")
loJson.UpdateString("compositeRequest[1].url","/services/data/v{{version}}/sobjects/AppUsageAssignment")
loJson.UpdateString("compositeRequest[1].referenceId","refAppTag")
loJson.UpdateString("compositeRequest[1].body.AppUsageType","SubscriptionManagement")
loJson.UpdateString("compositeRequest[1].body.RecordId","@{refOrder.id}")
loJson.UpdateString("compositeRequest[2].method","POST")
loJson.UpdateString("compositeRequest[2].url","/services/data/v{{version}}/sobjects/OrderAction")
loJson.UpdateString("compositeRequest[2].referenceId","refOrderAction")
loJson.UpdateString("compositeRequest[2].body.OrderId","@{refOrder.id}")
loJson.UpdateString("compositeRequest[2].body.Type","New Sale")
loJson.UpdateString("compositeRequest[3].method","POST")
loJson.UpdateString("compositeRequest[3].url","/services/data/v{{version}}/sobjects/OrderItem")
loJson.UpdateString("compositeRequest[3].referenceId","Item_1_Evergreen")
loJson.UpdateString("compositeRequest[3].body.OrderId","@{refOrder.id}")
loJson.UpdateString("compositeRequest[3].body.OrderActionId","@{refOrderAction.id}")
loJson.UpdateString("compositeRequest[3].body.PricebookEntryId","{{VirtualRouterEvergrnPBE}}")
loJson.UpdateNumber("compositeRequest[3].body.Quantity","2.0")
loJson.UpdateNumber("compositeRequest[3].body.UnitPrice","25.0")
loJson.UpdateNumber("compositeRequest[3].body.NetUnitPrice","25.0")
loJson.UpdateNumber("compositeRequest[3].body.TotalLineAmount","50.0")
loJson.UpdateString("compositeRequest[3].body.PeriodBoundary","Anniversary")
loJson.UpdateString("compositeRequest[3].body.BillingFrequency2","Monthly")
loJson.UpdateString("compositeRequest[3].body.ServiceDate","2022-02-01")
loJson.UpdateString("compositeRequest[3].body.TaxTreatmentId","{{defaultTaxTreatment}}")
loJson.UpdateString("compositeRequest[4].method","POST")
loJson.UpdateString("compositeRequest[4].url","/services/data/v{{version}}/sobjects/OrderItem")
loJson.UpdateString("compositeRequest[4].referenceId","Item_2_termed")
loJson.UpdateString("compositeRequest[4].body.OrderId","@{refOrder.id}")
loJson.UpdateString("compositeRequest[4].body.OrderActionId","@{refOrderAction.id}")
loJson.UpdateString("compositeRequest[4].body.PricebookEntryId","{{VirtualRouterTermedPBE}}")
loJson.UpdateNumber("compositeRequest[4].body.Quantity","10.0")
loJson.UpdateNumber("compositeRequest[4].body.UnitPrice","50.0")
loJson.UpdateNumber("compositeRequest[4].body.NetUnitPrice","50.0")
loJson.UpdateNumber("compositeRequest[4].body.TotalLineAmount","500.0")
loJson.UpdateString("compositeRequest[4].body.PeriodBoundary","Anniversary")
loJson.UpdateString("compositeRequest[4].body.BillingFrequency2","Monthly")
loJson.UpdateNumber("compositeRequest[4].body.PricingTermCount","12.0")
loJson.UpdateString("compositeRequest[4].body.ServiceDate","2022-02-01")
loJson.UpdateString("compositeRequest[4].body.EndDate","2023-01-01")
loJson.UpdateString("compositeRequest[4].body.TaxTreatmentId","{{defaultTaxTreatment}}")

* Adds the "Authorization: Bearer <access_token>" header.
loHttp.AuthToken = "<access_token>"

loResp = loHttp.PostJson3("https://domain.com/services/data/v{{version}}/composite","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>"
	-d '{
    "allOrNone": true,
    "compositeRequest": [
        {
            "method": "POST",
            "url": "/services/data/v{{version}}/sobjects/Order",
            "referenceId": "refOrder",
            "body": {
                "AccountId": "{{defaultAccount}}",
                "EffectiveDate": "2022-01-01",
                "Pricebook2Id": "{{standardPricebook}}",
                "BillToContactId": "{{defaultBillToContact}}",
                "Status": "Draft"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v{{version}}/sobjects/AppUsageAssignment",
            "referenceId": "refAppTag",
            "body": {
                "AppUsageType": "SubscriptionManagement",
                "RecordId": "@{refOrder.id}"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v{{version}}/sobjects/OrderAction",
            "referenceId": "refOrderAction",
            "body": {
                "OrderId": "@{refOrder.id}",
                "Type": "New Sale"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v{{version}}/sobjects/OrderItem",
            "referenceId": "Item_1_Evergreen",
            "body": {
                "OrderId": "@{refOrder.id}",
                "OrderActionId": "@{refOrderAction.id}",
                "PricebookEntryId": "{{VirtualRouterEvergrnPBE}}",
                "Quantity": 2.0,
                "UnitPrice": 25.0,
                "NetUnitPrice": 25.0,
                "TotalLineAmount": 50.0,
                "PeriodBoundary": "Anniversary",
                "BillingFrequency2": "Monthly",                
                "ServiceDate": "2022-02-01",
                "TaxTreatmentId": "{{defaultTaxTreatment}}"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v{{version}}/sobjects/OrderItem",
            "referenceId": "Item_2_termed",
            "body": {
                "OrderId": "@{refOrder.id}",
                "OrderActionId": "@{refOrderAction.id}",
                "PricebookEntryId": "{{VirtualRouterTermedPBE}}",
                "Quantity": 10.0,
                "UnitPrice": 50.0,
                "NetUnitPrice": 50.0,
                "TotalLineAmount": 500.0,
                "PeriodBoundary": "Anniversary",
                "BillingFrequency2": "Monthly",
                "PricingTermCount": 12.0,                
                "ServiceDate": "2022-02-01",
                "EndDate": "2023-01-01",
                "TaxTreatmentId": "{{defaultTaxTreatment}}"
            }
        }        
    ]
}'
https://domain.com/services/data/v{{version}}/composite

Postman Collection Item JSON

{
  "name": "Create Order (Evergreen & Termed)",
  "request": {
    "method": "POST",
    "header": [
    ],
    "body": {
      "mode": "raw",
      "raw": "{\n    \"allOrNone\": true,\n    \"compositeRequest\": [\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v{{version}}/sobjects/Order\",\n            \"referenceId\": \"refOrder\",\n            \"body\": {\n                \"AccountId\": \"{{defaultAccount}}\",\n                \"EffectiveDate\": \"2022-01-01\",\n                \"Pricebook2Id\": \"{{standardPricebook}}\",\n                \"BillToContactId\": \"{{defaultBillToContact}}\",\n                \"Status\": \"Draft\"\n            }\n        },\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v{{version}}/sobjects/AppUsageAssignment\",\n            \"referenceId\": \"refAppTag\",\n            \"body\": {\n                \"AppUsageType\": \"SubscriptionManagement\",\n                \"RecordId\": \"@{refOrder.id}\"\n            }\n        },\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v{{version}}/sobjects/OrderAction\",\n            \"referenceId\": \"refOrderAction\",\n            \"body\": {\n                \"OrderId\": \"@{refOrder.id}\",\n                \"Type\": \"New Sale\"\n            }\n        },\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v{{version}}/sobjects/OrderItem\",\n            \"referenceId\": \"Item_1_Evergreen\",\n            \"body\": {\n                \"OrderId\": \"@{refOrder.id}\",\n                \"OrderActionId\": \"@{refOrderAction.id}\",\n                \"PricebookEntryId\": \"{{VirtualRouterEvergrnPBE}}\",\n                \"Quantity\": 2.0,\n                \"UnitPrice\": 25.0,\n                \"NetUnitPrice\": 25.0,\n                \"TotalLineAmount\": 50.0,\n                \"PeriodBoundary\": \"Anniversary\",\n                \"BillingFrequency2\": \"Monthly\",                \n                \"ServiceDate\": \"2022-02-01\",\n                \"TaxTreatmentId\": \"{{defaultTaxTreatment}}\"\n            }\n        },\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v{{version}}/sobjects/OrderItem\",\n            \"referenceId\": \"Item_2_termed\",\n            \"body\": {\n                \"OrderId\": \"@{refOrder.id}\",\n                \"OrderActionId\": \"@{refOrderAction.id}\",\n                \"PricebookEntryId\": \"{{VirtualRouterTermedPBE}}\",\n                \"Quantity\": 10.0,\n                \"UnitPrice\": 50.0,\n                \"NetUnitPrice\": 50.0,\n                \"TotalLineAmount\": 500.0,\n                \"PeriodBoundary\": \"Anniversary\",\n                \"BillingFrequency2\": \"Monthly\",\n                \"PricingTermCount\": 12.0,                \n                \"ServiceDate\": \"2022-02-01\",\n                \"EndDate\": \"2023-01-01\",\n                \"TaxTreatmentId\": \"{{defaultTaxTreatment}}\"\n            }\n        }        \n    ]\n}",
      "options": {
        "raw": {
          "language": "json"
        }
      }
    },
    "url": {
      "raw": "{{_endpoint}}/services/data/v{{version}}/composite",
      "host": [
        "{{_endpoint}}"
      ],
      "path": [
        "services",
        "data",
        "v{{version}}",
        "composite"
      ]
    },
    "description": "Creates a Subscription Management order with two order items. One order item is sold on a monthly termed subscription, and the other order item is sold as an evergreen subscription."
  },
  "response": [
  ]
}