Microsoft's recommended method of connecting to Office 365 for companies using Active Directory is to use ADFS federated with Azure AD. There really needs to be an option for connecting to SharePoint Online as well as other Office365 components(if it isn't already).

Let's see this get some traction.

Similar item: https://knowledge.safe.com/idea/89777/sharepoint-list-rederwriter-single-sign-on-authent.html

I support the request for this. Multi factor authentication (MFA) seems to be increasingly common in SharePoint Online and FME's inability to connect is certainly causing me a headache today! Thanks

This idea has been implemented in FME 2020.0--the SharePoint List Reader/Writer now supports SAML and ADFS authentication via OAuth 2.0!

Users from organizations using SAML or ADFS with SharePoint Online should create an OAuth 2.0 Web Service definition using the Microsoft SharePoint Online template. This template can be found under Tools > FME Options > Web Connections > Manage Services.

Users need to create a copy of the template and modify it according to the web service setup instructions section of the template. This is an important step--the template will not work as-is and requires the user to make in the required changes.

Note: the Web Service definition does not work with on-premise SharePoint.

Access the SharePoint Online Web Service definition template with steps 1, 2, and 3.

Create a copy of the template using steps 4 & 5.

Modify the template copy to access the desired SharePoint service using instructions found in step 6.

'

Should this feature or its implementation not address your concerns, please let us know by leaving a comment.