I use 'Get Data' -> 'From Other sources' -> 'from Web' option in Excel. I give the below URL
to get defect/issue data from Jira. But what I get is html script. I googled and found a suggestion to append '?' at the end of the URL. By doing this, I am prompted to key-in Jira login id and password. I choose the option to use my Windows login credentials. When I click on 'Ok' button, nothing happens. And if I click on 'load' option, I see hour glass and then the request times out. How to resolve?
Ganesh, I request you to read my problem statement again. I know how to write a JQL query and I also know about the export option using which one can export. What I am not able to get working is, from within Excel 2016, I use 'get data' from 'Web' option where I give the URL. But excel fails to get data from Jira
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