I have a source list which has the EmployeeIDs of some of the employees and I need to look these up in SharePoint to get other details of the user and enrich the existing list by mapping the EmployeeIDs with their account name so that other details can be pulled out later.
I am able to get all the user properties using a REST get request that looks something like this:
The EmployeeID is a custom property that is embedded in an array inside "UserProfileProperties" object inside the JSON returned by the above call.
I am looking for a way to query the user profiles to get the specific profile of the user having "EmployeeID" = "XXXXX"
Please leave a comment if you have something in mind which might lead me in some direction.
If nothing works out, then I'll be crawling through the whole hierarchy and creating a mapping of account names and employee IDs.