Symptom
Unable to find Manager name while querying oData EmployeeCollection with respect to employee data in C4C.
Environment
- SAP Cloud for Customer
Reproducing the Issue
(You are trying to obtain data stored in the manager name field of People - Employees workcentre)
1. Open oData console or any other oData Querying tool.
2. Query data using the EmployeeCollection - https://my<tenantID>.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/EmployeeCollection .
3. Notice that Querying Employee Master Data - EmployeeCollection does not yield manager name in the employee data results.
Cause
You are using incorrect Employee collection.
Resolution
In order to obtain the manager name you will have to use the EmployeeBasicDataCollection as shown below -
https://my<tenantID>.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/EmployeeBasicDataCollection
The manager name obtained in the results will look as shown below -
<d:ManagerFormattedName>Given Manager Name</d:ManagerFormattedName>
Keywords
oData, Manager name, EmployeeCollection, employee data , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem