No idea for Large List View CSOM

Question

Have a large list about 10k items.

Now I'm getting all list items in CSOM but the code snippet throw List View Threshold error.

Can we overcome this error, I real want this list data in CSOM and export to Excel CSV.

Thanks for any help

Answer 1

Hi @developer sp1 ,

Use ListItemCollectionPosition for paging the large list items collection, here is a sample code for your reference:

ClientContext clientContext = new ClientContext("weburl");  
List list = clientContext.Web.Lists.GetByTitle("ListTitle");  
ListItemCollectionPosition position = null;  
do  
{  
    CamlQuery camlQuery = new CamlQuery();  
    camlQuery.ListItemCollectionPosition = position;  
    camlQuery.ViewXml = @"<View>  
                            <ViewFields>  
                              <FieldRef Name='Title'/>  
                            </ViewFields>  
                            <RowLimit>5000</RowLimit>  
                          </View>";  
    ListItemCollection listItems = list.GetItems(camlQuery);  
    clientContext.Load(listItems);  
    clientContext.ExecuteQuery();  
    position = listItems.ListItemCollectionPosition;  
    foreach (ListItem listItem in listItems)  
        Console.WriteLine("Title: {0}", listItem["Title"]);  
}  
while(position != null)  

Large list issue with CSOM

Thanks
Best Regards

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.