How to get more than 10000 records while querying ODATA API entities from success factors ?

[Former Member]

How to get more than 10000 records while querying ODATA API entities from success factors ?

We are doing the integration with success factors using SAP PO.

[KC]

To query the data using OData API in SuccessFactors where the data result set has more than 1000 records, we need to specify a page size.

The max data returned in one OData API call is 1000 results.

You can use client side pagination concept to fetch the remaining records by using $top and $skip

Or

You can use the recent snapshot based pagination and loop over $skiptoken to get all the remaining pages

eg: first page will be like below

https://<api_url>/odata/v2/<entity>?$format=json&paging=snapshot&customPageSize=<specify between 400 to 600>

This would return _next in the result set which will contain the $skiptoken, use this to obtain the next page

https://<api_url>/odata/v2/<entity>?$format=json&paging=snapshot&customPageSize=<specify between 400 to 600>&$skiptoken=<value>

Regards,

Karthick C

[siddharthrajora]

it would split into multiple queries ie of 200 each, there is a limitation in one query you can get

ie to say, you can query wild select query of the objects or count of personnal number in the system, but system internally will fire query in batches of 200 ie packet size but you can get your result depending on performance etc

what is your query?