Chilkat Online Tools

Foxpro / Salesforce Platform APIs / Create Order With Bundle

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/v57.0/sobjects/Order",
*       "referenceId": "refOrder",
*       "body": {
*         "AccountId": "{{defaultAccount}}",
*         "EffectiveDate": "2023-01-01",
*         "Pricebook2Id": "{{standardPricebook}}",
*         "BillToContactId": "{{defaultBillToContact}}",
*         "Status": "Draft"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v57.0/sobjects/AppUsageAssignment",
*       "referenceId": "refAppTag",
*       "body": {
*         "AppUsageType": "SubscriptionManagement",
*         "RecordId": "@{refOrder.id}"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v57.0/sobjects/OrderAction",
*       "referenceId": "refOrderAction",
*       "body": {
*         "OrderId": "@{refOrder.id}",
*         "Type": "New Sale"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v57.0/sobjects/OrderItem",
*       "referenceId": "refWorkAnywhereBundle",
*       "body": {
*         "OrderId": "@{refOrder.id}",
*         "OrderActionId": "@{refOrderAction.id}",
*         "PricebookEntryId": "{{WorkAnywhereBundlePBE}}",
*         "ServiceDate": "2023-01-01",
*         "Quantity": 1,
*         "UnitPrice": 10000,
*         "NetUnitPrice": 10000,
*         "TotalLineAmount": 10000,
*         "PeriodBoundary": "AlignToCalendar",
*         "BillingFrequency2": "Monthly"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v57.0/sobjects/OrderItem",
*       "referenceId": "refVirtualRouter",
*       "body": {
*         "OrderId": "@{refOrder.id}",
*         "OrderActionId": "@{refOrderAction.id}",
*         "PricebookEntryId": "{{VirtualRouterEvergrnPBE}}",
*         "ServiceDate": "2023-01-01",
*         "Quantity": 100,
*         "UnitPrice": 0,
*         "NetUnitPrice": 0,
*         "TotalLineAmount": 0,
*         "PeriodBoundary": "AlignToCalendar",
*         "BillingFrequency2": "Monthly"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v57.0/sobjects/OrderItem",
*       "referenceId": "refBronzeSLA",
*       "body": {
*         "OrderId": "@{refOrder.id}",
*         "OrderActionId": "@{refOrderAction.id}",
*         "PricebookEntryId": "{{SLABronzeEvergrnMonthPBE}}",
*         "ServiceDate": "2023-01-01",
*         "Quantity": 3,
*         "UnitPrice": 0,
*         "NetUnitPrice": 0,
*         "TotalLineAmount": 0,
*         "PeriodBoundary": "AlignToCalendar",
*         "BillingFrequency2": "Monthly"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v57.0/sobjects/OrderItemRelationship",
*       "referenceId": "refOrderItemRelationship1",
*       "body": {
*         "ProductRelationshipTypeId": "{{BundleProductRelationshipType}}",
*         "MainOrderItemId": "@{refWorkAnywhereBundle.id}",
*         "AssociatedOrderItemId": "@{refVirtualRouter.id}",
*         "AssociatedOrderItemPricing": "IncludedInBundlePrice",
*         "AssociatedQuantScaleMethod": "Proportional"
*       }
*     },
*     {
*       "method": "POST",
*       "url": "/services/data/v57.0/sobjects/OrderItemRelationship",
*       "referenceId": "refOrderItemRelationship2",
*       "body": {
*         "ProductRelationshipTypeId": "{{BundleProductRelationshipType}}",
*         "MainOrderItemId": "@{refWorkAnywhereBundle.id}",
*         "AssociatedOrderItemId": "@{refBronzeSLA.id}",
*         "AssociatedOrderItemPricing": "IncludedInBundlePrice",
*         "AssociatedQuantScaleMethod": "Constant"
*       }
*     }
*   ]
* }

* 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/v57.0/sobjects/Order")
loJson.UpdateString("compositeRequest[0].referenceId","refOrder")
loJson.UpdateString("compositeRequest[0].body.AccountId","{{defaultAccount}}")
loJson.UpdateString("compositeRequest[0].body.EffectiveDate","2023-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/v57.0/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/v57.0/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/v57.0/sobjects/OrderItem")
loJson.UpdateString("compositeRequest[3].referenceId","refWorkAnywhereBundle")
loJson.UpdateString("compositeRequest[3].body.OrderId","@{refOrder.id}")
loJson.UpdateString("compositeRequest[3].body.OrderActionId","@{refOrderAction.id}")
loJson.UpdateString("compositeRequest[3].body.PricebookEntryId","{{WorkAnywhereBundlePBE}}")
loJson.UpdateString("compositeRequest[3].body.ServiceDate","2023-01-01")
loJson.UpdateInt("compositeRequest[3].body.Quantity",1)
loJson.UpdateInt("compositeRequest[3].body.UnitPrice",10000)
loJson.UpdateInt("compositeRequest[3].body.NetUnitPrice",10000)
loJson.UpdateInt("compositeRequest[3].body.TotalLineAmount",10000)
loJson.UpdateString("compositeRequest[3].body.PeriodBoundary","AlignToCalendar")
loJson.UpdateString("compositeRequest[3].body.BillingFrequency2","Monthly")
loJson.UpdateString("compositeRequest[4].method","POST")
loJson.UpdateString("compositeRequest[4].url","/services/data/v57.0/sobjects/OrderItem")
loJson.UpdateString("compositeRequest[4].referenceId","refVirtualRouter")
loJson.UpdateString("compositeRequest[4].body.OrderId","@{refOrder.id}")
loJson.UpdateString("compositeRequest[4].body.OrderActionId","@{refOrderAction.id}")
loJson.UpdateString("compositeRequest[4].body.PricebookEntryId","{{VirtualRouterEvergrnPBE}}")
loJson.UpdateString("compositeRequest[4].body.ServiceDate","2023-01-01")
loJson.UpdateInt("compositeRequest[4].body.Quantity",100)
loJson.UpdateInt("compositeRequest[4].body.UnitPrice",0)
loJson.UpdateInt("compositeRequest[4].body.NetUnitPrice",0)
loJson.UpdateInt("compositeRequest[4].body.TotalLineAmount",0)
loJson.UpdateString("compositeRequest[4].body.PeriodBoundary","AlignToCalendar")
loJson.UpdateString("compositeRequest[4].body.BillingFrequency2","Monthly")
loJson.UpdateString("compositeRequest[5].method","POST")
loJson.UpdateString("compositeRequest[5].url","/services/data/v57.0/sobjects/OrderItem")
loJson.UpdateString("compositeRequest[5].referenceId","refBronzeSLA")
loJson.UpdateString("compositeRequest[5].body.OrderId","@{refOrder.id}")
loJson.UpdateString("compositeRequest[5].body.OrderActionId","@{refOrderAction.id}")
loJson.UpdateString("compositeRequest[5].body.PricebookEntryId","{{SLABronzeEvergrnMonthPBE}}")
loJson.UpdateString("compositeRequest[5].body.ServiceDate","2023-01-01")
loJson.UpdateInt("compositeRequest[5].body.Quantity",3)
loJson.UpdateInt("compositeRequest[5].body.UnitPrice",0)
loJson.UpdateInt("compositeRequest[5].body.NetUnitPrice",0)
loJson.UpdateInt("compositeRequest[5].body.TotalLineAmount",0)
loJson.UpdateString("compositeRequest[5].body.PeriodBoundary","AlignToCalendar")
loJson.UpdateString("compositeRequest[5].body.BillingFrequency2","Monthly")
loJson.UpdateString("compositeRequest[6].method","POST")
loJson.UpdateString("compositeRequest[6].url","/services/data/v57.0/sobjects/OrderItemRelationship")
loJson.UpdateString("compositeRequest[6].referenceId","refOrderItemRelationship1")
loJson.UpdateString("compositeRequest[6].body.ProductRelationshipTypeId","{{BundleProductRelationshipType}}")
loJson.UpdateString("compositeRequest[6].body.MainOrderItemId","@{refWorkAnywhereBundle.id}")
loJson.UpdateString("compositeRequest[6].body.AssociatedOrderItemId","@{refVirtualRouter.id}")
loJson.UpdateString("compositeRequest[6].body.AssociatedOrderItemPricing","IncludedInBundlePrice")
loJson.UpdateString("compositeRequest[6].body.AssociatedQuantScaleMethod","Proportional")
loJson.UpdateString("compositeRequest[7].method","POST")
loJson.UpdateString("compositeRequest[7].url","/services/data/v57.0/sobjects/OrderItemRelationship")
loJson.UpdateString("compositeRequest[7].referenceId","refOrderItemRelationship2")
loJson.UpdateString("compositeRequest[7].body.ProductRelationshipTypeId","{{BundleProductRelationshipType}}")
loJson.UpdateString("compositeRequest[7].body.MainOrderItemId","@{refWorkAnywhereBundle.id}")
loJson.UpdateString("compositeRequest[7].body.AssociatedOrderItemId","@{refBronzeSLA.id}")
loJson.UpdateString("compositeRequest[7].body.AssociatedOrderItemPricing","IncludedInBundlePrice")
loJson.UpdateString("compositeRequest[7].body.AssociatedQuantScaleMethod","Constant")

* 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/v57.0/sobjects/Order",
            "referenceId": "refOrder",
            "body": {
                "AccountId": "{{defaultAccount}}",
                "EffectiveDate": "2023-01-01",
                "Pricebook2Id": "{{standardPricebook}}",
                "BillToContactId": "{{defaultBillToContact}}",
                "Status": "Draft"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v57.0/sobjects/AppUsageAssignment",
            "referenceId": "refAppTag",
            "body": {
                "AppUsageType": "SubscriptionManagement",
                "RecordId": "@{refOrder.id}"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v57.0/sobjects/OrderAction",
            "referenceId": "refOrderAction",
            "body": {
                "OrderId": "@{refOrder.id}",
                "Type": "New Sale"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v57.0/sobjects/OrderItem",
            "referenceId": "refWorkAnywhereBundle",
            "body": {
                "OrderId": "@{refOrder.id}",
                "OrderActionId": "@{refOrderAction.id}",
                "PricebookEntryId": "{{WorkAnywhereBundlePBE}}",
                "ServiceDate": "2023-01-01",
                "Quantity": 1,
                "UnitPrice": 10000,
                "NetUnitPrice": 10000,
                "TotalLineAmount": 10000,
                "PeriodBoundary": "AlignToCalendar",
                "BillingFrequency2": "Monthly"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v57.0/sobjects/OrderItem",
            "referenceId": "refVirtualRouter",
            "body": {
                "OrderId": "@{refOrder.id}",
                "OrderActionId": "@{refOrderAction.id}",
                "PricebookEntryId": "{{VirtualRouterEvergrnPBE}}",
                "ServiceDate": "2023-01-01",
                "Quantity": 100,
                "UnitPrice": 0,
                "NetUnitPrice": 0,
                "TotalLineAmount": 0,
                "PeriodBoundary": "AlignToCalendar",
                "BillingFrequency2": "Monthly"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v57.0/sobjects/OrderItem",
            "referenceId": "refBronzeSLA",
            "body": {
                "OrderId": "@{refOrder.id}",
                "OrderActionId": "@{refOrderAction.id}",
                "PricebookEntryId": "{{SLABronzeEvergrnMonthPBE}}",
                "ServiceDate": "2023-01-01",
                "Quantity": 3,
                "UnitPrice": 0,
                "NetUnitPrice": 0,
                "TotalLineAmount": 0,
                "PeriodBoundary": "AlignToCalendar",
                "BillingFrequency2": "Monthly"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v57.0/sobjects/OrderItemRelationship",
            "referenceId": "refOrderItemRelationship1",
            "body": {
                "ProductRelationshipTypeId": "{{BundleProductRelationshipType}}",
                "MainOrderItemId": "@{refWorkAnywhereBundle.id}",
                "AssociatedOrderItemId": "@{refVirtualRouter.id}",
                "AssociatedOrderItemPricing": "IncludedInBundlePrice",
                "AssociatedQuantScaleMethod": "Proportional"
            }
        },
        {
            "method": "POST",
            "url": "/services/data/v57.0/sobjects/OrderItemRelationship",
            "referenceId": "refOrderItemRelationship2",
            "body": {
                "ProductRelationshipTypeId": "{{BundleProductRelationshipType}}",
                "MainOrderItemId": "@{refWorkAnywhereBundle.id}",
                "AssociatedOrderItemId": "@{refBronzeSLA.id}",
                "AssociatedOrderItemPricing": "IncludedInBundlePrice",
                "AssociatedQuantScaleMethod": "Constant"
            }
        }
    ]
}'
https://domain.com/services/data/v{{version}}/composite

Postman Collection Item JSON

{
  "name": "Create Order With Bundle",
  "request": {
    "method": "POST",
    "header": [
    ],
    "body": {
      "mode": "raw",
      "raw": "{\n    \"allOrNone\": true,\n    \"compositeRequest\": [\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v57.0/sobjects/Order\",\n            \"referenceId\": \"refOrder\",\n            \"body\": {\n                \"AccountId\": \"{{defaultAccount}}\",\n                \"EffectiveDate\": \"2023-01-01\",\n                \"Pricebook2Id\": \"{{standardPricebook}}\",\n                \"BillToContactId\": \"{{defaultBillToContact}}\",\n                \"Status\": \"Draft\"\n            }\n        },\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v57.0/sobjects/AppUsageAssignment\",\n            \"referenceId\": \"refAppTag\",\n            \"body\": {\n                \"AppUsageType\": \"SubscriptionManagement\",\n                \"RecordId\": \"@{refOrder.id}\"\n            }\n        },\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v57.0/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/v57.0/sobjects/OrderItem\",\n            \"referenceId\": \"refWorkAnywhereBundle\",\n            \"body\": {\n                \"OrderId\": \"@{refOrder.id}\",\n                \"OrderActionId\": \"@{refOrderAction.id}\",\n                \"PricebookEntryId\": \"{{WorkAnywhereBundlePBE}}\",\n                \"ServiceDate\": \"2023-01-01\",\n                \"Quantity\": 1,\n                \"UnitPrice\": 10000,\n                \"NetUnitPrice\": 10000,\n                \"TotalLineAmount\": 10000,\n                \"PeriodBoundary\": \"AlignToCalendar\",\n                \"BillingFrequency2\": \"Monthly\"\n            }\n        },\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v57.0/sobjects/OrderItem\",\n            \"referenceId\": \"refVirtualRouter\",\n            \"body\": {\n                \"OrderId\": \"@{refOrder.id}\",\n                \"OrderActionId\": \"@{refOrderAction.id}\",\n                \"PricebookEntryId\": \"{{VirtualRouterEvergrnPBE}}\",\n                \"ServiceDate\": \"2023-01-01\",\n                \"Quantity\": 100,\n                \"UnitPrice\": 0,\n                \"NetUnitPrice\": 0,\n                \"TotalLineAmount\": 0,\n                \"PeriodBoundary\": \"AlignToCalendar\",\n                \"BillingFrequency2\": \"Monthly\"\n            }\n        },\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v57.0/sobjects/OrderItem\",\n            \"referenceId\": \"refBronzeSLA\",\n            \"body\": {\n                \"OrderId\": \"@{refOrder.id}\",\n                \"OrderActionId\": \"@{refOrderAction.id}\",\n                \"PricebookEntryId\": \"{{SLABronzeEvergrnMonthPBE}}\",\n                \"ServiceDate\": \"2023-01-01\",\n                \"Quantity\": 3,\n                \"UnitPrice\": 0,\n                \"NetUnitPrice\": 0,\n                \"TotalLineAmount\": 0,\n                \"PeriodBoundary\": \"AlignToCalendar\",\n                \"BillingFrequency2\": \"Monthly\"\n            }\n        },\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v57.0/sobjects/OrderItemRelationship\",\n            \"referenceId\": \"refOrderItemRelationship1\",\n            \"body\": {\n                \"ProductRelationshipTypeId\": \"{{BundleProductRelationshipType}}\",\n                \"MainOrderItemId\": \"@{refWorkAnywhereBundle.id}\",\n                \"AssociatedOrderItemId\": \"@{refVirtualRouter.id}\",\n                \"AssociatedOrderItemPricing\": \"IncludedInBundlePrice\",\n                \"AssociatedQuantScaleMethod\": \"Proportional\"\n            }\n        },\n        {\n            \"method\": \"POST\",\n            \"url\": \"/services/data/v57.0/sobjects/OrderItemRelationship\",\n            \"referenceId\": \"refOrderItemRelationship2\",\n            \"body\": {\n                \"ProductRelationshipTypeId\": \"{{BundleProductRelationshipType}}\",\n                \"MainOrderItemId\": \"@{refWorkAnywhereBundle.id}\",\n                \"AssociatedOrderItemId\": \"@{refBronzeSLA.id}\",\n                \"AssociatedOrderItemPricing\": \"IncludedInBundlePrice\",\n                \"AssociatedQuantScaleMethod\": \"Constant\"\n            }\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 for a product bundle."
  },
  "response": [
  ]
}