Get User Profile Properties Of All Users Using REST

Reshma Bhalekar

10 Comments

Join the conversation! Your thoughts help the community grow.

Swastik Das7y ago
How to get rid of Name = undefined?
Swastik Das7y ago
Firstly Thanks a ton for the post !This returns all the user names but also returns Name = undefined !!
- Reshma Bhalekar7y ago
  Hi Swastik, Can you please debug and check what data you are getting in "data.d"
amod tiwari8y ago
Hi Rashmi, I was looking for such feature to get all employees who are recently hired in organization, I think we can check for created date value to filter out them on basis of last 30 days. Also I didn't used REST API earlier, Not sure how to use it to display this result. Could you please help me to get created users in last 30 days and how to implement it on our site pages in office 365. Thanks
- Reshma Bhalekar8y ago
  Hi Amod, You can use above code to get the Joining date of that user, make sure that you have joining date property. If number of users is large then probably this is not the correct way as it will take time.
- amod tiwari8y ago
  Hi Rashmi, Thanks for your response. I have used this code successfully but i need office location/department value which is not found in user profile. Is it any way to get it. Because i need to put filter on office location as my company has more than 200 locations in world. Should i go with MS graph or this code can get AD details which are not mapped to user profile. Thanks for help.
Harsh D8y ago
Can i get specific propertyName ?
- Reshma Bhalekar8y ago
  Hi Harsh, In GetUserProperties function, data.d.UserProfileProperties.results will return array of all user profile properties. you can take any property using that array. For example: data.d.UserProfileProperties.results[55].Value; will return location of that particular user. Expand the result array in console and you will get all properties.
Reshma Bhalekar8y ago
Thank you Naresh....
Naresh Singhal8y ago
Very Good Explained Madam.......@Rashmi

Hi All,

In this blog, we will see how to fetch user profile properties of all users from SharePoint online.

Many times we need to display specific properties of all users programmatically, so for that, I have Rest API to access User profiles properties. In this case, if properties are mapped to an Active directory then the available data is correct and dynamic.

First we need to add jQuery reference in our file

<script src="/SiteAssets/JS/jquery.min.js"></script>

SiteUsers is used to get all the users of SharePoint Online site.

<script>
$.ajax({
asynch: false,
url: "your site url /_api/Web/SiteUsers",
method: "GET",
headers: {
"Accept": "application/json; odata=verbose"
},
success: function(data) {
if (data.d.results.length > 0) {
for (var i = 0; i < data.d.results.length; i++) {
var accountName = data.d.results[i].LoginName;
GetUserProperties(accountName.replace("#", "%23"));
}
}
},
error: function(x, y, z) {
alert(JSON.stringify(x) + '\n' + JSON.stringify(y) + '\n' + JSON.stringify(z));
}
});

GetUserProperties function is used to get the user profile properties of specific users in SharePoint site.

function GetUserProperties(user) {
$.ajax({
asynch: false,
url: "your site name/_api/SP.UserProfiles.PeopleManager/GetPropertiesFor(accountName=@v)?@v='" + user + "'",
method: "GET",
headers: {
"Accept": "application/json; odata=verbose"
},
success: function(data) {
console.log("Name = " + data.d.DisplayName);
//Similarly you can get remaining properties
console.log("-------------------");
},
error: function(data1) {
alert("ERROR");
}
});
} < /script>

Thank You..