SharePoint rest query item retrieving default count is 100

SharePoint rest query item retrieve default count is 100.

https://$DOMAIN/$SITE/_api/web/Lists/getByTitle(‘$LIST’)/Items

 

You can add top parameter to get more items but you have to be careful because this can make some performance impact.

https://$DOMAIN/$SITE/_api/web/Lists/getByTitle(‘$LIST’)/Items?$top=1000

However there is a 5000 threshold for the query.

 

Or you can utilize next query url.

success: function (data) {

if (data.d.__next) {
url = data.d.__next;
GetItems();
}

}

Reference : http://sharepoint.stackexchange.com/questions/74777/list-api-get-all-items-limited-to-100-rows

 

 

Leave a comment