Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Refreshing Bearing Token

I'm attempting to create a system that will pull data from an API that requires a token. While I was figuring everything else out I was just requestion the authorization in a query and then copy and ...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    1. I already have the authentication. I did that in a seperate Query because it requires connecting to a different endpoint of the same API then the endpoint I'm pulling the data from. What I'm trying to figure out is how to get that token into the authentication of other queries. Seems like it should be simple because I have the information from the authorization in a table. I *think* I should be able to just say something like "Authorization = Name of the field the token is in"

     

    2. I'm doing this in Excel and will be pulling the data from Excel into another program. It will not be a continuous run but I planned on using the "Refresh Query" property. The token expires every 2-3 days. 

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Slightly different format

       

      "Authorization= Bearer " & token