Microsoft SharePoint List Writer: Format Parameters

This parameter lets the user specify how features will be written into the destination table. Supported feature operations are:

• Insert: Append rows onto the destination table using attributes on features.
• Update: Update existing table columns using attributes on features. A selection method must be specified in the Row Selection group.
• Delete: Delete existing table rows. A selection method must be specified in the Row Selection group.
• fme_db_operation: The feature operation will be determined by the attribute fme_db_operation on each input feature. A selection method must be specified in the Row Selection group. The value of fme_db_operation will be processed as follows:
  • If the value is null, empty, or missing, it will be treated as Insert.
  • The value will next be matched to Insert, Update, and Delete, case insensitively.
  • If there is no match, the feature will be rejected.
  • If there is a match, the matched feature operation will be performed on the feature.

Tip: The fme_db_operation attribute will now cause feature rejection when Feature Operation is set to Insert, Update, or Delete. This behavior differs from previous versions of FME.

More information on Feature Operations.

Controls how the feature type handles destination tables or lists. These options are available:

• Use Existing: Write to an existing table or list. If the destination table/list does not exist, the translation will fail.
• Create If Needed: Create destination table/list if it does not exist.
• Drop and Create: Drop destination table/list if it exists, and then create it. The writer will drop and re-create the table before writing any features to it. Tables will be overwritten when the first input feature is processed. If no features are sent to a feature type, then the corresponding table will not be overwritten.
• Truncate Existing: (This option is not available for all formats.) If destination table/list does not exist, the translation will fail. Otherwise, delete all rows from existing table or list.

This parameter is enabled when the Feature Operation is set to Update, Delete, or fme_db_operation.

It identifies the attribute that contains the Item ID value on input features. This value is then used to identify which existing Item to Update or Delete.

The default is the sharepoint_item_id format attribute.

Note that if the specified attribute also corresponds to a field on the List's schema, Update operations will also update the value of that field.

The type of List to create when the SharePoint Writer needs to create a new List for the feature type. Currently, the only supported value is “Custom List” (also known as Generic List).

This is an optional parameter that takes a string for the description of a List. The value will only have an effect when a new List is being created.