Skip to main content
Solved

Default endpoint SalesPricesInquiry only returning 1st record and not filtering, but includes all records in expanded SalesPriceDetails

  • August 8, 2025
  • 1 reply
  • 64 views

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

  1. There are no Inventory ID’s for any of the records so the API is returning the first created record
  2. 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?

 

Best answer by jinin

Hi ​@mattyo 

  I’m able to retrieve the list of SalesPrices without any issues on my side.

Please try using the 24.200.001 endpoint on your side and confirm whether it works for you.
 

 

1 reply

jinin
Pro I
Forum|alt.badge.img+12
  • Pro I
  • Answer
  • November 21, 2025

Hi ​@mattyo 

  I’m able to retrieve the list of SalesPrices without any issues on my side.

Please try using the 24.200.001 endpoint on your side and confirm whether it works for you.