Posts tagged ColdFusion

After pretty exciting results with retrieving list data from SharePoint using ColdFusion 9, I’ve been quite eager to try out some of the other methods exposed by ColdFusion.  However, retrieving lists is one thing; testing out methods that could actually modify data is another entirely.  So, I broke down and spent several hours installing WSS and SQL Server 2008 on my local machine.  Interestingly enough, there are ways to get it to run on a 32-bit Vista machine, so if you’re curious how, let me know ;).

Anyway, once I got SharePoint installed, I immediately created a simple list.  It’s incredibly simple–it only has two fields, “Title” and “Favorite Color.”

The first method I wanted to try out was to add a list item to this list, a name and a color.  As with the list retrieval web service, the “updateListItems” method is just as simple to implement.  Here’s the code I used:

<cfsavecontent variable="xml">
<Batch OnError='Return'>
<Method ID='1' Cmd='New'>
<Field Name='ID'>New</Field>
<Field Name='Title'>Monkey</Field>
<Field Name='Favorite_x0020_Color'>Pink</Field>
</Method>
</Batch>
</cfsavecontent>

<cfset newItem = xmlParse(xml)>
<cfsharepoint action="updatelistitems"
              domain="localhost"
              userName="username"
              password="password"
              name="newitems"
              params="#{listName="AAC20C17-A87D-4985-BA1D-9DD511EE9B9A", updates="#newItem#"}#"
/>
<cfdump var="#newitems#" />

This is super straight-forward.  First, you create a “Batch” element.  Basically, this allows you to define any number of “methods” More >