Commerce API: Get prices in different unit (than default sales unit)

[ThibaultBr1]

By default the pricing api's only seem to give the prices of the default sales unit, however we have multiple sales units and we would like to see all relevant prices.

PS: This is for a Dutch customer so we are using "Doos" (aka Box) and "St" (aka "Pcs")

Setup in D365:
Unit conversions:

Pricing:

API Calls:

1. Calculate Product price
   URL:
   {{baseUrl}}/Commerce/Products(5637324503)/CalculateProductPrice
   JSON Format: ('St' or 'Doos' for second request)
   { "customerAccountNumber": "", "unitOfMeasureSymbol": "St" }

• Request "St" (Pcs) price
  Response: 102.68 ✔️
  

• Request "Doos" (Box) price
  Response: 102.68 ❌
  

2. Get active prices
   URL:
   {{baseUrl}}/Commerce/Products/GetActivePrices?$top=10
   JSON Format:
   { "projectDomain": { "ChannelId": 5637173076 }, "productIds": [ 5637324503 ], "activeDate": "2025-01-13T12:14:52.52Z", "customerId": "K1019161", "includeSimpleDiscountsInContextualPrice": true }

Response: only shows 1 result (in "St") ❌

3. Get Product price
   URL:
   {{baseUrl}}/Commerce/Products(5637324503)/GetPrice(customerAccountNumber='',unitOfMeasureSymbol='Doos')
   JSON Format:
   empty request
   Response: Single result (in "St") ❌
   

[ThibaultBr1]

Microsoft support guided us to using the PriceLookupContext and with this we were able to resolve the issue:

you can use the priceLookupContext in GetActivePrices API to specify the unit of measure (UoM) and other relevant details. This allows for more precise and flexible price lookups. The details is in https://learn.microsoft.com/en-us/dynamics365/commerce/pricing-apis#getactiveprices

so using the following request we're able to get what we wanted!

{
    "projectDomain": 
    {
        "channelId": 5637173076
    },
    "priceLookupContext": {
        "LineContexts": [
            {
                "UnitOfMeasureSymbol": "DOOS",
                "ProductRecordId": 5637324503
            }
        ]
    }
}