Microsoft Excel Online Connector - Token Expiration

Michael Gantt

• June 01, 2024 17:37

I recently added the Microsoft Excel Online connector which uses the Microsoft Graph APIs.  I can successfully connect to my spreadsheet and update values in the spreadsheet.  However, the authentication fails after a few hours and I get this error in my flows:  {"error":{"code":"InvalidAuthenticationToken","message":"Lifetime validation failed, the token is expired.","....  Does anyone know how to make this token refresh so that it doesn't constantly expire and cause errors in the flow?

0

• 

  Tyler Lamparter Principal Product Manager

  • June 03, 2024 02:06

  

  

  

  

  

  Michael Gantt go to your connection, toggle to HTTP, then add offline_access to the scopes.

  

  0
• 

  Michael Gantt

  • June 05, 2024 03:05

  

  

  Thank you Tyler Lamparter!  This worked and the connection has been up for a few days now.  Any idea how often re-authenticating may be required?

  0
• 

  Tyler Lamparter Principal Product Manager

  • June 05, 2024 03:33

  

  

  

  

  

  Michael Gantt I would guess 90 days based on this article? https://learn.microsoft.com/en-us/entra/identity-platform/refresh-tokens

  0
• 

  Michael Gantt

  • June 05, 2024 13:28

  

  

  Makes sense.  Thanks again!

  0

Please sign in to leave a comment.