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:

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

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