Sharepoint 2013 REST API not returning all items for a list

rest sharepoint sharepoint-2007 sharepoint-2013
leopik picture leopik · Sep 26, 2014 · Viewed 34k times · Source

The title states my problem quite exactly. If I try to gather all 400+ items from a list using sharepoint's REST API, I only get first 100.

I have read http://msdn.microsoft.com/en-us/library/office/dn292552(v=office.15).aspx and in the "Working with list items by using REST" part, they're stating that

The following example shows how to retrieve all of a list’s items.

url: http://site url/_api/web/lists/GetByTitle(‘Test')/items

method: GET

headers: ...

I have highlighted word all, because that's not what I'm getting ...

Am I missing something? Is there some option I should disable/enable to gett truly all items?

Thanks

Answer

Christophe picture Christophe · Sep 26, 2014

The limitation is due to server side paging.

A workaround is to retrieve 100 items at a time, or override the limitation by entering a count of items:

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

Note that there is also a threshold at 5000.

Related questions

How to access a sharepoint site via the REST API in Python?

I have the following site in SharePoint 2013 in my local VM: http://win-5a8pp4v402g/sharepoint_test/site_1/ When I access this from the browser, it prompts me for the username and password and then works fine. However …

Read More
Adding list items with SharePoint 2013 REST API

I'm trying to add a new item in a existing list using SharePoint 2013 with the REST API. There is pretty good documentation for this here: http://msdn.microsoft.com/en-us/library/jj164022(office.15).aspx#ListItems The list I am trying …

Read More
SharePoint REST Get User Title in a single REST query

I have a list which has a "People and Group" column. when I query the rows using REST, I get user Ids listed in this column. I found this article which will help me in converting each id to a …

Read More