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

Missing sales orders via API

(0) Share

Report

Posted on by lachlancast

Hi there,

When GET'ng the default salesOrder API to retrieve a list of our sales orders within BC, we notice some (i.e. around 5%) don't show up (but yet these can still be accessed via the interface as normal)

If we look at the 'Sales Order Buffer Table' within the BC Admin interface we don't see the sales orders either.

None of these sales orders that are not showing up via API or in the buffer table have anything in common, so was curious whether this is expected behavior and/or where else Sales Orders could be stored within BC SaaS?

Thanks for your time

Lachlan

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Suggested answer

Congruent Infotech on at

Like (1)

Report

RE: Missing sales orders via API

Hello Lachon,

In BC, Sales order is composed of Sales header and Sales line tables. Try creating a API URL with a filter Document type = Order and combine both the tables with the primary key field in API URL. Use that API to for retrieving your sales orders.

Below link for reference,

business-central.to-increase.com/.../across-how-publish-web-service

Hope this Helps!!

Thanks,

Team Congruent
Suggested answer

DAnny3211 9,274 Moderator on at

Like (1)

Report

RE: Missing sales orders via API

hi

try this

api.businesscentral.dynamics.com/.../salesOrders

DAniele