Update SharePoint List Via Web Service

The Update SharePoint List Via Web Service plug-in updates a SharePoint list via the SharePoint Web Service.  This can be used to update a SharePoint list on a different server.  This plug-in will synchronize all commonly-named columns in the two lists in question.

Value Pair

Description

domain

The domain to use in connecting to the SharePoint site.

list

The name of the list on which to operate.

onmultiple

Defines what you want the Operation to do if multiple listings are matched with the query. The only valid values are:

first: operates on the first row only.
error: throws an exception if multiple rows are returned.
all: performs the defined operation on all listings.

operation

The action you want to perform. Valid values for operation are:

Delete: deletes an existing listing.
Insert: inserts a new listing.
Update: updates an existing listing.
Upsert: replaces an existing listing.

password

The password to use in connecting to the SharePoint site.

query

The expression to use in querying the target list.

Example:

[Title]==@[titleNum]

  • [Title] = a SharePoint field
  • == is the operator (equals in this case)
  • @[titleNum] = reference to a form field

NOTE: The syntax for this requires that the form field should not be an XPath.

site

The site on which the target list resides.

title

The value to put into the SharePoint Title field for new list items.

un

The username to use in connecting to the SharePoint site.

Example

  • domain – ACME
  • list – Summary List
  • onmultiple – first
  • operation – update
  • password – sharevis
  • query – [Title] == @[FormTitle]
  • site – http://server2.acme.com/Summary
  • title – [FormTitle]
  • un – svadmin

This example will query the list Summary Liston the sitehttp://server2.acme.com/Summary. It will retrieve all items that have the Title field set to the same value as the FormTitle field in the current list item.  On the first item that comes back from the query, it will update the commonly-named column values in the current list and the Summary List.  The user credentials to access the site will be as shown.