Deleting items from Sharepoint Document Libraries or Lists should be fairly straightforward, however there are a couple of gotcha’s depending on which method from Sharepoint Webservices you want to use and accordingly, there are differences in the formatted CAML command you would use.
Firstly a Document Library is a form of List, but the CAML command to delete items from these differ slightly.
To delete an item from a list you would format a CAML command like this;
<Batch OnError="Continue"> <Method ID="1" Cmd="Delete"> <Field Name="ID">1</Field> </Method> </Batch>
The ID field contains the ID value of the list item to delete.
To delete an item from a document library you would format a CAML command like this;
<Batch OnError="Continue"> <Method ID="1" Cmd="Delete"> <Field Name="ID">1</Field> <Field Name="FileRef">http://spdev/Library Name/Msg-4218faa2-727e.xml</Field> </Method> </Batch>
Of note here is the ID and FileRef fields. The ID field is required to be present but it’s value is ignored. The FileRef field contains the document items FileRef column value and this is used to ascertain the document item to delete. This value is the full URL of the document item to delete, however it should be noted that this URL must not be URL encoded.
In both cases it is important that there is no whitespace/linefeed characters in the Batch elements inner or outer XML, although the examples shown above contain LF characters for clarity.
Both the above commands would be executed using the Sharepoint Webservices UpdateListItems() method, the first parameter of which is the List/Document Library GUID and the second is the XML node containing the CAML Batch command.
The List/Document Library GUID should be formatted using braces and hyphen characters as show below.
13 thoughts on “Deleting Items from Sharepoint Document Libraries”
How about deleting a document which is checked out by a user? I am not able to
Ziyad, AFAIK you can’t delete a document checked out by another user, although it may be possible if you’re an an administrator or the system account.
How can I delete a folder in a document library?
Thanks for the help.
I’ve not done this myself using CAML, but you could try somthing like this using the object model;
SPWeb web = new SPSite("your site's url").OpenWeb();
web.Folders[“document library name”].SubFolders.Delete(“folder name”);
I am unable to use the object model since I need to execute this code from a remote asp.net web server.
Faizal, Delete a Folder from a SharePoint Document Library.
Thanks. I will test this out.
Thanks, Couldn’t understand why I couldn’t delete a file until I saw that I needed the extra fileRef URL parameter.
public bool DeleteFile(int FileID)
//remove the file from the current item
List olist = _context.Web.Lists.GetByTitle();
ListItem item = olist.GetItemById(FileID);
_context.Load(olist, list => list.Title);
I’m running into an issue. Whenever I try to delete a file I get no errors, nor does the file get deleted. Anyone else has faced this issue before? I’ve triple checked my URL for errors and as far as I can tell, there are none…
Is there a way to get some sort of result back from the webservice to give me an idea of where the error is happening..
I’m having the same issue as Sessa (good URL, no errors thrown, file remains). Any ideas?
Hello Sessa and ChrisEZ in sharepoint 2013 you need to use a different XML, passing also the file path to the owsfileref variable in the Method elements, as MSDN says.
here is an example.
public static string DeleteAllItems(SPSite spSite, SPWeb spWeb, SPList spList)
StringBuilder deletebuilder = BatchCommand(spList);
private static StringBuilder BatchCommand(SPList spList)
StringBuilder deletebuilder = new StringBuilder();
string command = “” + spList.ID +
foreach (SPListItem item in spList.Items)