Our main API using Auth0 with oAuth2 for authentication. We have our resources setup successfully and they work well through Retool. Where things get a little wonky is [what I am assuming] when refresh tokens are used to get a new JWT.
When a user comes back to a Retool app which they used, say yesterday, data fetched using oAuth2 doesn't always show up. Refreshing the page once or twice then successfully retrieve the data for this app and any others being using in Retool. There was already an active oAuth session, so no they are not being asked to login again.
To help with this I built a specific app named "oAuth Check - Run first". It's basically two tables which access our main api endpoints used in Retool and load data on app load, assuming the all the auth is ready. This app is now accessed first to ensure all is connecting correctly. If no data shows, refresh the page until it does. It works, but doesn't seem right.
This app works, but doesn't seem right, so I am reaching out to see if perhaps I have something configured incorrectly, or perhaps others have seen this issue and have found a way around it.