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

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: