Microsoft SharePoint Online List Reader/Writer (FME Form Package)

FME can read from and write to SharePoint Lists hosted on Microsoft SharePoint Online.

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

For access to on-premise Lists, see the Microsoft SharePoint Server List Reader/Writer (previously called the Microsoft SharePoint List Reader/Writer).

Product and System Requirements

Format	FME Platform			Operating System
Reader/Writer	FME Form	FME Flow	FME Flow Hosted	Windows 64-bit	Linux	Mac
Both	Yes	Yes	Yes	Yes	Yes	Yes

Integrating this Format with FME Form

Download from FME Hub	https://hub.safe.com/publishers/safe/packages/microsoft-sharepoint What is FME Hub?
Dependencies	Python 3.9+

Reader Overview

A SharePoint Online List reader can read SharePoint Lists, which are collections of tabular data stored in columns and rows. In SharePoint, each row represents a List Item and each column represents a metadata field. In FME, each List is a feature type, each List Item is a feature, and each column field is a feature attribute.

Document Libraries are a type of List that can also be read by the SharePoint List reader. However, the SharePoint Online List Reader is not intended to import files, and features that are read from Document Libraries will only contain the metadata pertaining to the files, not the files themselves. Users who wish to import files from a Document Library should use the SharePointOnlineConnector.

Writer Overview

A SharePoint Online List writer can create, update, and delete Items within SharePoint Lists, as well as create SharePoint Lists themselves.

Creating new Lists with the FeatureWriter is not fully supported at this time. It is expected that full support will be added in a future release.

Terminology Notes

• A List is defined in FME to be a feature type.
• A Field (or column) is defined in FME to be an attribute.
• An Item (or row) is defined in FME to be a feature.
• A Document Library is a type of List in which each Item is a file/folder.