Getting InfoPath Form Library Fields using C# CSOM

Question

I need to extract InfoPath form fields in C# using Client Side Object Model(CSOM) and convert it into XML file.

The code which I tried to get FormLibrary fields is

 // Starting with ClientContext, the constructor requires a URL to the // server running SharePoint. ClientContext context = new ClientContext("http://SiteURL/"); // Assume the web has a list named "Announcements". List announcementsList = context.Web.Lists.GetByTitle("MyFormLibrary"); // This creates a CamlQuery that has a RowLimit of 100, and also specifies Scope="RecursiveAll" // so that it grabs all list items, regardless of the folder they are in. CamlQuery query = CamlQuery.CreateAllItemsQuery(100); ListItemCollection items = announcementsList.GetItems(query); // Retrieve all items in the ListItemCollection from List.GetItems(Query). context.Load(items); context.ExecuteQuery(); foreach (ListItem listItem in items) { // We have all the list item data. For example, Title. Console.WriteLine( listItem["Title"]); } 

I am getting Title field as name of xml file but when I debug it, giving me error in StackTrace as

at Microsoft.SharePoint.Client.ClientObject.CheckUninitializedProperty(String propName) at Microsoft.SharePoint.Client.File.get_Name()

can anyone please help me !!! Any help is appreciated.

Answer 1

I tried your code at my end and I found something useful for you.

Please replace your foreach loop with this code and try again.

 foreach (ListItem listItem in items) { // We have all the list item data. For example, Title. Console.WriteLine("Item : {0}, Id : {1}", listItem.FieldValues["Title"], listItem.Id, listItem.FieldValues["YourField"]); var fileRef = listItem.FieldValues["FileRef"]; FileInformation fileInfo = Microsoft.SharePoint.Client.File.OpenBinaryDirect(context, fileRef.ToString()); using (var memory = new System.IO.MemoryStream()) { byte[] buffer = new byte[1024 * 64]; int nread = 0; while ((nread = fileInfo.Stream.Read(buffer, 0, buffer.Length)) > 0) { memory.Write(buffer, 0, nread); } memory.Seek(0, System.IO.SeekOrigin.Begin); XDocument doc = XDocument.Load(memory); } //Console.WriteLine( listItem["Title"] + listItem.File.Name); Console.ReadKey(); } 

Now you will be getting XML data. Please find following snap which I got while running my code.

Let me know you were looking for this only.