Thank you in advance for your assistance.
I usually work using Power Query and data from the table Purchase Price (7012) page Purchase Price (7012, Worksheet) using “Expose data as web service APIs”. I have noticed that records are not complete; there are missing item numbers from the letter S to Z.
This situation does not happen when I work with Item (27).
Is there something that I am missing?
Are you hitting pagination? BC APIs serve a max of 20K records in a single call?
There’s nothing in the API that will limit the number of records.
It’s a global setting for all APIs, not related to APIs created from the Simple Object Designer.
You have to use OData pagination: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/server-driven-paging-in-odata-web-services
Thank you, Hougaard!
I believe I am using the limit of 20,000 records in a single call. Is there a way to create another request to retrieve the next page of information using Simple Object Designer?