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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Web Service only return limited number of records

(0) ShareShare
ReportReport
Posted on by

Hi All,

I found a issue that web service could only return 1000 records. Which will cause a data lost if ther record is more than 1000. Does any know how to solve this issue or the web service could only support the record less than 1000? I tried the web service "workflowSalesDocument" or the web service that I created. Both of them could only return limited number of records. Is there any setting for this?

Thanks in advance.

Categories:
I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    Are you using SOAP WS? Are you using ReadMultiple?

  • Community Member Profile Picture
    on at

    I'm using Odata, I have fix this issue by send another request based on Odata Next link. Thank you so much.

  • Suggested answer
    Jayamurugan Profile Picture
    5 on at

    Hi,

    By default, Maximum page size has been assigned as 1000 in the NAV Server OData Services Administration, you can increase the Page size to a maximum range as you need or like to flow all the records of the Entity.

    pastedimage1663133517176v1.png

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans