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

All responses (6)

Answers (0)

Sort by

Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

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

Thanks.
Vince ReplenishMe 5 on at

Like (0)

Report
Copy link

Link copied!

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

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

Here:

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

Hope it helps.
Community Member on at

Like (0)

Report
Copy link

Link copied!

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? .
Suggested answer

YUN ZHU 103,712 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

Items By Location (2554)

For example,

Hope this helps.

Thanks.

ZHU
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.?