Latest Posts

Get All Items in SharePoint using CSOM

The example in this topic show how to use CSOM to Get All Items in SharePoint
  • Please follow the steps below to execute the code in Visual Studio using Console Application. You can customize the solution according to your requirements.
  • Check the article to Connect to SharePoint context using CSOM. This is very helpful if you are doing any programming in CSOM.
  • Don't forget to use the assemblies as mentioned in the code.

How to run CSOM code in SharePoint?

  • Open your Visual Studio.
  • From the template, select Console Application as shown in the screenshot
  • Select the .Net Framework version from the top drop-down as well. You can also change the .Net Framework after creating the solution.
  • Enter Project Name, Location and Solution Name and click on OK.
  • create console application using Visual Studio
  • Now your program.cs file will open. Copy the code in main function.
  • Once you are done with your code, just hit F5 or Run the application.

  • 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:







© 2023 Code SharePoint