How to generate API Token for Excel using

[Dobryn Iryna]

Hi Team,
Could you please explain how to generate API Token for Excel using?
Thank you

[Mamta Bankoti]

To get an API token for excel, just open the website you want to connect  with, look for the option that lets you create an API key, click it and then copy the code they give you to use in Excel. 

[David Nickell]

I did an video the other day... see if this answers your question.  And if it doesn't, please let me know that as well.   https://www.youtube.com/watch?v=VHG9tUei9Xc

Note:  This technique gets the token.   That still has to be combined with your userid and colon to be a valid API Key.  

If you need a Ready to Use Key for an Auth Header, you can encode it yourself at: https://www.base64encode.org/.   NOTE -- You have to use your id and a colon plus your token to get a key.  (hence the arrow in the pic below).

Hope this helps