c#-Sharepoint online

674k 2020-12-27 16:02:44

@Ather Siddiqui,

there is no direct way to get items under a view as the view only has query schema and does not have any items. The caml query may get the same items that are under the view, but it will trigger the list view threshold.

@user2250152 has provided a good method, it's possible to get over 5000 items through Pagination. If you want to use the view query, you could change the query as below:

List tList = context.Web.Lists.GetByTitle("My test list");
            CamlQuery camlQuery = new CamlQuery
            {
                ViewXml = @"<View><Query><Where><Gt><FieldRef Name='ID' /><Value Type='Counter'>20</Value></Gt></Where></Query><OrderBy><FieldRef Name ='FileLeafRef' /></OrderBy><RowLimit>4990</RowLimit></View>"  // your view query
            };

            var itemColl = new List<ListItem>();
         
            do
            {
                ListItemCollection listItemCollection = tList.GetItems(camlQuery);
                context.Load(listItemCollection);
                context.ExecuteQuery();    
                
                //
                itemColl.AddRange(listItemCollection);
                camlQuery.ListItemCollectionPosition = listItemCollection.ListItemCollectionPosition;               

            } while (itemColl.Count < 999); //view row limit   

            Console.WriteLine(itemColl);