Small and medium business | Business Central, N...

API - GET and POST Item by Location

(0) Share

Report

Posted on by Vince ReplenishMe

I have an inventory replenishment app that is live on other platforms and now building integration into Dynamics 365. I am trying to GET and POST Item details i.e. Inventory on hand, Sales Quantities, On Orders by Location/Site. I am only managing to get this data as Total Quantities i.e all Location/Sites. Does anyone know how to get out via API's details of Items at a Location/Site level?

These are the links I've been using to find API info, but I can't see any API for this level of detail.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/resources/dynamics_item

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_salesorderline_get

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_purchaseorder_create

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_location_get

Thanks

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

What about creating your own API? Your partner can assist you with this development effort.

Thanks.

Was this reply helpful? Yes No
Vince ReplenishMe 5 on at

Like (0)

Report

Thanks Marco. Are you able to send a link from Microsoft resources that explains how to create your own API?

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

Here:

docs.microsoft.com/.../devenv-develop-custom-api

Hope it helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This custom api need to install in all business center account which used my PHP app.?

Or my custom API works in all account which used my PHP app.

because of when customer installed our APP in business center this custom API worked or not in their business center account? .

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, BC has a standard Query that can be used.

Items By Location (2554)

For example,

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I need get and post purchase order by location using API , But purchase order api does not give location parameter that's why need to develop custom API for purchase order,
For custom purchase order i need to develop in AL language , My concern is this custom api works in all business center account which use our APP. Or need any other stuff.?

Was this reply helpful? Yes No