VBA - JIRA authentication with google

[Craig Booth]

I would like to be able to extract data from JIRA straight into Excel using VBA,  i use a google account to log in and so dont have a username and password for JIRA,  I Have added a API Token but am unsure how i send this via VBA 

[Petter Gonçalves]

Hello Craig,

Welcome to Atlassian Community.

Without a valid user and password configured on JIRA, you will not be able to export any data from JIRA.

You still need the same credentials exporting data using REST API, for security reasons.

Once you have authenticated, you can follow the steps below to properly import your JIRA issues to Excel:

1. Create a filter view in Jira with all of your desired columns, save it, and make a note of the path.  Example: https://mycompany.atlassian.net/issues/?filter=11940

2. Change the path to https://mycompany.atlassian.net/sr/jira.issueviews:searchrequest-csv-current-fields/11940/SearchRequest-11940.csv

Note that going to this URL in your browser returns a CSV file.

3. Start Excel, and select Data menu, New query, From Other Sources, From Web

4. A dialog will appear asking you for the URL. Paste in your CSV URL from step 2, and click OK

5. You will be prompted with a permissions dialog.  Select Basic authentication, enter your Jira username and password, and click Connect.

6. After Excel connects, you will see a dialog with a preview of the table.  Click Load to load it into the current worksheet. 

From this point forward, your Jira credentials will be cached, and you can update the query at any time by clicking Data/Refresh all.

Let me know if this information helps.

[Craig Booth]

Thanks for this, 

i think my question is more, my client uses Google authentication, how do i authenticate in Excel using this sign in method as i don't have a JIRA specific user name and log on 

[Brian S]

Petterson, thanks for posting your solution which I successfully implemented in both Excel and Power BI. Unfortunately, within the past week, this solution no longer works for me with either Excel or Power BI.

I posted a new issue here a couple of days ago after discovering the CSV no longer successfully downloads.

Any tips you may have would be greatly appreciated.