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

Notifications

Announcements

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

News and Announcements

Season of Giving Solutions is Here!

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