Query for returning only products where inventory is available?

thisisbolo

Is there a way to do this in the the call? Is there a query partaker for this like &qoh>0?

[Deleted User]

Hello @thisisbolo,

Yes, this is possible loading first the relation "ItemShops" and then using the query parameter ">". See my code sample below.

GET /API/Account/{{accountID}}/Item?load_relations=["ItemShops"]&ItemShops.qoh=>,0

thisisbolo

That's great Alex. It worked! Thank you. For anyone that needs this URL encoded, this is what it would look like:

https://api.lightspeedapp.com/API/Account/{{accountID}}/Item.json?load_relations=["ItemShops"]&ItemShops.qoh=>,0

It looks like you don't need the .qoh=>,0 encoded out. When I did this, it returned an error.