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.