How to get values from people field of a list using REST API ?

Get values from people or group field of a list using REST API:

Generally, when we try to get value from a people or group field then we get id of people value/id of user. Id of User is coming as same as we get when we try to get value from lookup field. 


The below is the Image of People Field - Contractor Name (internal name-Contractor_x0020_Name) from list - User Data 
Problem REST APL
url = _spPageContextInfo.webServerRelativeUrl + "/_api/web/lists/getbytitle('User Data')/items"

Solution REST APL
url = _spPageContextInfo.webServerRelativeUrl + "/_api/web/lists/getbytitle('User Data')/items?$select=*,Contractor_x0020_Name/Title&$expand=Contractor_x0020_Name"


$.ajax({
 url: url,
 type: "GET",
 headers: { "ACCEPT": "application/json;odata=verbose" },
 success: function(data)
   console.log(data);
    data.d.results.forEach(function(res){
        console.log(res);
    });
 },
 error:  function(data){
   console.log(JSON.stringify(data));
 }
});

Output:

When we use Problem REST API then result as shown below

When we use Solution REST API then result as shown below



 or






Comments

Post a Comment

Popular posts from this blog

Get list item entity type full name of a SharePoint list using REST API

Image
Get list item entity type full name of a SharePoint list using REST API : Follow the below steps to get ListItemEntityTypeFullName which must required for adding/updating items/records to the server or the SharePoint list. 1) First user/developer need logged in to the SharePoint site and then copy any of below URL/API. 2) Replace the _spPageContextInfo.webAbsoluteURL or siteurl (absolute URL) with the URL of you site for example. siteurl = https://testcompany.sharepoint.com/sites/testsite1 3) and replace SharePoint ListName = Payments or you original list name 4) Finally hit or place the complete URL/API API = https://testcompany.sharepoint.com/sites/testsite1/_api/Web/Lists/getbytitle('Students')/ListItemEntityTypeFullName into the browser search bar/box and click on enter button from keyboard then you will able to see output as shown in Output below   _spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/getbytitle('ListName')/items?select=EntityTypeFullName OR s...
Read more

Get SharePoint list name by GUID

Image
 Get SharePoint list name by GUID in jQuery: Use the below snippet code to get the name of list by using listGuid . To do so replace the below list guid with your SP list GUID. var listGuid = "aa4774cf-oa71-83e4-6a67-01b53d5a7y6i2";//use your own SP site list guid getlistNameByGUID(listGuid); function getlistNameByGUID(guid) { $.ajax({         url: _spPageContextInfo.siteAbsoluteUrl + "/_api/Web/Lists(guid'"+listGuid+"')",         method: "GET",         headers: { "Accept": "application/json; odata=verbose" },         success: function (data) {              console.log(data.d.Title);         },         error: function (e) {             console.log(e)         }   }); } Output: Company//list name of my sp site  Was this helpful? Comment you suggestions and share it with yo...
Read more

Get Current Web Logged In User of SharePoint Site in jQuery

Get Current web logged in User of a SharePoint site in jQuery: Use the below snippet and just replace the jQuery library URL and run on you SharePoint page. <script src="../Assets/Jquery/jquery-1.9.1.min.js"></script> <script > function getCurrentLogInUser(){ $.ajax({     url: _spPageContextInfo.webServerRelativeUrl + "/_api/web/currentuser",     type: "GET",     async:false,     headers: { "Accept": "application/json;odata=verbose" } }).success(function( data ){     console.log( data );     console.log( data.d.Title ); }).error(function(e){     console.log( e ); }); } getCurrentLogInUser(); </script> Output:
Read more