Forum Discussion

kalspiros's avatar
kalspiros
Icon for Helper I rankHelper I
4 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

What's the lifespan of that token?  Are you chasing a non-existing problem?

  • kalspiros's avatar
    kalspiros
    Icon for Helper I rankHelper I
    4 years ago

    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.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      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.