Hi,
I'm trying to get worker information, their position and their manager however I'm having difficulties in getting the manager data in the same query and wonder if there is good way in achieving it in one single query?
As of now I have 2 queries where I can merge the information in the background but would like to achieve it in 1 query. Here us what I have so far:
Get worker and their position (simplified where I have removed the select statement):
/data/Workers?$expand=EmployeesV2,ContractorsV2,PositionsV2&$filter=ObjectId ne 00000000-0000-0000-0000-000000000000 and WorkerStatus ne Microsoft.Dynamics.DataEntities.HcmWorkerStatus'Terminated'
Get workers and their manager:
/data/EssWorkerManagerRelations?$expand=Manager($select=AadUserPrincipalName,AadUserObjectId,Name),Worker($select=AadUserPrincipalName,AadUserObjectId,Name)
Thanks in advance.