SAP Knowledge Base Article - Public

2880788 - Same query and different results to different users - SAP SuccessFactors Odata API


Different users (one admin and another non-admin) run a query and get different results. Admin user get more results than non-admin user.


SAP SuccessFactors Integration

  • Odata API

Reproducing the Issue

Run a query with $top=xxxx and $orderby clause with non-admin user and admin user.


Expected behavior. For non-admin users, duplicated results is removed by platform.

Only this time the orderby clause make it happens more frequently in the first page of 1000 records.


There are two ways to avoid the behavior:

  1. Use paging=snapshot approach (more details on Server Pagination)
  2. Don't use $orderby clause.

See Also

SAP SuccessFactors HCM Suite OData API: Developer Guide


query different results; query admin user; query non-admin user; orderby; , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-API , API & Adhoc API Framework , Problem


SAP SuccessFactors HXM Suite all versions