SSO, Graph and ExecuteFunctions

[davidk43]

Hi,

Hoping someone could point me in the right direction. Have successfully run through the SSO Node Js example (great work, thanks!) but as I'm looking to extend this into a xls/ppt solution I'm coming up short.

The key thing I'd like to solve for is an Add-in command from the ribbon being able to call Microsoft Graph via an ExecuteFunction.

1. How could we establish the SSO/accessToken without having to go to a taskpane and click a button (or force click). A user may want to click a ribbon function without that detour.
2. I'm not seeing how the Graph element of the example is reusable - the SSO and token generation seem tied to a route
3. ExecuteFunctions I believe can't call a route
4. Sharing the runtime may help share the accessToken to an ExecuteFunction but that could go stale, how would it get renewed if only generated via a route
5. Could store that accessToken in localStorage but during a longer xls/ppt session this would go stale and back to the renewal issue above
6. I've seen some mentions around the solution for this is to have that ExecuteFunction requiring a non-stale token (so essentially call a fresh one) to literally be a nested second app on its own route. I'm new to React and that concept I'm struggling with

I'd appreciate any thoughts or guidance on the right way to approach this.
Really appreciate all the hard work going into this!

Many thanks
David