Cannot pull data from multiple entities

[diazharizky_er]

Hello everyone, I'm a software developer of an HR tech company from Singapore

I'm currently helping my client to integrate their SAP SF with our platform, we have a feature to sync the employee data periodically so they can manage the data only from SF

But now I'm having a hard time to pull a set of employee fields from SF OData API which is combination of multiple entities, for example I need to pull

• userId from User entity
• personIdExternal from PerPerson entity
• department, division, jobTitle from EmpJob entity

I expected to pull the data in one API call, I've tried to use /odata/v2/User?$select=userId&$expand=PerPerson($select=personIdExternal)&$expand=EmpJob($select=department,division,jobTitle) but this seems to be not working

I really appreciate if you can help me on this

Thanks,

[Yogananda]

diazharizky_er

can you check once the metadata which contains all your fields.. I am hoping some fields might be missing.

/odata/v2/User/$metadata