SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

  • SAP SuccessFactors HXM Suite
    • ODATA API

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.

Cause

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

Resolution

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 (sap.com) 

Keywords

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

Product

SAP SuccessFactors HXM Suite 2305