What is Max supported value for limit parameter in GET REST API Call ?
(Doc ID 2429019.1)
Last updated on DECEMBER 22, 2020
Applies to:Oracle Fusion Sales - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, Accounts, Contacts, Households
Oracle Sales Cloud: GET ReST API call returns only 500 Records
When using GET_ALL API for any Oracle Sales Cloud object, it seems the record return count is limited to 500 rows even though we are specifying a limit of > 500 (like 600,1000) in the API calls.
We are using the following API endpoint:
We get the following summary, indicating the count was limited to 500.
NOTE: there are definitely more rows than 500 in our environment, totalResults count indicate 29735
Q1: Is max supported value for limit parameter is 499 ? Please confirm. If yes, Why isnt same info mentioned in Oracle Sales Cloud documentation (URL for reference: https://docs.oracle.com/cloud/farel12/salescs_gs/FAAPS/Resource_Methods.html ) Also not mentioned in Rel 13 documentation as well.
Q2: Doc ID 2110516.1 specifies that max limit before Release 11 was 500 & from Release 11+ support for larger number of records will be available. But I can still see in Rel 12 and Rel13 instance still max records returned are 500.
Q3: Any info when support for larger records is going to come ?
Q4: Why is hasMore false in above response, even when more records are present ?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document