How to get List data from SharePoint using REST.

Question

Hello, How to get list data from sharepoint list using REST. I have searched multiple blogs but it is not working and which library refrenses we want to use when writing REST . i have full confused when writing REST,

Harsh D · Answer

Hello Suresh, This code will help you to fetch data from Sharepoint list using REST and Display in Table Format with Search You need to Refer angular.min.js file as shown below This is the Rest url that is formed https://sharepointsite/_api/web/lists/getByTitle('Students')/items?$select=Name,LastProject,IsTerminated,Author/Title&$expand=Author/ID" Do connect with me for any queries . var spApp=angular.module('spApp',[]); spApp.controller('spListCtrl',function($scope,$http){ $http( { method: "GET", url:"https://sharepointsite/_api/web/lists/getByTitle('Students')/items?$select=Name,LastProject,IsTerminated,Author/Title&$expand=Author/ID", headers:{"Accept":"application/json;odata=verbose"} } ).success(function(data,status,headers,config){ $scope.xData=data.d.results; console.log(data.d.results); }).error(function(data,status,headers,config){ }); }); Name LastProject Is Terminated Author {{x.Name}} {{x.Project}} {{x.IsTerminated}} {{x.Author.Title}}

Bhuvanesh Mohankumar · Answer

This article is clear and guide you better, Complete basic operations using SharePoint 2013 REST endpoints https://msdn.microsoft.com/en-us/library/office/jj164022.aspx Mark as answer, if helpful.

Manpreet Singh · Answer

Here you go Suresh. Link:-http://www.c-sharpcorner.com/article/how-to-get-all-list-items-of-a-list-using-rest-api-in-sharepoint-online-and-offi/ Let ms know if you want some additional features, I will add it to my code.

Amit Kumar · Answer

Hi dear, Please follow the below link. http://www.nothingbutsharepoint.com/2011/12/28/got-rest-querying-sharepoint-list-data-using-rest-services-client-side-part-1-aspx-2/ https://www.plusconsulting.com/blog/2013/05/crud-on-list-items-using-rest-services-jquery/ Regards, Amit Kumar

How to get List data from SharePoint using REST.

Answers (4)