Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / ODATA handling of more...
Finance forum
Suggested answer

ODATA handling of more than 10000 records: nextLink?

(2) ShareShare
ReportReport
Posted on by Basti Aurand 72
Hello,
 
we are facing the /known ODATA problem/ when working with more than 10000 records. What is the best way to handle those issues?
 
I read something about a nextLink keyword in ODATA but found nothing or no example for D365FO. I know that you could work with $skip $top to get the records in smaller packages, but this is quite a bit more of work than nextLink.
 
Thanks for any hints.
 
Sebastian
Categories:
Integrations
Development / Customization / SDK
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 1,957 Super User 2024 Season 2 on at
    ODATA handling of more than 10000 records: nextLink?
    @sebastian, no its at 10k, but you could use $top 5000 with $skip 5000 
  • Suggested answer
    andreasraithel Profile Picture
    andreasraithel 4,680 Super User 2024 Season 2 on at
    ODATA handling of more than 10000 records: nextLink?
    Hy,
    as per MS recommdation ODATA is only recommended for small data volume and less frequent actions as it can negative impact D365FO landscape.
     
    Instead I recommend to create use data package and execute the data project from external (Data management package REST API - Finance & Operations | Dynamics 365 | Microsoft Learn)
    If is is just export the "Export to DataLake" (already depreciated) or Synapse Link are also good choices as mentioned by Anthony.
     
    Hope this helps.
  • Basti Aurand Profile Picture
    Basti Aurand 72 on at
    ODATA handling of more than 10000 records: nextLink?
    Is there any chance to configure the size of the packages (e.g.: 5000 instead of 10000)
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 1,957 Super User 2024 Season 2 on at
    [D365FO]: ODATA handling of more than 10000 records: nextLink?
    That's correct, if you reduce the size to 100 rows, there wont be a next page so no next link. You will get the link if the results go over 10k rows
  • Basti Aurand Profile Picture
    Basti Aurand 72 on at
    [D365FO]: ODATA handling of more than 10000 records: nextLink?
    Thanks for the repsonse.
     
    In the "Odata.NextLink" post the logic is described but unfortunatly there is no link in the ODATA response if you reduce the size with $top:
     
     
    How could you reduce the size of the response and get the "getNext-Link" in the JSON response?
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 1,957 Super User 2024 Season 2 on at
    [D365FO]: ODATA handling of more than 10000 records: nextLink?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans