My Oracle Support Banner

Oracle Fusion REST API For Oracle Global Human Resources Cloud Limited To 500 Records (GET) (Doc ID 2335561.1)

Last updated on MAY 11, 2018

Applies to:

Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version, Data Load

REST API for Oracle Global Human Resources Cloud limited to 500 records (GET)


It seems the record return count is limited to 500 rows even though we are specifying a limit of 100,000 in the API calls.
 

We are using the following API end point;

https://<>.hcm.us6.oraclecloud.com/hcmCoreApi/resources/11.12.1.0/emps?expand=personExtraInformation,directReports,photo,personDFF,assignments.assignmentDFF&onlyData=true&limit=1000000

We get the following summary, indicating the count was limited to 500. NOTE: there are definitely more rows than 500 in our environment;

  "count": 500,
  "hasMore": false,
  "limit": 1000000,
  "offset": 0,
  "links": [
  {
  "rel": "self",
  "href": "https://<>.hcm.us6.oraclecloud.com:443/hcmCoreApi/resources/11.12.1.0/emps",
  "name": "emps",
  "kind": "collection"
  }
  ]
 

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!


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