{"id":172,"date":"2015-11-12T13:24:38","date_gmt":"2015-11-12T13:24:38","guid":{"rendered":"http:\/\/www.softreeconsulting.com\/?p=172"},"modified":"2015-11-12T13:24:38","modified_gmt":"2015-11-12T13:24:38","slug":"how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model","status":"publish","type":"post","link":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/","title":{"rendered":"How to get items from a specific SharePoint List View using client object model"},"content":{"rendered":"

Below code describes how to retrieve items from sharepoint list by specific view using client side object model<\/p>\n

    \n
  1. Add reference \u201cMicrosoft.sharepoint.client.dll\u201d and \u201cMicrosoft.sharepoint.client.Runtime.dll\u201d.<\/li>\n
  2. Write Below Code.<\/li>\n<\/ol>\n

    using<\/span> Microsoft.SharePoint.Client;<\/span><\/p>\n

    namespace<\/span> ConsoleApplication<\/span><\/p>\n

    {\u00a0\u00a0<\/span><\/p>\n

    \u00a0\u00a0\u00a0 class<\/span> Program<\/span><\/span><\/p>\n

    \u00a0\u00a0\u00a0 {<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 static<\/span> void<\/span>\u00a0main(string<\/span>[] args)<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 using<\/span> (ClientContext <\/span>ctx=new<\/span> ClientContext<\/span>(“http:\/\/siteurl”<\/span>))<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/Apply Credential<\/span><\/span><\/p>\n

    \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0ctx.Credentials = new<\/span> System.Net.NetworkCredential<\/span>(“UserName”<\/span>, “Password”<\/span>);<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Web <\/span>web = ctx.Web;<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ctx.Load(web,w=>w.Lists);<\/span><\/p>\n

     <\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 List <\/span>list = web.Lists.GetByTitle(“New List”<\/span>);\/\/Load list<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ctx.Load(list, l => l.Views);<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ctx.ExecuteQuery();<\/span><\/p>\n

     <\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CamlQuery <\/span>query = new<\/span> CamlQuery<\/span>();<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ListItemCollection itemColl = null<\/span>;<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 View view = list.Views.GetByTitle(“MyCustomView”<\/span>);\/\/enter view name<\/span><\/span><\/p>\n

     <\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ctx.Load(view, vw => vw.ViewQuery);<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ctx.ExecuteQuery();<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 query.ViewXml = string<\/span>.Format(“<View><Query>{0}<\/Query><\/View>”<\/span>, view.ViewQuery);<\/span><\/p>\n

     <\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 itemColl = list.GetItems(query);<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ctx.Load(itemColl);<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ctx.ExecuteQuery();<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/span><\/p>\n

    \u00a0\u00a0\u00a0 }<\/span><\/p>\n

    }<\/span><\/p>\n

    Note: – you can write query.ViewXml = string.Format(“<View Scope=’RecursiveAll’> <Query>{0}<\/Query><\/View>”, view.ViewQuery);<\/em><\/span><\/p>\n

    Here Scope=’RecursiveAll’ is used to retrieve item within folders and subfolders<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    Below code describes how to retrieve items from sharepoint list by specific view using client side object model Add reference \u201cMicrosoft.sharepoint.client.dll\u201d and \u201cMicrosoft.sharepoint.client.Runtime.dll\u201d. Write Below Code. using Microsoft.SharePoint.Client; namespace ConsoleApplication {\u00a0\u00a0 \u00a0\u00a0\u00a0 class Program \u00a0\u00a0\u00a0 { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 static void\u00a0main(string[] args) \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 using (ClientContext ctx=new ClientContext(“http:\/\/siteurl”)) \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/Apply Credential \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0ctx.Credentials […]<\/p>\n","protected":false},"author":1,"featured_media":397,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[50,60,61,56],"class_list":["post-172","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sharepoint","tag-client-object-model","tag-get-items-from-sharepoint-view","tag-how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model","tag-sharepoint"],"yoast_head":"\nHow to get items from a specific SharePoint List View using client object model - Softree Technology<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to get items from a specific SharePoint List View using client object model - Softree Technology\" \/>\n<meta property=\"og:description\" content=\"Below code describes how to retrieve items from sharepoint list by specific view using client side object model Add reference \u201cMicrosoft.sharepoint.client.dll\u201d and \u201cMicrosoft.sharepoint.client.Runtime.dll\u201d. Write Below Code. using Microsoft.SharePoint.Client; namespace ConsoleApplication {\u00a0\u00a0 \u00a0\u00a0\u00a0 class Program \u00a0\u00a0\u00a0 { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 static void\u00a0main(string[] args) \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 using (ClientContext ctx=new ClientContext(“http:\/\/siteurl”)) \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/Apply Credential \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0ctx.Credentials […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/\" \/>\n<meta property=\"og:site_name\" content=\"Softree Technology\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-12T13:24:38+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get items from a specific SharePoint List View using client object model - Softree Technology","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/","og_locale":"en_US","og_type":"article","og_title":"How to get items from a specific SharePoint List View using client object model - Softree Technology","og_description":"Below code describes how to retrieve items from sharepoint list by specific view using client side object model Add reference \u201cMicrosoft.sharepoint.client.dll\u201d and \u201cMicrosoft.sharepoint.client.Runtime.dll\u201d. Write Below Code. using Microsoft.SharePoint.Client; namespace ConsoleApplication {\u00a0\u00a0 \u00a0\u00a0\u00a0 class Program \u00a0\u00a0\u00a0 { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 static void\u00a0main(string[] args) \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 using (ClientContext ctx=new ClientContext(“http:\/\/siteurl”)) \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 { \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/Apply Credential \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0ctx.Credentials […]","og_url":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/","og_site_name":"Softree Technology","article_published_time":"2015-11-12T13:24:38+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/#article","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/"},"author":{"name":"admin","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b"},"headline":"How to get items from a specific SharePoint List View using client object model","datePublished":"2015-11-12T13:24:38+00:00","mainEntityOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/"},"wordCount":199,"commentCount":0,"publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/#primaryimage"},"thumbnailUrl":"","keywords":["Client Object Model","Get items from SharePoint view","How to get items from a specific SharePoint List View using client object model","SharePoint"],"articleSection":["SharePoint"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/","url":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/","name":"How to get items from a specific SharePoint List View using client object model - Softree Technology","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/#primaryimage"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/#primaryimage"},"thumbnailUrl":"","datePublished":"2015-11-12T13:24:38+00:00","breadcrumb":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/how-to-get-items-from-a-specific-sharepoint-list-view-using-client-object-model\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/softreetechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get items from a specific SharePoint List View using client object model"}]},{"@type":"WebSite","@id":"https:\/\/softreetechnology.com\/blog\/#website","url":"https:\/\/softreetechnology.com\/blog\/","name":"Softree Technology","description":"Celebrating 10+ Years in SharePoint Consulting !","publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/softreetechnology.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/softreetechnology.com\/blog\/#organization","name":"Softree Technology","url":"https:\/\/softreetechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","width":844,"height":230,"caption":"Softree Technology"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/softreeconsulting.com"],"url":"https:\/\/softreetechnology.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=172"}],"version-history":[{"count":0,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/172\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}