Importing to excel without need to add username/password

Adam Lee April 16, 2020

I currently import data from a JIRA board/filter to Excel using the power query with basic credentials type and then username/api key for the log in. This topic is covered extensively in link below. I find once the data is in excel it can be manipulated very easily and the dashboards that can be produced are very useful. I then have a refresh button that repeats the power query import and updates the dashboards (is this considered a rest API)? 

https://community.atlassian.com/t5/Jira-questions/Fetch-data-from-JIRA-to-excel/qaq-p/198786

My issue is that only i can refresh the dashboard due to the basic credentials setup and would like to have it set up in a way that anyone in the company can open the file and refresh the data. I have added the username and password to the URL on other ticketing programs - redmine etc, however i believe the os_username&os_password has been disabled from jira. 

https://confluence.atlassian.com/jirakb/jira-cloud-os_username-and-os_password-embedded-in-url-no-longer-available-868988403.html

Is there a workaround? This has been bugging me for a while, any help is greatly appreciated.

1 answer

0 votes
David_Bakkers
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 26, 2020

Since you're using Jira Cloud, you'll have to switch to using a token for the authentication, not basic authentication with username / password.

Still, each user will need to generate their own token for their account and use it to make the query.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events