SAP Knowledge Base Article - Public

2489065 - API fetches 1000 records only, When more are expected

Symptom

API calls returns the first 1000 records only.

Environment

  • Successfactors HCM Suite
  • 3rd Party API Clients

Reproducing the Issue

Run an API call with over 1000 records expected to return

Cause

Expected Behavior

Resolution

To get the next set of records, there is a link at the bottom of the response XML where you will find a link similar to the one shown below:

In the response XML:

{ "d" : { "results" : ................ "__next" : "http://<hostname>/odata/v2/User?$format=json&$skiptoken=eyJzdGFydFJvdyI6NSwiZW5kUm93IjoxMH0%3D" } }

 Or

http:// <hostname>/odata/v2/User?$format=json&$skiptoken=eyJzdGFydFJvdyI6NSwiZW5kUm93IjoxMH0%3D

This link would be available in the bottom of the Response XML returned.

Upon using this link, you will be getting the remaining records after 1000.

There is no way to fetch more than 1000 records in one page via API.

Keywords

API, 1000, 1000 Records, Missing Data , KBA , LOD-SF-INT-API , SF API & Adhoc API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Core 1702