Forum Discussion
Tricking VBA when updating Power Query
Hi all, I have a spreadsheet where I need the user to add their API Token so that I will get some JSON data. I do not want them to drop the value in a cell because they might forget about it and...
Hey lbendlin thanks for your message! Not much on tokens tbh but my understanding is that they have no expiry date. They stick with a particular user. I am not sure I understood your second query.
Tokens normally expire rather fast (an hour or so) and you usually need to get a refresh token.
So if your process stores the initial token, and it expires after an hour - that would mean the stored token can not do any harm and doesn't need to be cleared.