Import JIRA REST API results to Excel Web Power Query

[Nigel Domaingue]

I am trying to create a Power Query feed into an Excel file that presents all the Issues listed under a given Epic.  I have already verified that the REST API URL delivers the content that I am looking for by testing it in the Restless browser plugin, and here is the query:

https://jira.XXXXXX.com/rest/api/latest/search?jql=cf[10182]=XXX-845

In Excel, I start creating a new Get Data: From Web import.  In the Advanced view, I provide my validated URL. 

Without any additional config information, I get an error 400, which I assume is because our Jira server requires authentication.  No problem, maybe it needs the same Basic authentication that the Restless plugin needed.

So, I add an HTTP header of type 'Authorization', and provide the details that the Restless client used successfully.

Next error is this: "The 'Authorization' header is only supported when connecting anonymously. [...]"

Has anyone else managed to successfully import REST API data from a Jira Server into Excel and can offer solutions for my problem, so that I can import my data feed into my Excel dashboard?

Regards,

Nigel

Jira Server 7.12

Excel is latest edition, part of a corporate 365 subscription.

[Phill Fox · Accepted solution]

Hi Karoline Brugger

You may be interested in this open suggestion with Atlassian on Clone permission that has been around since 2005.

https://jira.atlassian.com/browse/JRA-8497

As a requirement it has not yet received many votes and so will not be highly featured on the list of desired functionality for Atlassian. 

There is a workaround in here to disable the Clone link that you could try but as this will then remove it from the instance that may not be an appropriate solution. 

As commented by @Mark McCormack you can use ScriptRunner for JIRA to also hide system/plugin UI elements based on conditions but that would require you to have this plugin installed in your system.

Phill