Microsoft SharePoint List Writer Parameters

Connection

Site

Enter the domain of the SharePoint site (for example, https://contoso.sharepoint.com).

Authentication Method

Indicates the method by which the user credentials are validated to the SharePoint site.

  • SharePoint Online: Select Web Connection.
  • SharePoint Server: Select Basic, NTLM, or Kerberos authentication, depending on the configuration of the specified SharePoint site.

FME supports Kerberos authentication, also known as Windows Authentication (which is only supported on Windows). When Kerberos authentication is selected and supported by the server, the current user’s domain account is used, and the Username and Password fields are ignored.

Web Connection

Specifies the SharePoint Online OAuth 2.0 connection to use.

FME includes a Web Service template for connecting to SharePoint Online. The template cannot be used as-is with this format. Use the template to create a Web Service with a permission scope specific to your SharePoint Online tenant, which can then be used to create a connection.

Instructions are available in the Connection dialog. Open the Microsoft SharePoint Online (Template) Description.

User

Enter a SharePoint account username.

When using Basic or NTLM authentication for connecting to a SharePoint Server site, providing the domain of the machine along with the username is optional, but recommended. The writer will attempt to automatically find the domain if it is not initially provided.

The username format for Basic and NTLM is domain\user (for example, safe\developer1).

Password

Enter the password for the specified user.

Advanced