In this blog we will see how to export a list in excel using server side object model. First block we will retrieve all items from the list. This can be done in several ways. You can get all items without filtering any columns. This will consist of all hidden and default columns as well. You can get all items with removing hidden columns You can get specific set of items based on some filter Add two references to your visual studio solution System.Data.dll Microsoft.SharePoin

This blog demonstrates how to connect to a list and retrieve specific items based on filter/query using JSOM. var ListItem; function getTheList(employee) { clientContext = new SP.ClientContext.get_current(); //get web object from current context var web = clientContext.get_web(); //Provide list name and fetch the list var myList = web.get_lists().getByTitle('LIST_NAME'); //write a query to fetch records based on filter var query = new SP.CamlQuery(); query.set_vi

This blog demonstrates how to retrieve/print only custom fields (user created) from a list using CSOM. Add two references to your visual studio solution Microsoft.SharePoint.Client.dll & Microsoft.SharePoint.Client.Runtime.dll string siteURL = "http://server/sites/site"; ClientContext context = new ClientContext(siteURL); Web oWebSite = context.Web; context.Load(oWebSite); context.ExecuteQuery(); //Get the list by title List employeeList = oWebSite.Lists.GetByTitle("Employe

Consider you have a listitem with multiple files added as attachments. Now you need to delete a specific file from those attachments programmatically, follow below steps: public static void DeleteAttachment(int itemId, string fileName) { using (SPSite site = new SPSite("http://server/sites/sitename")) { using (SPWeb web = site.OpenWeb()) { SPListItem listItem = web.Lists.TryGetList("Employees").GetItemById(itemId); List fileNames = n