Powershell / Salesforce Platform APIs / Calculate Price (New Sale with Discounts)
Back to Collection Items
Add-Type -Path "C:\chilkat\ChilkatDotNet47-x64\ChilkatDotNet47.dll"
# This example assumes the Chilkat API to have been previously unlocked.
# See Global Unlock Sample for sample code.
$http = New-Object 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"
# }
# }
# ]
# }
# }
$json = New-Object Chilkat.JsonObject
$json.UpdateString("listPricebookId","{{standardPricebook}}")
$json.UpdateString("pricingFlow","GET_PRICE_USING_CONTEXT")
$json.UpdateString("graph.graphId","1")
$json.UpdateString("graph.records[0].referenceId","ref_sales_txn")
$json.UpdateString("graph.records[0].record.attributes.type","SalesTransactionShape")
$json.UpdateString("graph.records[0].record.CurrencyIsoCode","USD")
$json.UpdateString("graph.records[1].referenceId","Item_1_Evergreen")
$json.UpdateString("graph.records[1].record.attributes.type","SalesTransactionItemShape")
$json.UpdateString("graph.records[1].record.SalesTransactionShapeId","@{ref_sales_txn.Id}")
$json.UpdateString("graph.records[1].record.StartDate","2023-01-01")
$json.UpdateString("graph.records[1].record.ProductId","{{SLA_BronzeProduct}}")
$json.UpdateString("graph.records[1].record.ProductSellingModelId","{{EvergreenMonthlyPSM}}")
$json.UpdateNumber("graph.records[1].record.Quantity","3.0")
$json.UpdateString("graph.records[1].record.PricingTransactionType","NewSale")
$json.UpdateString("graph.records[1].record.CurrencyIsoCode","USD")
$json.UpdateString("graph.records[2].referenceId","Item_2_Termed")
$json.UpdateString("graph.records[2].record.attributes.type","SalesTransactionItemShape")
$json.UpdateString("graph.records[2].record.SalesTransactionShapeId","@{ref_sales_txn.Id}")
$json.UpdateString("graph.records[2].record.StartDate","2023-01-01")
$json.UpdateString("graph.records[2].record.EndDate","2024-01-01")
$json.UpdateString("graph.records[2].record.ProductId","{{VirtualRouterProduct}}")
$json.UpdateString("graph.records[2].record.ProductSellingModelId","{{TermMonthlyPSM}}")
$json.UpdateNumber("graph.records[2].record.Quantity","100.0")
$json.UpdateString("graph.records[2].record.PricingTransactionType","NewSale")
$json.UpdateString("graph.records[2].record.CurrencyIsoCode","USD")
$json.UpdateString("graph.records[3].referenceId","Order_Level_Discount")
$json.UpdateString("graph.records[3].record.attributes.type","PriceAdjustmentGroupShape")
$json.UpdateString("graph.records[3].record.SalesTransactionShapeId","@{ref_sales_txn.Id}")
$json.UpdateString("graph.records[3].record.AdjustmentType","AdjustmentPercentage")
$json.UpdateInt("graph.records[3].record.AdjustmentValue",-20)
$json.UpdateString("graph.records[3].record.AdjustmentSource","Discretionary")
$json.UpdateString("graph.records[4].referenceId","Line_Level_Discount")
$json.UpdateString("graph.records[4].record.attributes.type","PriceAdjustmentItemShape")
$json.UpdateString("graph.records[4].record.SalesTransactionItemShapeId","@{Item_1_Evergreen.Id}")
$json.UpdateString("graph.records[4].record.AdjustmentType","AdjustmentAmount")
$json.UpdateInt("graph.records[4].record.AdjustmentValue",-10)
$json.UpdateString("graph.records[4].record.AdjustmentSource","Discretionary")
$json.UpdateString("graph.records[4].record.AdjustmentAmountScope","Unit")
# Adds the "Authorization: Bearer <access_token>" header.
$http.AuthToken = "<access_token>"
$http.SetRequestHeader("Content-Type","application/json")
$resp = $http.PostJson3("https://domain.com/services/data/v{{version}}/commerce/pricing/salestransaction/actions/calculate-price","application/json",$json)
if ($http.LastMethodSuccess -eq $false) {
$($http.LastErrorText)
exit
}
$($resp.StatusCode)
$($resp.BodyStr)
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": [
]
}
