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
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events