web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 (2)
  • Suggested answer
    Predator75 Profile Picture
    Predator75 35 on at
    RE: Using pagination on Business Central API

    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.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at
    RE: Using pagination on Business Central API

    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
    Nitin Verma Profile Picture
    Nitin Verma 21,666 Moderator on at
    RE: Using pagination on Business Central API

    Hi Predator75 ,

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

    See if that works for you.

  • Suggested answer
    Predator75 Profile Picture
    Predator75 35 on at
    RE: Using pagination on Business Central API

    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,666 Moderator on at
    RE: Using pagination on Business Central API

    Hi Predator75 ,

    Did you try below filters in your api?

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

  • Predator75 Profile Picture
    Predator75 35 on at
    RE: Using pagination on Business Central API

    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,666 Moderator on at
    RE: Using pagination on Business Central API

    Hi Predator75 ,

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

    Thanks.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 4,252

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,117

#3
Sumit Singh Profile Picture

Sumit Singh 2,956

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans