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

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.

SuccessFactors

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:

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

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:

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 , Integrations , Problem