Skip to main content

Hello,

We are trying to set up a SharePoint web connection to use in FME at my workplace. Together with competent IT staff, we have been trying on our own for over six months without success. I thought I would ask here before we consider the next step!

 

We have followed the following guides without success:
How to Create a SharePointOnlineConnector Multitenant Web Connection – FME Support Center

How to Create a SharePointOnlineConnector Web Connection with Application Permissions – FME Support Center

 

The problem occurs when using the transformer. We get successful login attempts and connection to the web connection itself when we test it after configuration – but we encounter the error “Error Retrieving Selections – An unknown error has occurred” in the SharePointOnlineConnector transformer. This has no documentation and therefore we have reached a point where troubleshooting is done in complete blindness. This problem has been consistant even after we’ve change of parameters.

 

We have set up an web connections to Microsoft Azure Active Directory and Microsoft SharePoint Online, both through template and by configuring directly in the connection. Neither has worked.

 

Do you have any idea what the problem might be? I am happy to share any further information to help solve this problem!

So you are indeed a mutlitenant Microsoft organisation? The link you have there suggest so

There are however instructions here for single tenant https://support.safe.com/hc/en-us/articles/25407429863053-How-to-Create-a-SharePointOnlineConnector-Single-Tenant-Web-Connection which I believe the majority of Microsoft customers are?

You can escalate this to Safe software support using https://support.safe.com/hc/en-us/requests/new

 

 


Yeah sorry - used the wrong link! That’s correct, we’re single tenant.


Which version of FME are you using ?

You can check the version of the Connector transformer 

https://hub.safe.com/publishers/safe/packages/microsoft-sharepoint/versions/1.5.3

Its a “package”, so go into Tools > FME options > FME packages… and there is info about the version you have… and you may want to consider “check for upgrades”

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/sharepointonlineconnector-pkg.htm

https://hub.safe.com/publishers/safe/packages/microsoft-sharepoint/versions/1.5.3

 


I’m experiencing the same problem. I’ve been using a single tenant web connection for the SharePointList-reader without problem, but setting up a web connection for the SharePointOnlineConnect wont work and only generates the generic message “ An unknown error has occurred “.

 

When I try it out in FME 2025.0 (instead of 2025.1), I get the following error in the log:

 

2025-09-04 10:35:48|      |     |ERROR |Worker 12548 > C:\Users\XXX\AppData\Roaming\Safe Software\FME\Packages\25208-win64\python\safe.microsoft-sharepoint\stringcase.py:247: SyntaxWarning: invalid escape sequence '\W'
2025-09-04 10:35:48|      |     |ERROR |Worker 12548 >   return re.sub("\W+", "", string)

 

Any ideas?

 


Which version of FME are you using ?

You can check the version of the Connector transformer 

https://hub.safe.com/publishers/safe/packages/microsoft-sharepoint/versions/1.5.3

Its a “package”, so go into Tools > FME options > FME packages… and there is info about the version you have… and you may want to consider “check for upgrades”

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/sharepointonlineconnector-pkg.htm

https://hub.safe.com/publishers/safe/packages/microsoft-sharepoint/versions/1.5.3

 

Using the latest version, 1.5.3.


Which version of FME are you using ?

You can check the version of the Connector transformer 

https://hub.safe.com/publishers/safe/packages/microsoft-sharepoint/versions/1.5.3

Its a “package”, so go into Tools > FME options > FME packages… and there is info about the version you have… and you may want to consider “check for upgrades”

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/sharepointonlineconnector-pkg.htm

https://hub.safe.com/publishers/safe/packages/microsoft-sharepoint/versions/1.5.3

 



We’re using FME 2025.0.1.0!

 

Forgot to mention that we’ve downloaded the package and kept it updated!