Threshold issue when Performing CSOM operation on 5000+ Items in a library

Question

Hi,
We are performing operation on library having 5000+ documents.I find that any CSOM operation on the List having 5000+ throws the threshold error .How to over come this issue ?

Error: "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator"

I have this code mentioned below

Whenever I try to load below statements for a list having 5001 docs it is throwing threshold error.
Is this a limitation using CSOM ?

cContext.Load(list2.RootFolder.Folders);

Sample code:

string fileUrl = "https://.sharepoint.com/sites/";

            Uri fileUri = new Uri(fileUrl);

            var x = fileUri.Scheme + Uri.SchemeDelimiter + fileUri.Host;

            ClientContext rootContext = new ClientContext(fileUri.Scheme + Uri.SchemeDelimiter + fileUri.Host);

            rootContext.Credentials = BuildCreds();

            Uri webUrl = Web.WebUrlFromPageUrlDirect(rootContext, fileUri);

            ClientContext cContext = new ClientContext(webUrl.ToString());

            cContext.Credentials = BuildCreds();


            cContext.Load(cContext.Web);               

            cContext.ExecuteQuery();

            ListCollection siteLists = cContext.Web.Lists;

            cContext.Load(siteLists);

            cContext.ExecuteQuery();


            foreach (List list2 in siteLists)

            {

                try

                {

                    cContext.Load(list2);

                    cContext.Load(list2.RootFolder);

                    cContext.Load(list2.RootFolder.Folders);

                    cContext.ExecuteQuery();


                }

                catch

                {


                }

            }

Answer 1

Hi MahadevKarekar-4448,

This is known issue named Threshold error. Check below doc to get more details:

• https://natechamberlain.com/2018/05/21/how-to-resolve-sharepoint-list-view-threshold-error-the-view-cannot-be-displayed-because-it-exceeds-the-list-view-threshold/

If you want to get folders under root folder in a large list, please take a reference of below code:

• caml Pagination code

More references:

• https://stackoverflow.com/questions/61643974/sharepoint-csom-api-doesnt-throw-threshold-exception
• http://www.codegrimoire.com/2013/08/scopes-in-caml-query.html

Best Regards,
Baker Kong

Answer 2

Yes, SharePoint Online has 5000 items limit for viewing list/library items. You can create indexes on the columns you want to query as explained here and use pagination in your code to extract as explained here.