Unable to connect to JIRA API thru excel power query

[Srikanth Inuganty]

While trying to connect to JIRA API thru excel power query, I get a message "Access to the resource is forbidden".  Need help in fixing this.  I generated API Key from Jira (data center version) and tried to use it in basic authentication along with my user id to JIRA.  I still get the same error message.  What could be the cause and how do I get around it.

[Stefan Stadler]

Hi @Srikanth Inuganty 

using the API is usually possible by using the API token (which you mentioned you already have) using the Bearer authentication method. 

Maybe this quick link can help, but essentially, it is all about using the token in the correct, expected way. Combining it with your user ID means to use a user+password authentication, which will most likely not work - and should not be used if you have the option to use the bearer token method.

How to do Bearer Token Authentication in PowerQuery - YouTube

Hope this helps!

Stefan

[Srikanth Inuganty]

Thanks @Stefan Stadler .  I tried to watch the video and it is trying to connect to a dummy site and not JIRA.  

[Stefan Stadler]

Hi @Srikanth Inuganty ,

the site is basically showing the concept how to do that with PowerQuery.

Bearer authentication is a general concept, so the website from the video will work like Jira does.

To stick with the example of the video, this is what you would have to do:

1. Obtain the API Token for your user using the Jira UI

2. Use the Web.Contents function and pass the headers as follows. Replace the values in <> (of course, without using the <> in the final query):

Web.Contents("<jira_url>", [
  Headers = [
    Authorization = "Bearer <put_your_token_here>"
  ]
])

It is important to keep a space between "Bearer" and the token. Otherwise the headers would not be correct and therefore not have the correct effect.

Hope this helps!

Stefan