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.

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.

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

Page URL:

Name:

Name is a mandatory field

Email:

Email is a mandatory field
Email format is not corrent

Suggestion:

Suggestion is a mandatory field