In this post we will discuss how we can get list item count using SharePoint 2013 Rest API as well as using ECMAScript object model. I have a SharePoint 2013 list and I have added a web part page and in that web part page on a button click I am trying to retrieve list item count by using Rest API.
Related Posts:
– SharePoint 2013 Get current user group collection through Rest api
– Add Bulk Users to SharePoint 2013 Group from Excel using SharePoint 2013 REST API
Get List Item Count using Rest API:
Put the below code in a script editor web part.
<script src=”http://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js”></script>
<script>
$(function(){
$(“#btnClick”).click(function(){
var requestUri = _spPageContextInfo.webAbsoluteUrl + “/_api/web/lists/getbytitle(‘MyTestList’)/items”;
$.ajax({
url: requestUri,
type: “GET”,
headers: {
“accept”:”application/json;odata=verbose”,
“content-type”: “application/json;odata=verbose”,
“X-RequestDigest”:$(“#_REQUESTDIGEST”).val()
},
success: onSuccess,
error: onError
});
function onSuccess(data) {
var itemsCount = data.d.results.length;
alert (itemsCount);
}
function onError(error) {
alert(JSON.stringify(error));
}
});
});
</script>
<input type=”button” id=”btnClick” value=”Count List Items”/>
Get List Item Count using ECMAScript client object model:
We can also retrieve list item count using ECMAScript client object model. Put the below code inside a script editor web part.
<script type=”text/javascript”>
var clientContext = null;
var web = null;
ExecuteOrDelayUntilScriptLoaded(Initialize, “sp.js”);
function Initialize()
{
clientContext = new SP.ClientContext.get_current();
web = clientContext.get_web();
var list = web.get_lists().getByTitle(“MyTestList”);
var camlQuery = new SP.CamlQuery();
var q = “<View><Query><Where><Eq><FieldRef Name=’Title’ /><Value Type=’Text’>abc</Value></Eq></Where></Query><RowLimit>0</RowLimit></View>”;
camlQuery.set_viewXml(q);
this.listItems = list.getItems(camlQuery);
clientContext.load(listItems, ‘Include(Title)’);
clientContext.executeQueryAsync(Function.createDelegate(this, this.onListItemsLoadSuccess),
Function.createDelegate(this, this.onQueryFailed));
}
function onListItemsLoadSuccess(sender, args) {
var count = this.listItems.get_count();
alert(count);
}
function onQueryFailed(sender, args) {
alert(‘request failed ‘ + args.get_message() + ‘\n’ + args.get_stackTrace());
}
</script>
Hope this will be helpful.
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.
You May Also like the Following SharePoint Online Tutorials:
