Dynamics Community Forum Thread Details

Dynamics 365 Business Central API - Sales Invoices Missing on Rare Occasions

Hey! We're working with the Dynamics 365 Business Central API and have observed that on rare occasions, some sales invoices appear to be missing when querying the endpoint.

What we're seeing:

The API responds successfully with no errors
However, some invoices that exist in the system are not included in the API response
This happens occasionally but not consistently

Note: In at least one instance, we noticed this occurred when multiple invoices were created in a short time window, though we haven't confirmed if this is always the case.

Questions:

Are there any known issues with the Sales Invoices API not returning all records?
Is there any eventual consistency or indexing delay we should be aware of?
Are there any rate limiting or batching considerations that might cause some records to be temporarily unavailable via the API?
Any suggestions on how to ensure we're getting a complete dataset when querying?

Any insights or suggestions would be greatly appreciated!

Categories:

Dynamics 365 Business Central

1. Nothing that i'm aware of but i'd recommend checking postman and testing the BC API calls in postman first. There could be filtered records or you may hit a limit in the data being queried. Sandbox environments also have extra limitations versus production environments.

2 and 3. There shouldn't be any indexing delay but you can hit operational limits with OData and SOAP: Operation Limits in Dynamics 365 Business Central - Business Central | Microsoft Learn - You may have too many requests in a minute.

4. If you're using the standard BC web services i'd recommend actually creating your own new web service with just the data you need. If this is posted invoices you may also have a lot of invoices so you may want to filter for a date range.

Usually there aren't any issues with pulling data using OData or SOAP unless there is a high volume of records or you are constantly querying the database.

If possible, it would be useful if you could provide screenshots of an example of your API call and what data its pulling.

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS