x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 1 reply
  • Subscribers 134 subscribers
  • Views 673 views
  • Users 0 members are here
Browse Forums
Announcements
269
topics
260
replies
Databases and Operating Systems
759
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
851
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
183
topics
410
replies
Mwangi

Sage 300 API Query threshold

SOLVED
Posted By

Sage 300 2019 PU4  

http://XXXXXXX/Sage300WebApi/v1.0/-/XXXXXX/AR/$metadata#ARPostedDocuments 

The above query returns 100 records only.

Is there a way i can increase the threshold to 1,000 or remove the it completely?



  • +1
    verified answer

    In the web.config file (...\Online\WebApi), we have established this 100 threshold for performance and other considerations. However, by changing the value for the "PageSize" element from 100 to 1000, you can tailor the web api to have a new threshold number.

*Community Hub is the new name for Sage City