Get All Items in SharePoint using CSOM

The example in this topic show how to use CSOM to Get All Items in SharePoint

  • using Microsoft.SharePoint.Client;
  •  
  • using (ClientContext clientContext = new ClientContext("http://MyServer/sites/MySiteCollection"))
  • {
  • // clientcontext.Web.Lists.GetById - This option also can be used to get the list using List GUID
  • // This value is NOT List internal name
  • List targetList = clientContext.Web.Lists.GetByTitle("List Name");
  •  
  • // Optioanlly you can use overloaded method CreateAllItemsQuery(int rowlimits, params viewfields): where using "rowlimits" you can limit the number of rows returned and viewfields will return only specified fields in the result set
  • // This method will get all the items from all the folders and sub folders including folders and sub folders too
  • CamlQuery oQuery = CamlQuery.CreateAllItemsQuery();
  •  
  • ListItemCollection oCollection = targetList.GetItems(oQuery);
  • clientContext.Load(oCollection);
  • clientContext.ExecuteQuery();
  •  
  • foreach (ListItem oItem in oCollection)
  • {
  • Console.WriteLine(oItem["Title"].ToString());
  • }
  • }

Thank you for reading this article. This code was tested in SharePoint 2013

We value your feedback:

Page URL:

Name:

 

Email:

 
 

Feedback:

 

© 2019 Code SharePoint