I am trying to get the list of all files contained in a sharepoint folder, however, because there is more than 5000 files I cannot get any results.

I understand that I cannot query more than 5000 items. Then I tried to limit the number of elements returned by my query but unsuccessfully (I tried to do like the getbytitle() function)

When there is less than 5000 files, I successfuly get the list of files in a folder when I run this query:


But when there is more than 5000 files, I cannot have any results. I tried this:



It seems that the parameters 'limit' and 'top' are just ignored by sharepoint and I always get the "SPQueryThrottledException" error.

Is it possible to do what i'm trying to do with the sharepoint API?

2 Answers 2


You could use data.d.__next to get the next items for overcome the List View Threshold Limitation:

<script type="text/javascript">
 var url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('DocumentList')/items?$top=1000";
var response = response || [];  // this variable is used for storing list items
function GetListItems(){
    return $.ajax({
        url: url,  
        method: "GET",  
        headers: {  
            "Accept": "application/json; odata=verbose"  
        success: function(data){
            response = response.concat(data.d.results);
            if (data.d.__next) {
                url = data.d.__next;
        error: function(error){


Rest to read more than 5000 items from document library

  • 1
    This does not seem to work for files - see the original question, which states "It seems that the parameters 'limit' and 'top' are just ignored by sharepoint". The question was about files, not about items.
    – cweiske
    Oct 4, 2022 at 15:56

You should include a filter on an indexed column so that it retrieves less than 5000 items

  • 2
    Thanks for your reply. Do you have examples on how to filter with this query? The query below should return only one row but I still run into the 'SPQueryThrottledException' error: web/GetFolderByServerRelativeUrl('Shared%20Documents")/Files?$expand=Name&$filter=Name eq '3210988001-2021020075.1'"
    – Augustin
    Mar 29, 2021 at 16:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.