SharePoint Asked on January 2, 2022
I have an application I built in SharePoint Online which uses REST API queries to pull records out of a SharePoint list which has 400k records. The list has an indexed column and for the most part the values returned in the index column never exceed 5k. The front end has a drop down with the values available in the indexed field. Upon selecting a value the results are returned. This works great.
The issue I’m seeing is that it is possible that occasionally one of the indexed values will exceed the 5k limit which breaks the query if you are querying on that value. My initial thought was that if I go back into the data and reduce the count to below 5k on that index that the application would then allow me to query on that value again.
In my test case, I exceeded the 5k limit on one of the indexed values, breaking the application when I query on that value. I then removed all of the records for that indexed value in the source list, but the application still throws the SPQueryThrottleException error even though no records for that index exist. Is there a way around this? Will that indexed value be broken forever once it’s exceeded?
If I had ran into such an issue on SharePoint on-prem, the first thing to try would be to CA > Manage Web application > General Settings in Top ribbon > Resource throttling > Increase the value from 5K to 20K for general audience. Not sure if it works the same way with SPOnline.
Also, in general, if the query is breaking because it is expected to return more than 5K items, I would explicitly code the query to never return more than 5K items. And then, there is always the chance of implementing some variety of paging in the application or maybe running a follow-up query to get the rest of items!
Answered by Nisarg on January 2, 2022
1 Asked on October 28, 2020 by tezz-chaudhary
1 Asked on October 24, 2020 by leebongee
1 Asked on October 22, 2020 by snowburnt
2013 internal server error reporting services sharepoint enterprise
0 Asked on October 12, 2020 by kurt-cooney
1 Asked on October 6, 2020 by rajat-raj
1 Asked on October 4, 2020 by user615993
1 Asked on October 3, 2020 by jl421
1 Asked on September 28, 2020 by robert
2 Asked on September 23, 2020 by chetan
1 Asked on September 19, 2020 by plouie21
sharepoint addin sharepoint designer sharepoint enterprise sharepoint foundation
1 Asked on September 17, 2020 by f_gulay
approval process content approval designer workflow workflow
1 Asked on September 6, 2020 by sharepointman
1 Asked on September 3, 2020 by fjay
2013 document library sharepoint library sharepoint permissions sharepoint server
2 Asked on August 31, 2020 by j-dock
1 Asked on August 27, 2020 by nicholas-snr
1 Asked on August 26, 2020 by rohit-waghela
1 Asked on August 20, 2020 by yamini
api discussion board rest sharepoint online sharepoint rest api
1 Asked on August 9, 2020 by sh-olli
2010 calculated column calculated column formula comparison modified
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP