There are many ways in CSOM to get the list properties from a SharePoint site. But there are a few properties which we can’t get directly from the list object. In this blog, I will explain how to find those using the SchemaXml.

This below-mentioned code sample will help us to get those properties which we cannot access directly from the list object.

The code block for this is mentioned below.

    using System;  
    using System.Collections.Generic;  
    using System.Linq;  
    using System.Text;  
    using System.Threading.Tasks;  
    using Microsoft.SharePoint.Client;  
    using System.Net;  
    using System.Security;  
    using Microsoft.SharePoint.Client.Utilities;  
    namespace SchemaXml {  
        class GetListSchema {  
            static void Main(string[] args) {  
                string listName = "CopyDoc";  
                string username = string.Empty;  
                string password = string.Empty;  
                SecureString secureString = new SecureString();  
                SharePointOnlineCredentials credentials = null;  
                List list = null;  
                System.Xml.Linq.XDocument xDocument;  
                string modified = string.Empty;  
                try {  
                    username = "userName@domain.com";  
                    password = "******";  
                    foreach(char ch in password.ToCharArray())  
                    secureString.AppendChar(ch);  
                    ClientContext ctx = new ClientContext("siteUrl"); //creating ClientContext from given SharePoint Site  
                    credentials = new SharePointOnlineCredentials(username, secureString); //creating creadential object for office365 site.  
                    ctx.Credentials = credentials;  
                    Web web = ctx.Web;  
                    list = ctx.Web.Lists.GetByTitle(listName);  
                    ctx.Load(list, l => l.SchemaXml, //loading schemaXml  
                        l => l.EnableVersioning);  
                    ctx.ExecuteQuery();  
                } catch (Exception ex) {}  
                try {  
                    using(System.IO.StringReader reader = new System.IO.StringReader(list.SchemaXml)) //getting the data from SchemaXml  
                    {  
                        xDocument = System.Xml.Linq.XDocument.Load(reader); //converting StringReader to XDocument  
                        List < ListpropertiesInfo > listSchemaXml = (from l in xDocument.Descendants("List") select new ListpropertiesInfo // class to store the properties  
                            {  
                                PropMajorVersionLimit = l.Attribute("MajorVersionLimit").Value,  
                                    PropMajorWithMinorVerionLimit = l.Attribute("MajorWithMinorVersionsLimit").Value,  
                                    PropExcludFromOfflineClient = l.Attribute("ExcludeFromOfflineClient").Value,  
                                    PropEnableFolderCreation = l.Attribute("EnableFolderCreation").Value  
                            }).ToList();  
                        foreach(var item in listSchemaXml) {  
                            int majorVersion;  
                            int minorVersion;  
                            if (list.EnableVersioning) {  
                                if (Int32.TryParse(item.PropMajorVersionLimit, out majorVersion)) {  
                                    Console.WriteLine("Major Version: " + majorVersion);  
                                }  
                                if (Int32.TryParse(item.PropMajorWithMinorVerionLimit, out minorVersion)) {  
                                    Console.WriteLine("Minor Version : " + minorVersion);  
                                }  
                            } else {  
                                Console.WriteLine("Major Version: 0");  
                                Console.WriteLine("Minor Version : 0");  
                            }  
                            if (Convert.ToBoolean(item.PropExcludFromOfflineClient)) Console.WriteLine("Status: false");  
                            else Console.WriteLine("Status: true");  
                            Console.WriteLine("Folder Creation: " + item.PropEnableFolderCreation);  
                            Console.ReadLine();  
                        }  
                    }  
                } catch (Exception er) {}  
            }#  
            region ListpropertiesInfo  
            public class ListpropertiesInfo {  
                public string PropMajorVersionLimit {  
                    get;  
                    set;  
                }  
                public string PropMajorWithMinorVerionLimit {  
                    get;  
                    set;  
                }  
                public string PropExcludFromOfflineClient {  
                    get;  
                    set;  
                }  
                public string PropEnableFolderCreation {  
                    get;  
                    set;  
                }  
            }#  
            endregion  
        }  
    }

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Microsoft.SharePoint.Client;

using System.Net;

using System.Security;

using Microsoft.SharePoint.Client.Utilities;

namespace SchemaXml {

class GetListSchema {

static void Main(string[] args) {

string listName = "CopyDoc";

string username = string.Empty;

string password = string.Empty;

SecureString secureString = new SecureString();

SharePointOnlineCredentials credentials = null;

List list = null;

System.Xml.Linq.XDocument xDocument;

string modified = string.Empty;

try {

username = "userName@domain.com";

password = "******";

foreach(char ch in password.ToCharArray())

secureString.AppendChar(ch);

ClientContext ctx = new ClientContext("siteUrl"); //creating ClientContext from given SharePoint Site

credentials = new SharePointOnlineCredentials(username, secureString); //creating creadential object for office365 site.

ctx.Credentials = credentials;

Web web = ctx.Web;

list = ctx.Web.Lists.GetByTitle(listName);

ctx.Load(list, l => l.SchemaXml, //loading schemaXml

l => l.EnableVersioning);

ctx.ExecuteQuery();

} catch (Exception ex) {}

try {

using(System.IO.StringReader reader = new System.IO.StringReader(list.SchemaXml)) //getting the data from SchemaXml

{

xDocument = System.Xml.Linq.XDocument.Load(reader); //converting StringReader to XDocument

List < ListpropertiesInfo > listSchemaXml = (from l in xDocument.Descendants("List") select new ListpropertiesInfo // class to store the properties

{

PropMajorVersionLimit = l.Attribute("MajorVersionLimit").Value,

PropMajorWithMinorVerionLimit = l.Attribute("MajorWithMinorVersionsLimit").Value,

PropExcludFromOfflineClient = l.Attribute("ExcludeFromOfflineClient").Value,

PropEnableFolderCreation = l.Attribute("EnableFolderCreation").Value

}).ToList();

foreach(var item in listSchemaXml) {

int majorVersion;

int minorVersion;

if (list.EnableVersioning) {

if (Int32.TryParse(item.PropMajorVersionLimit, out majorVersion)) {

Console.WriteLine("Major Version: " + majorVersion);

}

if (Int32.TryParse(item.PropMajorWithMinorVerionLimit, out minorVersion)) {

Console.WriteLine("Minor Version : " + minorVersion);

}

} else {

Console.WriteLine("Major Version: 0");

Console.WriteLine("Minor Version : 0");

}

if (Convert.ToBoolean(item.PropExcludFromOfflineClient)) Console.WriteLine("Status: false");

else Console.WriteLine("Status: true");

Console.WriteLine("Folder Creation: " + item.PropEnableFolderCreation);

Console.ReadLine();

}

} catch (Exception er) {}

region ListpropertiesInfo

public class ListpropertiesInfo {

public string PropMajorVersionLimit {

get;

set;

}

public string PropMajorWithMinorVerionLimit {

get;

set;

}

public string PropExcludFromOfflineClient {

get;

set;

}

public string PropEnableFolderCreation {

get;

set;

}

endregion

}

In this blog, I have explained how you can get the properties of a SharePoint list from SchemaXml. I hope this information will help you out in a few scenarios.

SharePoint 2013 Hosting Recommendation

HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options

SharePoint 2013 Hosting – HostForLIFE.eu : Getting List Properties From SchemaXml

SharePoint 2013 Hosting Recommendation

BLOGROLL

Featured On

SharePoint 2013 Hosting – HostForLIFE.eu : Getting List Properties From SchemaXml

SharePoint 2013 Hosting Recommendation

BLOGROLL

Featured On

Tags