SAP Knowledge Base Article - Public

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

Symptom

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

Environment

SAP SuccessFactors Integration

  • Odata API

Reproducing the Issue

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

Cause

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.

Resolution

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

Keywords

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

Product

SAP SuccessFactors HXM Suite all versions