Skip and top parameter in the Sharepoint API

Question

We are trying to query the Sharepoint API. We are using the below query to get the top 5000 and it works.

  https://abc.123.org/sites/js/project/_api/web/lists/GetByTitle('S%20Codes')/items?$top=5000

But breaks if we try to get more than 5000 records. We also tried to use the skip in the query parameter to get the next 5000 records and it is not working

https://abc.123.org/sites/js/project/_api/web/lists/GetByTitle('S%20Codes')/items?$skip=5000&$top=5000

How to skip the first set of records and get the next set.

Rohit Waghela Rohit Waghela · Accepted Answer · 2018-09-01T15:40:16

The $skip parameter does not work in SharePoint 2013 for list items. Reference- https://sharepoint.stackexchange.com/questions/126565/issue-with-skip-in-rest-api

However, the easiest way I have found is to use SharePoint PnP.js Refer this - https://github.com/SharePoint/PnP-JS-Core

You just need to add reference to jQuery and PnP.js library files to start working with it.

Refer below code. It will skip first 1000 records and will fetch next 1000 record set:

<script type="text/javascript" src="/sites/mySiteName/SiteAssets/Javascripts/jquery-1.11.0.min.js"></script>
<script type="text/javascript" src="/sites/mySiteName/SiteAssets/Javascripts/pnp.js"></script>

<script type="text/javascript">

    $(document).ready(function(){
        $pnp.sp.web.lists.getByTitle("S%20Codes").items.skip(1000).top(1000).get().then(successHandler, FailureHandler);

        function successHandler(response){
            if(response.length > 0){
                console.log(response.length); 
            }
        }

        function FailureHandler(err){
            // failure handler code
        }
    });

</script>

Skip and top parameter in the Sharepoint API

2 Answers