SAP Knowledge Base Article - Public

3355196 - ODATA API not fetching Manager details from navigation User/manageruserNav


You're trying to fetch Manager details of an Inactive user but its API fetching null/no data although Manager is present in EC.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


  • SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Open Postman/Integration center
  2. Build this query: https://<api_url>/odata/v2/User?$select=manager/userId,userId&$expand=manager&$filter=status eq 'f'
  3. For some inactive users, manager user Id is null.


By default, Odata api entity Manager (Manager User) entity fetches only active managers, it will not fetch If manager is Inactive.


Need to apply filter to Status field of Manager entity to fetch Inactive Managers.
Query: https://<api_url>/odata/v2/User?$select=manager/userId,userId&$expand=manager&$filter=(status eq 'f' and manager/status eq 'f')

Above query will fetch inactive Managers details.

See Also

166571 - How to query inactive users on User entity - OData API ( 


ODATA, User, Manager, Manager UserId, null, blank, Fetch Manager Details, Inactive Manager, Inactive user, API. Status.  , KBA , LOD-SF-INT-ODATA , OData API Framework , Problem


SAP SuccessFactors HXM Suite 2305