Excel Add-in (Import data from Jira) Issues
Adam Owen
I'm New Here 
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
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":
1 answer
David Nickell
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.