ODATA Web Service Api returning different quantity for all products vs indiviudal product

(0) Share

Report

Posted on by Logan K

I am currently building an integration between bc and shopify using an integration software celigo.
We have assembly products that are assembled to order and do not use the conventional inventory field. As you can see our inventory displays 0 each for this product

We have the amount able to be assembled as a quantity available field on the item card as pictured below

I have been testing endpoints for the integration using postman.
When I query the web service for this individual item it returns the appropriate value for the quantity available field.

Endpoint 1 /Item_Card(No='HSA12401-001')?$select=No,QuantityAvailable

However when I query the same endpoint but all products ie: not specifying the product No. The QuantityAvailable field displays -49 for all products.

Endpoint 2 /Item_Card?$select=No,QuantityAvailable

How can I get the QuantityAvailable field to display the correct value for the list of products.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

Hi

I think you have to use an API that goes on the item list and on the card

e.g. use these

api.businesscentral.dynamics.com/.../items

you could also have it developed with the items you need

DAniele

Was this reply helpful? Yes No