Field Configuration

This string property holds the XML configuration for the Database Writer Field.  The configuration will hold values for the insert, edit, and delete URLs, plus which SharePoint list item fields are stored to which database fields.

Configuration (required)

The parent node of the configuration XML. This sets up the behavior of the database writer field.

DatabaseValues (optional)

A collection of values that will be used to insert or update the data source.

Item (required) – The individual item that will be used in the data source.

•      Internal (attribute, optional) – Set to true to use the internal field name of the item.

•      Name (required) – The name of the parameter that will be sent forward to the adapter.

•      Field (required) – The display name of the list item field whose value will be sent to the adapter.

DeleteURL (optional)

The URL of the provider that handles the deletion of the record when the list item is deleted. This property also supports the Common Use Variables stated at the beginning of this help topic.

EditURL (optional)

The URL of the provider that handles the editing of this record when the item is updated. This property also supports the Common Use Variables stated at the beginning of this help topic.

InsertURL (optional)

The URL of the provider that handles the insertion of this record when a new item is created. This property also supports the use of the variables <%SiteURL%> and <%HostName%>.

Additional Append Values

The following are a list of additional values sent along with each request to the adapter. These values may be used when configuring your adapter for any insert, update or delete action.

•      ListItemIDGuid – The unique GUID value of the list item.

•      ListItemID – The list item ID.  This value may not be unique across multiple lists.

•      ListID – The list id of the list the database writer is a member of.

•      ListTitle – The title of the list the database writer is a member of.

•      ListURL – The list URL of the list the database writer is a member of.

•      SiteTitle – The site title of the site the list is a member of.

•      SiteURL – The site URL of the site the list is a member of.

•      ListEdit- The edit form URL of the list the database writer is a member of.

•      ListNew – The new form URL of the list the database writer is a member of.

•      ListDisplay – The display form URL of the list the database writer is a member of.

Example:

<Configuration>

          <InsertURL>http://mysite.com/edp/insert</InsertURL>

          <EditURL>http://mysite.com/edp/edit</EditURL>

          <DeleteURL>http://mysite.com/edp/delete</DeleteURL>

          <DatabaseValues>

                   <Item>

                             <Name>Item1</Name>    

                             <Field>Title</Field>

                   </Item>      

                   <Item internal="true">

                             <Name>Item2</Name>    

                             <Field>Statusx00xField</Field>    

                   </Item>

          </DatabaseValues>

</Configuration>