Skip to main content
Solved

SharePoint web connection not working

  • September 2, 2025
  • 7 replies
  • 124 views

johanna.skovde
Contributor
Forum|alt.badge.img+4

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!

Best answer by johanna.skovde

Solved the problem by contacting the support.

 

We had the correct settings both in Azure and in FME web connections, but the problem seemed to be a bug. Downgrading the web package Sharepoint Online to version 1.2.2 did the trick!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

7 replies

j.botterill
Influencer
Forum|alt.badge.img+53
  • Influencer
  • September 3, 2025

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

 

 


johanna.skovde
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • September 3, 2025

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


j.botterill
Influencer
Forum|alt.badge.img+53
  • Influencer
  • September 3, 2025

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

 


hi_dog
Contributor
Forum|alt.badge.img+4
  • Contributor
  • September 4, 2025

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?

 


hi_dog
Contributor
Forum|alt.badge.img+4
  • Contributor
  • September 4, 2025

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.


johanna.skovde
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • September 4, 2025

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!


johanna.skovde
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • Best Answer
  • October 3, 2025

Solved the problem by contacting the support.

 

We had the correct settings both in Azure and in FME web connections, but the problem seemed to be a bug. Downgrading the web package Sharepoint Online to version 1.2.2 did the trick!