SharePoint 2013 REST API call Threshold limit

Question

I am fetching data from a list using REST call. I have added filter query in the REST url also the the column on which filter operation id done is set as Indexed column in the list. The no of items returned is more than 5000, so it is throwing threshold/throttling error. is there any solution to overcome this apart from increasing the threshold value from CA.

Thanks.

Answer 1

You can use in built SP Rest api paging. First limit the result = using top key then you can page using data.d.__next key . Sample snippet

function getReport() {
    $.ajax({
        url: queryUrl,
        method: "GET",
        headers: {
            "accept": "application/json; odata=verbose"
        },
        success: function(data) {
            try {
                $(data.d.results).each(function(index) {
                   //process your logic
                });
                //Pagging
                if (data.d.__next) {
                    queryUrl = data.d.__next;
                    getReport();
                } else {                
                 //last page       
                }
            } catch (err2) {                 
                console.log(JSON.stringify(err2));
            }
        },
        error: function(jQxhr, errorCode, errorThrown) {            
            console.log(errorThrown);
        }
    });
}

hope it helps