Hello @casselgard, thanks for posting! Are you using the Sharepoint List Reader/Writer or the SharepointConnector?

For security purposes, authentication tokens almost always expire after an allotted time. The duration before expiry is determined by web application providing the token, not FME itself. Unfortunately, it doesn’t look like there is a way to configure the lifetime of a refresh token on the sharepoint side.

Another thought would be, see if there is an API call you can make at the beginning of your workspace to fetch a new refresh token each run.

We have seen others use simple workspaces to renew refresh tokens as well. If you know your token will expire in x days, you could schedule a process to read a single feature or similar to invoke the token exchange. Hope this helps, Kailin! 

Thanks for helping, Kailin!

I'm using the SharepointOnlineConnector.

In FME Flow I have scheduled that each night I read features using my webconnections. It has been working so far, but only four days yet.

As I understand your last section this could be a solution to keeping the connection alive "forever" withouth having to reauthenticate with my Microsoft credentials?

Hey no worries @casselgard! I suspect you will have to reauthenticate eventually, or if your Flow ever goes down for example. I know sharepoint refresh tokens have a lifetime of 24hours, so I think this should work.

Actually, it looks like you can prolong the access_token expiration to 90 days (on the sharepoint side). Happy to help, Kailin. 

Not sure why, but I never have to reauthentice my sharepoint online webconnection.

It is setup as multi tenant tho.