Tuesday, January 20, 2015



Retrieving list items using SharePoint 2013 CSOM Model

Below code can be used to retrieve the list items for a specific list. Below code should be compiled in visual studio.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.SharePoint.Client;
using Microsoft.SharePoint;
using System.Security;
namespace GetListCollection
{
    class Program
    {
        static void Main(string[] args)
        {

            ClientContext clientContext = new ClientContext(https://abc.sharepoint.com");
            Web webUrl=clientContext.Web;
            Console.WriteLine("Enter your user name (ex: abc@microsoft.microsoftonline.com):");
            string userName = Console.ReadLine();
            Console.WriteLine("Enter your password.");
            SecureString password = GetPasswordFromConsoleInput();
            clientContext.Credentials = new SharePointOnlineCredentials(userName, password);

            //Get the list by Title
            List list = webUrl.Lists.GetByTitle("doctest");

            //Caml query to retrieve the items from custom list
            CamlQuery query = CamlQuery.CreateAllItemsQuery();

            //Get all the items from the list
            ListItemCollection itemcoll = list.GetItems(query);
            clientContext.Load(itemcoll);

            //Execute the query to the server
            clientContext.ExecuteQuery();

            //Loop through all the items
            foreach (ListItem item in itemcoll)
            {
                //Display the item title field value
                Console.WriteLine(item["Title"].ToString());
            }
            Console.ReadLine();
        }
        private static SecureString GetPasswordFromConsoleInput()
        {
            ConsoleKeyInfo info;

            //Get the user's password as a SecureString
            SecureString securePassword = new SecureString();
            do
            {
                info = Console.ReadKey(true);
                if (info.Key != ConsoleKey.Enter)
                {
                    securePassword.AppendChar(info.KeyChar);
                }
            }
            while (info.Key != ConsoleKey.Enter);
            return securePassword;
        }
    }
}

No comments:

Post a Comment