Deleting Items from Sharepoint Document Libraries

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.

{508B0C42-BC06-42A2-9531-2844FEAE9C00}

Sharepoint Developer Tools List

I’m doing some work with Sharepoint right now, my useful tool list is as follows;

- List and View GUID’s
- U2U CAML Builder v3 for MOSS 2007
- Purge Sharepoint Lists and Document Libraries
- Sharepoint Manager 2007