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:
- Use paging=snapshot approach (more details on Server Pagination)
- Don't use $orderby clause.
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