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
- Open Postman/Integration center
- Build this query: https://<api_url>/odata/v2/User?$select=manager/userId,userId&$expand=manager&$filter=status eq 'f'
- 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
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