Skip to main content

We have successfully created a Web Connection for Microsoft SharePoint Online and had it authorise on FME Flow and workflows use a FeatureWriter to update list items in SharePoint.

However, periodically (we suspect each day) an administrator will need to RDP to the server that hosts FME Flow, access the Web Application and Authorise the Web Connection otherwise workbenches error with the following message.

2024-2-12 09:46:10 | Microsoft SharePoint List Writer: Client-side error: '401 Client Error: Unauthorized for url: URL' returned from SharePoint. Error message was: ''

 

I have a suspicion that this is because as our FME Flow is hosted on-premise and is not configured for HTTPS. However, as the web connection maintains authorisation for a period of time I’m not 100% convinced.

Has anybody experienced this behaviour in the past? How was it solved?

We do have a ticket open with our infrastructure team to configure FME Flow for HTTPS and if this is the prime suspect then we can use this to push the priority.

 

Indeed the documentation does say that FME Flow should be configured for HTTPS

https://support.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection-for-FME-Flow-Multitenant

I suspect your hunch is correct but it could indeed be something else as well. 

It’s a bit tricky to try and debug these issues but you might find some more info in some specific logs: 

https://support.safe.com/s/article/fme-server-troubleshooting-connections-web-and-dat#Logs


I recently have to go click Authorize our web connection manually as well. (about 4 days ago that it just stop doing it) However mine is with Trimble TDIv4 web connection. Our FME Flow is configured for HTTPS.

It used to be able to reauthorize itself. I’m still trying to figure it out as well. 


Reply