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:
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?
Jira Server 7.12
Excel is latest edition, part of a corporate 365 subscription.
OK, looks like I have managed to solve this myself, but it was tricky. I had previously found this article, https://community.atlassian.com/t5/Jira-questions/Fetch-data-from-JIRA-to-excel/qaq-p/198786 , which initially didn't look like what I needed.
Studying the comments in more detail there was one from Brendan Walker, dated 15 Nov 2018. Here is my variation on his process, which looks to be working for me:
Thank you Brendan.
My main gripe though, and this was consistent with the download of a CSV file and import from an offline file, is that the field to describe what type of Issue each row is (Task, Story, Bug, etc) is a non-printable field, so just comes up as an empty column with title "T". I could perhaps fudge this with a range of aggregated filter queries per each type that I am interested in, but that seems a bit over the top.
We’re excited to introduce external collaboration for Confluence, now available in early access. It is available to preview for Confluence Cloud Premium and Enterprise customers. (If you're not on ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events