simPRO API Forum

I'm trying to retrieve items in stock via the API, specifically higher value items.
I am able to retrieve items in a storage device through the API fine, however I do not appear to be able to use the orderby parameter to sort by InventoryValue (or Name/ID) using ?orderby=InventoryValue

I suppose I could pull down a list of all items in stock and sort it programatically, however the maximum page size is 250 - is there a way to retrieve the total number of items in a storage device so I could calculate how many pages i would need to pull?

Hi rohan,
The stock items is not supporting the orderby parameter. If you wish to retrieve the higher value items you can filter based on a minimum amount. For example 300 as seen below and it will return all items with Inventory value 300 and higher. If you wish to see the number of results of your list and also the number of pages you need to retrieve this is all available in the result header. Here you can find 'result-total' and 'result-pages'.

I hope this helps.

Regards

Thanks for the reply. Your suggestions have helped me greatly.
The documentation indicates that you can orderby.
https://developer.simprogroup.com/apido ... tock-Items

Hi,
I'm glad you could improve your query.

I see that the documentation includes orderby. We will look into the possibility of adding the sorting or if we need to update the documentation.

Thank you for raising this.

regards