My Oracle Support Banner

What is Max supported value for limit parameter in GET REST API Call ? (Doc ID 2429019.1)

Last updated on SEPTEMBER 04, 2023

Applies to:

Oracle Fusion Sales - Version and later
Oracle Fusion Product Hub Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.


On : 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

  "totalResults": 29735,
  "count": 500,
  "hasMore": false,
  "limit": 600,
  "offset": 1500,
  "links": [
  "rel": "self",
  "href": "https://<host>:443/salesApi/resources/",
  "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: ) 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.