Microsoft SharePoint List Reader/Writer

Note: Licensing options for this format begin with FME Professional Edition.

The Microsoft SharePoint List plug-in enables FME to read from and write to SharePoint Lists hosted on either a SharePoint Server instance, or on Microsoft SharePoint Online.

Note: For users connecting to a SharePoint site through their intranet, FME reads only SharePoint version 2012 or higher. The Sharepoint online version is always up-to-date.

For more information about SharePoint and SharePoint Online, visit http://www.sharepoint.com.

Reader Overview

There are different types of SharePoint Lists. These different types are also known as Apps. The SharePoint reader supports the following List types:

Announcements Form Library*
Asset Library* Issue Tracking
Calendar Links
Contacts Picture Library*
Custom List Promoted Links
Custom List in Datasheet Report Library*
Data Connection Library* Survey
Discussion Board Tasks
Document Library* Wiki Page Library*

*Library apps act in a similar way to a file system, storing documents, media, folders, etc.; however, the SharePoint Reader is not intended to import files. Features that are read from these Library apps will only contain the metadata pertaining to the files, and not the files themselves.

A SharePoint reader may have multiple Views which expose subsets of the Fields available within a List. One of these views is known as the Default View. The SharePoint Reader can read from either the Default View, or read all Fields: reading any View aside from the Default View is not supported.

For more information, see the “Show All Fields” parameter in the Workbench Reader Parameters section.

Workbench Reader Dataset

The value for the Reader Dataset is a fully-qualified URL for a SharePoint Server or SharePoint Online site (for example, https://sharepoint.example.com.

Writer Overview

The SharePoint Writer can create, update, and delete Items within SharePoint Lists, as well as create and delete SharePoint Lists themselves.

SharePoint has multiple List types. Currently, the SharePoint Writer can only create Lists of the “Custom List” type.

Workbench Writer Dataset

The value for the Writer Dataset is a fully-qualified URL for a SharePoint Server or SharePoint Online site (for example, https://sharepoint.example.com.

Terminology in this Chapter

  • A List is defined to be a feature type.
  • A View is a collection or subset of Fields in a List.
  • A Field (or column) is defined to be an attribute.
  • An Item (or row) is defined to be a feature.