I'd like to get users from a certain Department. I've been looking for a while and haven't found whether it's possible or not ... I saw the http://spsite/_api/web/siteusers URL but it doesn't give us the Department.
1 Answer
You can query the user information list to get all the users for a site. Use: http://siteUrl/_api/web/lists/getbytitle('User Information List')/items?$filter=Department eq 'Value'. This will return all the users with the department Value for that particular site.
-
This returns items from a list where the column
Departmentequals to theValue. As long as there's not an OOTB SharePoint list including all users of the environment, this is useless.– moeJul 30, 2015 at 5:27 -
What do you mean? User Information List is a hidden list available for every SharePoint site. Its how users and groups are managed in SharePoint.– AkhoyJul 30, 2015 at 5:28
-
-
@uberz91: User Information List contains information of only users which have logged in at least one time, user added in any sharepoint groups or user used in any User Field. So In Short, it will not contains all the users and that's why it is not appropriate way to get all the users.You can check this by creating one blank site collection and first check UserInformationList without doing anything in the site. You will get only one entry on that list that is site collection administrator Jul 30, 2015 at 9:00
-
1Fantastic. I've tested it and it works. However, I had a little issue since I have French names on my lists, so I had to find another URL to get the list results.
http://siteUrl/_api/web/SiteUserInfoList/items?$filter=Department eq 'Value'Thanks a lot !!– Chris23Jul 30, 2015 at 12:52
Department