Skip to main content
Solved

Python issues with SharePointOnline transformer


ecx
Supporter
Forum|alt.badge.img+4
  • Supporter

Hello,

I have recently upgraded from fme flow 2024 to 2025.0.1. - (still using fme form 2024 for now)(EDIT: I have since aligned the versions between form and flow, and still getting the same error.)

I have a workbench which uses the SharePoint online connector transformer
 

 

 

I am currently using python version 3.12+.

I can run this workbench without any errors on fme form 2024, but when uploaded to fme flow 2025 I am getting the following issue: 

 

Any tips on how to resolve this?

Thanks.

 

Best answer by ecx

issue has been resolved.

solution: deleted the sharepoint web connection on fme flow, republished it with the same azure sharepoint info and now it works.


Python issues were a red herring.
But I did also realise that fme form was using 3.XX ESRI version, switching this to 3.10+ (not esri version) solved other python issues I was having. so it may also be part of this solution. unsure.



fme ticket response from Technical Support Specialist I, FME Flow, after I informed him of my solution:

I'm glad to hear that the Sharepoint connection is back online! 2025.x introduced some rather major changes with how FME handles connections and authentication, and this extends to the SharepointOnlineConnector transformer. I suspect what happened is that your SharepointOnline package was updated automatically to version 1.2.2 with the installation of 2025.x, and had to then be republished to Flow to properly reestablish the connection.

View original
Did this help you find an answer to your question?

5 replies

j.botterill
Influencer
Forum|alt.badge.img+40
  • Influencer
  • May 8, 2025

Safe recommend using the same Form and Flow version. Try the same from Form 2025.0.1 and take note of the Python compatibility setting under the Navigator > Workspace Parameters

 

If the problem persists, you may wish to lodge this to their support page, sign in https://support.safe.com/hc/en-us/requests/new referring to https://support.safe.com/s/article/How-to-Create-a-Great-FME-Desktop-Support-Case


ecx
Supporter
Forum|alt.badge.img+4
  • Author
  • Supporter
  • May 8, 2025
j.botterill wrote:

Safe recommend using the same Form and Flow version. Try the same from Form 2025.0.1 and take note of the Python compatibility setting under the Navigator > Workspace Parameters

 

If the problem persists, you may wish to lodge this to their support page, sign in https://support.safe.com/hc/en-us/requests/new referring to https://support.safe.com/s/article/How-to-Create-a-Great-FME-Desktop-Support-Case


Cheers,

I’ve aligned the versions between form and flow, but the same issue as in the original post persists.


ecx
Supporter
Forum|alt.badge.img+4
  • Author
  • Supporter
  • May 12, 2025

Does anyone have any ideas?


AliAtSafe
Safer
Forum|alt.badge.img+22
  • Safer
  • May 15, 2025

Hello, ​@ecx.

Thanks for posting your question to the community! Sorry your running into issues with the SharePointOnlineConnector transformer.

Just to get up to speed and first suggestions, have you tried taking take note of the Python compatibility setting under the Navigator > Workspace Parameters > Scripting > Python Compatibility as ​@j.botterill suggested? Also have you verified your interpreter is within range via Tools > FME Options > Translation > Python Interpreter?

Furthermore, this may give some insight depending on your use-case: Troubleshooting SharePoint Web Connections and Services.

Would also be able to give a quick run down of what you are doing with the SharePointOnlineConnector transformer if you can? It’ll provide some additional context.

Thanks!


ecx
Supporter
Forum|alt.badge.img+4
  • Author
  • Supporter
  • Best Answer
  • June 2, 2025

issue has been resolved.

solution: deleted the sharepoint web connection on fme flow, republished it with the same azure sharepoint info and now it works.


Python issues were a red herring.
But I did also realise that fme form was using 3.XX ESRI version, switching this to 3.10+ (not esri version) solved other python issues I was having. so it may also be part of this solution. unsure.



fme ticket response from Technical Support Specialist I, FME Flow, after I informed him of my solution:

I'm glad to hear that the Sharepoint connection is back online! 2025.x introduced some rather major changes with how FME handles connections and authentication, and this extends to the SharepointOnlineConnector transformer. I suspect what happened is that your SharepointOnline package was updated automatically to version 1.2.2 with the installation of 2025.x, and had to then be republished to Flow to properly reestablish the connection.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings