What is Max supported value for limit parameter in GET REST API Call ?
(Doc ID 2429019.1)
Last updated on SEPTEMBER 07, 2022
Applies to:
Oracle Fusion Sales - Version 11.12.1.0.0 and laterInformation in this document applies to any platform.
Goal
On : 11.12.1.0.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:
https://<host>/salesApi/resources/latest/activities?limit=600&offset=1500&totalResults=true
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
...
...
],
"totalResults": 29735,
"count": 500,
"hasMore": false,
"limit": 600,
"offset": 1500,
"links": [
{
"rel": "self",
"href": "https://<host>:443/salesApi/resources/11.12.1.0/activities",
"name": "activities",
"kind": "collection"
}
]
}
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 ?
Solution
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
Goal |
Solution |
References |