Latest Posts

Get All Items in SharePoint using REST API

The example in this topic show how to use REST API to Get All Items in SharePoint

REST-API is based on OData (Open Data) Protocol and hence it doesn't require any dll or JS library to run the commands on the SharePoint objects.
REST-API calls require proper end-point URL and proper Header implementation in your REST call.

I have added below Html in Content Editor webpart. You can replace MainFunction with your actual method name.
<button onclick="MainFunction();" type="button">Click me</button>
And below references in Script Editor Webpart. ScriptFile.js is a JavaScript file where you can keep below function i.e. your actual logic.
<script src="https://MyServer/sites/SiteCollection/style library/js/ScriptFile.js"></script>
Once you are done with setting your page, click on the button and your method should get executed.

function GetAllListItems() {
$.ajax
({
// _spPageContextInfo.webAbsoluteUrl - will give absolute URL of the site where you are running the code.
// You can replace this with other site URL where you want to apply the function
// Optionally you can append "$top=10" to restrict the results to 'n' number of rows only.
// e.g. - url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('List Name')/items$top=10",
// "$select" can be used, if only a defined colmns need to be returned in result set
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('List Name')/items?$select=Title,LinkFilename",
type: "GET",
headers:
{
// Accept header: Specifies the format for response data from the server.
"Accept": "application/json;odata=verbose"
},
success: function (data, status, xhr) {
var dataresults = data.d.results;
for (var i = 0; i < dataresults.length; i++) {
alert(dataresults[i]["LinkFilename"]);
}
},
error: function (xhr, status, error) {
console.log("Failed");
}
});
}

Thank you for reading this article. This code was tested in SharePoint 2013

Page URL:

Name:

Name is a mandatory field

Email:

Email is a mandatory field
Email format is not corrent

Suggestion:

Suggestion is a mandatory field