Web service endpoint: /entity/Default/22.200.001/SalesPricesInquiry?$expand=SalesPriceDetails
Params:
{
"InventoryID": {
"value": "SPCBSERVICE"
}
}Response is always the first record on the SalesPrices Inquiry and doesn’t filter for the record with the Inventory ID of ‘SPCBSERVICE’.
However, when expanding the SalesPriceDetails, all 135 or so records are included.
Also, the InventoryID of the record is blank.
So it looks like
- There are no Inventory ID’s for any of the records so the API is returning the first created record
- Expanding the SalesPriceDetails of that record includes all of the Sales Price records.
{
"id": "81a55625-3913-4ea8-9869-67da0acff742",
"rowNumber": 1,
"note": null,
"EffectiveAsOf": {
"value": "2025-08-08T00:00:00+00:00"
},
"InventoryID": {},
"ItemClassID": {},
"PriceClass": {},
"PriceCode": {},
"PriceManager": {},
"PriceManagerIsMe": {
"value": false
},
"PriceType": {
"value": "All Prices"
},
"PriceWorkgroup": {},
"PriceWorkgroupIsMine": {
"value": false
},
"SalesPriceDetails": [
{
... records 1 to 100 are here
},
{
"id": "c98e6819-3f8c-ef11-ac3f-0272a46eb149",
"rowNumber": 131,
"note": {
"value": ""
},
"CreatedDateTime": {
"value": "2024-10-17T04:20:13.239+00:00"
},
"CurrencyID": {
"value": "AUD"
},
"Description": {
"value": "xxxx"
},
"EffectiveDate": {
"value": "2024-07-01T00:00:00+00:00"
},
"ExpirationDate": {},
"InventoryID": {
"value": "SPCBSERVICE"
},
"LastModifiedDateTime": {
"value": "2024-10-17T04:20:13.239+00:00"
},
"NoteID": {
"value": "c98e6819-3f8c-ef11-ac3f-0272a46eb149"
},
"Price": {
"value": xxxxx
},
"PriceCode": {},
"PriceType": {
"value": "Base"
},
"Promotion": {
"value": false
},
"RecordID": {
"value": 208
},
"Tax": {},
"TaxCalculationMode": {
"value": "Not Set"
},
"UOM": {
"value": "HOUR"
},
"custom": {},
"_links": {
"files:put": "/entity/Default/22.200.001/files/PX.Objects.AR.ARSalesPriceMaint/Records/c98e6819-3f8c-ef11-ac3f-0272a46eb149/{filename}"
}
},
{
... records 102 to 135 are here
},
],
"TaxCalculationMode": {
"value": "All Modes"
},
"custom": {}
}Is this working as intended or am I doing something wrong with the API?
