In Excel, I can use a web source to connect to Jira like so:
https://mysite.myjira.com/sr/jira.issueviews:searchrequest-csv-current-fields/37125/SearchRequest-37125.csv
I can set a basic authentication, enter my username and password, and it works just fine. But... In the CSV export "link", "label" and various other fields are split in columns. This is apparently a feature (https://jira.atlassian.com/browse/JRASERVER-62217) - but it is hard to work with a variable data foundation in excel.
So, I wanted to use the HTML option instead, which does not split the returned result into columns:
https://mysite.myjira.com/sr/jira.issueviews:searchrequest-html-current-fields/37125/SearchRequest-37125.html
When I create this web source (or modify the existing csv source) Excel says "invalid credentials".
I then tried embedding my username and password in the URL and using "anonymous" login, like so:
https://mysite.myjira.com/sr/jira.issueviews:searchrequest-html-current-fields/37125/SearchRequest-37125.html?os_username=ABC&os_password=abcde
This resolves the credentials part, but something strange happens; On top of Excel I am presented with an Internet Explorer open/save/cancel dialogue asking me to save/open/cancel the returned file. It does not matter what I click. When investigating excel afterwards an HTML page is in fact returned, but it is a "navigation to this web-page was cancelled"-web-page.
Anyone has any ideas on how to make the excel html integration work, an idea about what is going on, or what to try next?
PS. If I save the HTML page to disk and create an excel web-source to the file on disk, it works perfectly.
PPS. For policy reasons I can't use a plugin that gives me acces to the entire Jira DB from excel, so that option is out.
/Henrik
