Issue with $skip in REST API

Question

Here is a sample list i am using

I am testing some REST filters in the browser directly and checking the XML feed returned by the REST request. Below is the REST query which I used to get the first two items of the list and this works perfectly.

http://sharepointsite/sites/POC/_api/web/lists/getbytitle('samplelist')/items?$filter=Designation eq 'Developer' and Company eq 'Some Corp'

Now I used $top=1 at the end which also worked well and returned only the first item.

http://sharepointsite/sites/POC/_api/web/lists/getbytitle('samplelist')/items?$filter=Designation eq 'Developer' and Company eq 'Some Corp'&$top=1

However, instead of $top=1 when I use $skip=1, the feed still returns the first two items.

http://sharepointsite/sites/POC/_api/web/lists/getbytitle('samplelist')/items?$filter=Designation eq 'Developer' and Company eq 'Some Corp'&$skip=1

Where is this going wrong ?

UPDATE

Apparently this has been moved to the "investigation queue". Here is a similar question.

Answer 1

The $skip parameter does not work in SharePoint 2013 for list items. It only works for collection of data (like list collections, etc).

Paging using REST/OData with SP 2013

A workaround is to use __next property which gives you the next URL you should query.

https://stackoverflow.com/questions/18964936/using-skip-with-the-sharepoint-2013-rest-api

Answer 2

So the issue is with URL encoding, This url works:

https://[YOURSITE]/_api/web/lists/getbytitle('updates')/items?%24skiptoken=Paged%3dTRUE%26p_ID%3d2&%24top=2

But this decoded version does not:

https://[YOURSITE]/_api/web/lists/getbytitle('updates')/items?$skiptoken=Paged=TRUE&p_ID=2&$top=2