how authentication works when accessing an Excel filter export via URL

Question

I have a filter that I want to easily export to Excel.  If I am logged into JIRA in my (Chrome) browser and enter the URL

https://my_jira_domain.com/sr/jira.issueviews:searchrequest-excel-current-fields/16301/SearchRequest-16301.xls?tempMax=1000

it automatically downloads the spreadsheet (exactly what I want!).

If I put that hyperlink into an Excel spreadsheet and click from there, it asks for my username and password.

Here's what I can't reconcile... any other JIRA link that I've tried - accessing the main page, a dashboard, or the filter - from a hyperlink in Excel works without requesting a username and password.

It will work if I put the user/pass into the URL (&os_username=username&os_password=password) but I'd really like to avoid that for the obvious security reasons.

Any advice welcome - thanks!

Cecilia Briozzo · Answer

I have the same problem. I'm tying to add a new query from Data menu, New query, From Other Sources, From Web, with the url: https://my_domain.atlassian.net/sr/jira.issueviews:searchrequest-csv-current-fields/39307/SearchRequest-39307.csv

And it does not connect, I select Basic authentication, type my username (my email), and mi jira password, but it does not connect. I receive: The user was not authorize

If i do the same steps but with url: https://my_domain.atlassian.net/, and select Basic authentication. It does connect with the same credentials but, then it does not connect to the filter.

What am I missing?

JHFB · Answer

I just tested this in Internet Explorer and I am experiencing the same issue...

JHFB · Answer

Thanks, Petar - maybe it's a Google Chrome specific issue. I am logged into JIRA within Chrome and when I click the link in Excel, it opens a new tab within that same session and asks me for a password. Any other link I've tried this way, including https://my_jira_domain.com/issues/?filter=16301, has worked.

Another tidbit - initially this worked for me. I always stay logged into JIRA and when I created the
spreadsheet with the link, the link worked. I wanted to see what happened when I logged out of JIRA and tried to open the link. Now I can't seem to "log back in".