Excel Add-in (Import data from Jira) Issues

[Adam Owen]

Getting an error message when trying to import Jira data using the Excel add-in. The error message is "must set field "siteId" in request":

[Aron Gombas _Midori_]

@Adam Owen "siteId" means that the Excel add-in should specify the Jira Cloud site it connects to. I think this is not something you as a user should enter anywhere, but the add-in should "just know".

Please try to connect the add-in to your Jira site again.

[Lydia Kerr]

Hi There Aron,

I too am having the site id problem again - but none of my tricks are working to fix it. 
How do I re-connect the excel jira add-in to my jira site again?

I have tried logging out of excel completely.
I have tried opening a new worksheet and running a new query  (hoping I would get the screen that asks me to login and input the code) but that is not working

Any tips?
Thank you

[Lydia Kerr]

found an answer on another thread that did work!
used the 'hamburger' menu on the Jira cloud for excel add-in 
and clicked connect another site - 
that led me to the number sign in page and I was able to re-authenticated!
yea!

[Ellen Ling]

Yeah!  It fixed my issue.  Thank you!

[David Nickell]

I do not know about the add-in, but I recommend you use the REST API and power query.

I don't think I can attach the Excel file I use -- if you'd like it, leave a comment with your contact info and I can email it to you or I'll put it my website for you to go get (free of course).

All you should need to change is a few parameters (URL, API, and JQL):

In this screenshot you'll see I just ran this at Atlassian to get the issues created in the last 5 days

Here are the parameters.   Your Auth parameter in the cloud install is "Basic" not "Bearer".  If you need assistance with that, let me know