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.