Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / ODATA handling of more...
Finance | Project Operations, Human Resources, ...
Suggested answer

ODATA handling of more than 10000 records: nextLink?

(1) ShareShare
ReportReport
Posted on by Basti Aurand 115
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
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 2,201 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,828 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 115 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 2,201 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 115 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 2,201 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans