SAP Knowledge Base Article - Public

3591291 - When using Snapshot-Based Pagination to retrieve data, the results differ between the two attempts.

Symptom

You are trying to get data from SuccessFactors using the OData API with Snapshot-Based Pagination, and you notice that when you request the next page twice within 15 minutes, the data differs in these two instances.

Environment

SAP SuccessFactors HCM

  • OData API

Reproducing the Issue

You use below URL call API, and you use "next" URL to call the next page. You test twice but the results are different.
/odata/v2/PerPerson?$filter=lastModifiedDateTime ge datetime'2001-07-01T17:19:28'&paging=snapshot

Cause

Expected behavior.

 

Resolution

Please add "$orderby=entity", only when you add this parameter, the records can remain stable.

Otherwise, each time you call the second page, the order of the data will appear randomly.

See Also

Snapshot-Based Pagination

Keywords

 Sorting, Snapshot, Random occurrence sequence, Next page navigation  , KBA , LOD-SF-INT-ODATA , OData API Framework , How To

Product

SAP SuccessFactors HCM Core 2411