Skip to main content
  • EN

Hi All, 


We have recently ran into an issue with using a SharePoint Multitenant web connection of FME Flow.  

A connection/client id/client secret has been created in azure and used to creat the mutlitenant connection within FME form and then published up to flow.  This connection works the day of but when added to a schedule to run daily, it fails out the next time it runs.  When we go back in and authorize the connection again in flow, it seems to work.  

Is there a particular setting in the connection or azure to keep this connection active? 

Thanks, 

Hi ​@asellars_hdr, 

Thanks for posting! 
Are you using SharePoint List Reader/Writer or the SharePointConnector? Did the connection only fail on FME Flow or it failed on Form one day after as well? 

For security reasons, authentication tokens typically expire after a set period. The expiry timeframe is determined by the service providing the token, not by FME. If FME Flow hasn’t been fully configured to support the web service, it won’t be able to refresh the token once it expires.

After a web connection and its web service have been published to FME Flow the user will need to:

  • Ensure the app registration in Azure has a web platform configured. 

  • Specify the correct redirect URI in the web platform (https://<host>:<port>/fmeoauth). 

  • Generate a client secret and add this to the web service in FME Flow

  • Ensure the client_secret=cCLIENT_SECRET] parameter has been added to the Refresh Token Parameters in the web service. Note that this can only be set in FME Form and must then be published to FME Flow.

Depending on the error messages, another possibility is that you might need to deactivate Adaptive Session Lifetime Policies so you won’t have to reauthenticate tokens after every 24 hours. 
More troubleshoot steps can be found here: https://support.safe.com/hc/en-us/articles/25407743885965-Troubleshooting-SharePoint-Web-Connections-and-Services

If this solution doesn’t work for you, please feel free to share the error messages so we can further investigate! 

Reply


Community Stats

31,790
Posts
120,750
Replies
39,403
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.