web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Using pagination on Bu...
Small and medium business | Business Central, N...
Suggested Answer

Using pagination on Business Central API

(0) ShareShare
ReportReport
Posted on by Predator75 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

I have the same question (3)
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,708 Moderator on at

    Hi Predator75 ,

    Can you try with the filter in the API so that you can get all your records partially?

    Thanks.

  • Predator75 Profile Picture
    Predator75 35 on at

    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

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,708 Moderator on at

    Hi Predator75 ,

    Did you try below filters in your api?

    ?$filter=No_ ='@*EC0*'

  • Suggested answer
    Predator75 Profile Picture
    Predator75 35 on at

    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.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,708 Moderator on at

    Hi Predator75 ,

    If you can use Configuration package, it will also export the data out.

    See if that works for you.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    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.

  • Suggested answer
    Predator75 Profile Picture
    Predator75 35 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans