35
Hi
I am on Business Central Online.
I have a GET API that retrieves the number of Contacts in Business Central.
It works but there is a hard 20,000 limit for the number of contacts in the system.
I believe that there should be some pagination logic that I can use on the API to get the remaining records after the 20,000.
Any assistance or URL will be greatly appreciated.
Eng Siong Tan
Yes. Thank you very much.
The odata.nextlink works and it is alot more user friendly. Or at least it is more what we would expect from Microsoft.
Business Central API follows the odata standard for paging, and when there are more pages of data to retrieve the @odata.nextlink property is included in the response which you can use to create another request to get the next page of information. This pattern can be repeated until the @odata.nextlink is null or missing to get to the end of the dataset.
Hi Predator75 ,
If you can use Configuration package, it will also export the data out.
See if that works for you.
Thank you. And Yes. It works for the EC0*, EC1*, EC2*.
This solves my current Contact issue.
The reason why I asked is that I have an Item Master with records more than 10K.
Which I also need to export out.
Hi Nitin
Great idea for things with sequential numbers.
EC0*
EC1*
EC2*
However, this does not solve the issue for master records without a sequential primary no.
May I know if you are aware of pagination or batching solutions?
Thanks
Hi Predator75 ,
Can you try with the filter in the API so that you can get all your records partially?
Thanks.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (