SAP Knowledge Base Article - Public

2779187 - userIdNav is not getting expanded when query operation is performed on EmployeeTime ODATA Entity

Symptom

userIdNav is coming as null when query operation is performed on EmployeeTime ODATA Entity

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

Environment

SuccessFactors

Reproducing the Issue

1. Run the below query:

https://apisalesdemo4.successfactors.com/odata/v2/EmployeeTime?$format=json&$select=lastModifiedDate,userIdNav/userId&$expand=userIdNav&$filter=externalCode%20eq%20%27d9bf1dfc1d5a4546a7be0cacb35892fc%27

2. The output is as below, userIdNav is coming as null:

 Data.PNG

Cause

Necessary RBP Permissions are missing for the user executing the query.

Resolution

1. If you want to fetch EmployeeTime.userId -> The user for which the absence/etc is determined --> the below permissions are required

  • Manage Integration Tools --> Allow Admin to Access OData API through Basic Authentication
  • Metadata Framework --> Admin access to MDF OData API

2. If you want to fetch EmployeeTime.userIdNav.userId -> The user that created the absence for EmployeeTime.userId

   For EmployeeTime.userIdNav.userId the login user needs certain additional permissions:

  • Metadata Framework --> Admin access to MDF OData API
  • Manage Integration Tools --> Allow Admin to Access OData API through Basic Authentication
  • General user permission -->Check the boxes "Company info access" and "user search"
  • Manage user --> Employee Export

Note: The permission group should not be restricted to a target population.

3. Once the above permission is granted to the API User, re-run the query. userIdNav would be expanded

    Query:

https://apisalesdemo4.successfactors.com/odata/v2/EmployeeTime?$format=json&$select=lastModifiedDate,userIdNav/userId&$expand=userIdNav&$filter=externalCode%  20eq%20%27d9bf1dfc1d5a4546a7be0cacb35892fc%27

    Output:

Output.PNG

Keywords

usserIdNav not getting expanded, EmployeeTime, Admin access to MDF OData API, Allow Admin to Access OData API through Basic Authentication, Company info access, user search, employee export , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Core 1902