Foxpro / Salesforce Platform APIs / Calculate Price (New Sale with Discounts)
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.
* {
* "listPricebookId": "{{standardPricebook}}",
* "pricingFlow": "GET_PRICE_USING_CONTEXT",
* "graph": {
* "graphId": "1",
* "records": [
* {
* "referenceId": "ref_sales_txn",
* "record": {
* "attributes": {
* "type": "SalesTransactionShape"
* },
* "CurrencyIsoCode": "USD"
* }
* },
* {
* "referenceId": "Item_1_Evergreen",
* "record": {
* "attributes": {
* "type": "SalesTransactionItemShape"
* },
* "SalesTransactionShapeId": "@{ref_sales_txn.Id}",
* "StartDate": "2023-01-01",
* "ProductId": "{{SLA_BronzeProduct}}",
* "ProductSellingModelId": "{{EvergreenMonthlyPSM}}",
* "Quantity": 3.0,
* "PricingTransactionType": "NewSale",
* "CurrencyIsoCode": "USD"
* }
* },
* {
* "referenceId": "Item_2_Termed",
* "record": {
* "attributes": {
* "type": "SalesTransactionItemShape"
* },
* "SalesTransactionShapeId": "@{ref_sales_txn.Id}",
* "StartDate": "2023-01-01",
* "EndDate": "2024-01-01",
* "ProductId": "{{VirtualRouterProduct}}",
* "ProductSellingModelId": "{{TermMonthlyPSM}}",
* "Quantity": 100.0,
* "PricingTransactionType": "NewSale",
* "CurrencyIsoCode": "USD"
* }
* },
* {
* "referenceId": "Order_Level_Discount",
* "record": {
* "attributes": {
* "type": "PriceAdjustmentGroupShape"
* },
* "SalesTransactionShapeId": "@{ref_sales_txn.Id}",
* "AdjustmentType": "AdjustmentPercentage",
* "AdjustmentValue": -20,
* "AdjustmentSource": "Discretionary"
* }
* },
* {
* "referenceId": "Line_Level_Discount",
* "record": {
* "attributes": {
* "type": "PriceAdjustmentItemShape"
* },
* "SalesTransactionItemShapeId": "@{Item_1_Evergreen.Id}",
* "AdjustmentType": "AdjustmentAmount",
* "AdjustmentValue": -10,
* "AdjustmentSource": "Discretionary",
* "AdjustmentAmountScope": "Unit"
* }
* }
* ]
* }
* }
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("listPricebookId","{{standardPricebook}}")
loJson.UpdateString("pricingFlow","GET_PRICE_USING_CONTEXT")
loJson.UpdateString("graph.graphId","1")
loJson.UpdateString("graph.records[0].referenceId","ref_sales_txn")
loJson.UpdateString("graph.records[0].record.attributes.type","SalesTransactionShape")
loJson.UpdateString("graph.records[0].record.CurrencyIsoCode","USD")
loJson.UpdateString("graph.records[1].referenceId","Item_1_Evergreen")
loJson.UpdateString("graph.records[1].record.attributes.type","SalesTransactionItemShape")
loJson.UpdateString("graph.records[1].record.SalesTransactionShapeId","@{ref_sales_txn.Id}")
loJson.UpdateString("graph.records[1].record.StartDate","2023-01-01")
loJson.UpdateString("graph.records[1].record.ProductId","{{SLA_BronzeProduct}}")
loJson.UpdateString("graph.records[1].record.ProductSellingModelId","{{EvergreenMonthlyPSM}}")
loJson.UpdateNumber("graph.records[1].record.Quantity","3.0")
loJson.UpdateString("graph.records[1].record.PricingTransactionType","NewSale")
loJson.UpdateString("graph.records[1].record.CurrencyIsoCode","USD")
loJson.UpdateString("graph.records[2].referenceId","Item_2_Termed")
loJson.UpdateString("graph.records[2].record.attributes.type","SalesTransactionItemShape")
loJson.UpdateString("graph.records[2].record.SalesTransactionShapeId","@{ref_sales_txn.Id}")
loJson.UpdateString("graph.records[2].record.StartDate","2023-01-01")
loJson.UpdateString("graph.records[2].record.EndDate","2024-01-01")
loJson.UpdateString("graph.records[2].record.ProductId","{{VirtualRouterProduct}}")
loJson.UpdateString("graph.records[2].record.ProductSellingModelId","{{TermMonthlyPSM}}")
loJson.UpdateNumber("graph.records[2].record.Quantity","100.0")
loJson.UpdateString("graph.records[2].record.PricingTransactionType","NewSale")
loJson.UpdateString("graph.records[2].record.CurrencyIsoCode","USD")
loJson.UpdateString("graph.records[3].referenceId","Order_Level_Discount")
loJson.UpdateString("graph.records[3].record.attributes.type","PriceAdjustmentGroupShape")
loJson.UpdateString("graph.records[3].record.SalesTransactionShapeId","@{ref_sales_txn.Id}")
loJson.UpdateString("graph.records[3].record.AdjustmentType","AdjustmentPercentage")
loJson.UpdateInt("graph.records[3].record.AdjustmentValue",-20)
loJson.UpdateString("graph.records[3].record.AdjustmentSource","Discretionary")
loJson.UpdateString("graph.records[4].referenceId","Line_Level_Discount")
loJson.UpdateString("graph.records[4].record.attributes.type","PriceAdjustmentItemShape")
loJson.UpdateString("graph.records[4].record.SalesTransactionItemShapeId","@{Item_1_Evergreen.Id}")
loJson.UpdateString("graph.records[4].record.AdjustmentType","AdjustmentAmount")
loJson.UpdateInt("graph.records[4].record.AdjustmentValue",-10)
loJson.UpdateString("graph.records[4].record.AdjustmentSource","Discretionary")
loJson.UpdateString("graph.records[4].record.AdjustmentAmountScope","Unit")
* Adds the "Authorization: Bearer <access_token>" header.
loHttp.AuthToken = "<access_token>"
loHttp.SetRequestHeader("Content-Type","application/json")
loResp = loHttp.PostJson3("https://domain.com/services/data/v{{version}}/commerce/pricing/salestransaction/actions/calculate-price","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 "Content-Type: application/json"
-d '{
"listPricebookId": "{{standardPricebook}}",
"pricingFlow": "GET_PRICE_USING_CONTEXT",
"graph": {
"graphId": "1",
"records": [
{
"referenceId": "ref_sales_txn",
"record": {
"attributes": {
"type": "SalesTransactionShape"
},
"CurrencyIsoCode": "USD"
}
},
{
"referenceId": "Item_1_Evergreen",
"record": {
"attributes": {
"type": "SalesTransactionItemShape"
},
"SalesTransactionShapeId": "@{ref_sales_txn.Id}",
"StartDate": "2023-01-01",
"ProductId": "{{SLA_BronzeProduct}}",
"ProductSellingModelId": "{{EvergreenMonthlyPSM}}",
"Quantity": 3.0,
"PricingTransactionType": "NewSale",
"CurrencyIsoCode": "USD"
}
},
{
"referenceId": "Item_2_Termed",
"record": {
"attributes": {
"type": "SalesTransactionItemShape"
},
"SalesTransactionShapeId": "@{ref_sales_txn.Id}",
"StartDate": "2023-01-01",
"EndDate": "2024-01-01",
"ProductId": "{{VirtualRouterProduct}}",
"ProductSellingModelId": "{{TermMonthlyPSM}}",
"Quantity": 100.0,
"PricingTransactionType": "NewSale",
"CurrencyIsoCode": "USD"
}
},
{
"referenceId": "Order_Level_Discount",
"record": {
"attributes": {
"type": "PriceAdjustmentGroupShape"
},
"SalesTransactionShapeId": "@{ref_sales_txn.Id}",
"AdjustmentType": "AdjustmentPercentage",
"AdjustmentValue": -20,
"AdjustmentSource": "Discretionary"
}
},
{
"referenceId": "Line_Level_Discount",
"record": {
"attributes": {
"type": "PriceAdjustmentItemShape"
},
"SalesTransactionItemShapeId": "@{Item_1_Evergreen.Id}",
"AdjustmentType": "AdjustmentAmount",
"AdjustmentValue": -10,
"AdjustmentSource": "Discretionary",
"AdjustmentAmountScope": "Unit"
}
}
]
}
}'
https://domain.com/services/data/v{{version}}/commerce/pricing/salestransaction/actions/calculate-price
Postman Collection Item JSON
{
"name": "Calculate Price (New Sale with Discounts)",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"listPricebookId\": \"{{standardPricebook}}\",\n \"pricingFlow\": \"GET_PRICE_USING_CONTEXT\",\n \"graph\": {\n \"graphId\": \"1\",\n \"records\": [\n {\n \"referenceId\": \"ref_sales_txn\",\n \"record\": {\n \"attributes\": {\n \"type\": \"SalesTransactionShape\"\n },\n \"CurrencyIsoCode\": \"USD\"\n }\n },\n {\n \"referenceId\": \"Item_1_Evergreen\",\n \"record\": {\n \"attributes\": {\n \"type\": \"SalesTransactionItemShape\"\n },\n \"SalesTransactionShapeId\": \"@{ref_sales_txn.Id}\",\n \"StartDate\": \"2023-01-01\",\n \"ProductId\": \"{{SLA_BronzeProduct}}\",\n \"ProductSellingModelId\": \"{{EvergreenMonthlyPSM}}\",\n \"Quantity\": 3.0,\n \"PricingTransactionType\": \"NewSale\",\n \"CurrencyIsoCode\": \"USD\"\n }\n },\n {\n \"referenceId\": \"Item_2_Termed\",\n \"record\": {\n \"attributes\": {\n \"type\": \"SalesTransactionItemShape\"\n },\n \"SalesTransactionShapeId\": \"@{ref_sales_txn.Id}\",\n \"StartDate\": \"2023-01-01\",\n \"EndDate\": \"2024-01-01\",\n \"ProductId\": \"{{VirtualRouterProduct}}\",\n \"ProductSellingModelId\": \"{{TermMonthlyPSM}}\",\n \"Quantity\": 100.0,\n \"PricingTransactionType\": \"NewSale\",\n \"CurrencyIsoCode\": \"USD\"\n }\n },\n {\n \"referenceId\": \"Order_Level_Discount\",\n \"record\": {\n \"attributes\": {\n \"type\": \"PriceAdjustmentGroupShape\"\n },\n \"SalesTransactionShapeId\": \"@{ref_sales_txn.Id}\",\n \"AdjustmentType\": \"AdjustmentPercentage\",\n \"AdjustmentValue\": -20,\n \"AdjustmentSource\": \"Discretionary\"\n }\n },\n {\n \"referenceId\": \"Line_Level_Discount\",\n \"record\": {\n \"attributes\": {\n \"type\": \"PriceAdjustmentItemShape\"\n },\n \"SalesTransactionItemShapeId\": \"@{Item_1_Evergreen.Id}\",\n \"AdjustmentType\": \"AdjustmentAmount\",\n \"AdjustmentValue\": -10,\n \"AdjustmentSource\": \"Discretionary\",\n \"AdjustmentAmountScope\": \"Unit\"\n }\n } \n ]\n }\n}"
},
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/commerce/pricing/salestransaction/actions/calculate-price",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"commerce",
"pricing",
"salestransaction",
"actions",
"calculate-price"
]
},
"description": "Calculate the price of a sales transaction, including a top-level and a line-level discount. The top-level discount specifies 20% off the entire sales transaction, while the line-level discount specifies $10 off the sales transaction item.\n\nIn this example, the sales transaction is an order and the sales transaction item is an order item."
},
"response": [
]
}
