Delete Item in Document Library using Client Object Model?

Question

I have custom Database, this Database having SharePoint Item URL like(http://yoursite.com/Shared Documents/a.pdf), so my challenge to remove this file from sharepoint Library using Client Object Model.

Answer 1

ClientContext clientContext = new ClientContext("http://sharepoint:6666"); Uri uri = new Uri(filePath); List spList = clientContext.Web.Lists.GetByTitle("Shared Documents"); Microsoft.SharePoint.Client.CamlQuery query = new Microsoft.SharePoint.Client.CamlQuery(); query.ViewXml = "<View>" + "<Query>" + "<Where><Eq><FieldRef Name='FileLeafRef'/><Value Type='File'>" + filename + "</Value></Eq></Where>" + "</Query>" + "</View>"; // execute the query ListItemCollection listItems = spList.GetItems(query); clientContext.Load(listItems); clientContext.ExecuteQuery(); foreach (ListItem listitem in listItems) { listitem.DeleteObject(); clientContext.ExecuteQuery(); } 

FileLeafRef is internal column name of Name.

Answer 2

yes you can try below rest call

url: http://site url/_api/web/GetFileByServerRelativeUrl('/Shared Documents/a.pdf') method: POST headers: Authorization: "Bearer " + accessToken X-RequestDigest: form digest value IF-MATCH: etag or "*" X-HTTP-Method:"DELETE" 

Hope this will work for you :)

Answer 3

Added on a little to the answer. It works perfectly. Suggest passing the Main Site name int he sLoginUri and then the Folder Location as not everyone has a "Shared Documents".

 #region Delete a File //============================================================================== Delete a File from a Library public static bool DeleteAFile(string sFileName, string sFldrLoc, string sUserName, string sPassword, string sLoginUri, ref String sError) { bool bRetVal = false; string sourceFolderName = "/" + sFldrLoc; string documentRelativePath = sLoginUri + sourceFolderName + "/" + sFileName; try { SP.ClientContext clientContext = new SP.ClientContext(sLoginUri); //NetworkCredential credential = System.Net.CredentialCache.DefaultNetworkCredentials; //clientContext.Credentials = credential; NetworkCredential credential = new NetworkCredential(sUserName, sPassword, "citgo"); clientContext.Credentials = credential; Uri uri = new Uri(documentRelativePath); SP.List spList = clientContext.Web.Lists.GetByTitle(sFldrLoc); Microsoft.SharePoint.Client.CamlQuery query = new Microsoft.SharePoint.Client.CamlQuery(); query.ViewXml = "<View>" + "<Query>" + "<Where><Eq><FieldRef Name='FileLeafRef'/><Value Type='File'>" + sFileName + "</Value></Eq></Where>" + "</Query>" + "</View>"; // execute the query SP.ListItemCollection listItems = spList.GetItems(query); clientContext.Load(listItems); clientContext.ExecuteQuery(); foreach (SP.ListItem listitem in listItems) { listitem.DeleteObject(); clientContext.ExecuteQuery(); bRetVal = true; } } catch (Exception exc) { //Log Error Here sError = exc.Message; } return bRetVal; } #endregion