Accessing first 5 items in a list using CSOM for SharePoint 2013 Online
Below code snippet shows retrieving first 5 items in a list using CSOM for SharePoint 2013 Online by usning 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");
// view fields
string[] viewFields = { "Title" };
//Camlquery to retrieve the items from the custom list
CamlQuery query = CamlQuery.CreateAllItemsQuery(5, viewFields);
//Get all the items from the list
ListItemCollection itemcoll = list.GetItems(query);
clientContext.Load(itemcoll);
clientContext.ExecuteQuery();
foreach (ListItem item in itemcoll)
{
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