Hit "exceeds the list view threshold" when using SharePoint API GetListItemChangesSinceToken

%3CLINGO-SUB%20id%3D%22lingo-sub-2154414%22%20slang%3D%22en-US%22%3EHit%20%22exceeds%20the%20list%20view%20threshold%22%20when%20using%20SharePoint%20API%20GetListItemChangesSinceToken%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2154414%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20question%20about%20using%20the%20SharePoint%20API%26nbsp%3BGetListItemChangesSinceToken.%20In%20my%20program%2C%20I%20used%20this%20API%20to%20get%20the%20items%20of%20the%20list%20with%20token%20so%20that%20I%20can%20get%20the%20changes%20of%20the%20list%20with%20the%20token%20later.%20However%2C%20I%20encounter%20an%20issue%20when%20the%20items%20of%20the%20Document%20Library%20is%20more%20than%205000%20(It%20seems%20that%20it's%20the%20default%20setting%20in%20SharePoint%20in%20order%20to%20prevent%20the%20performance%20issue).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20error%20message%3A%3C%2FP%3E%3CP%3E%22The%20attempted%20operation%20is%20prohibited%20because%20it%20exceeds%20the%20list%20view%20threshold%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20use%20%22rowLimit%22%20supported%20by%20this%20API%20and%20set%20the%26nbsp%3Bsearching%20criteria%20in%20the%20%22query%22%20part.%20However%2C%20it%20still%20encountered%20the%20same%20issue.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMay%20I%20know%20if%20there's%20a%20way%20to%20solve%20it%20so%20that%20I%20can%20get%20the%20token%20and%20the%20items%20for%20the%20Document%20Library%20with%20more%20than%205000%20items%3F%20Here%20are%20the%20directions%20I%20think%20that%20can%20solve%20the%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Any%20other%20parameters%20in%20the%20request%20that%20I%20can%20set%20to%20overcome%20this%20problem.%3C%2FP%3E%3CP%3E2.%20Any%20other%20searching%26nbsp%3Bcriteria%20in%20the%20'query'%20part%20in%20the%20request%20that%20I%20can%20use%20to%20overcome%20this%20problem%3C%2FP%3E%3CP%3E3.%20Any%20other%20setting%20in%20the%20SharePoint%20side%20that%20can%20fix%20this%20issue.%20Or%20programmatically%20change%20the%20setting%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a question about using the SharePoint API GetListItemChangesSinceToken. In my program, I used this API to get the items of the list with token so that I can get the changes of the list with the token later. However, I encounter an issue when the items of the Document Library is more than 5000 (It seems that it's the default setting in SharePoint in order to prevent the performance issue).  

 

Here's the error message:

"The attempted operation is prohibited because it exceeds the list view threshold"

 

I tried to use "rowLimit" supported by this API and set the searching criteria in the "query" part. However, it still encountered the same issue. 

 

May I know if there's a way to solve it so that I can get the token and the items for the Document Library with more than 5000 items? Here are the directions I think that can solve the issue.

 

1. Any other parameters in the request that I can set to overcome this problem.

2. Any other searching criteria in the 'query' part in the request that I can use to overcome this problem

3. Any other setting in the SharePoint side that can fix this issue. Or programmatically change the setting? 

 

Thank you for your help.

 

 

 

 

0 Replies