Excel add-in not working - data is not showing up in table

Question

Had some general issues with the add-in not working & add-in panel not working at all.

Now the add-in appears to be working, and I connect it to my Atlassian account.

But when I run the query, the panel shows an updated "last updated", but the data never gets updated in the table, and the panel gets frozen in "importing".

David Nickell · Answer

it's PowerQuery -- no VBA required.

you can do this on your own too-- but the tricky stuff I have figured out for you includes building the call with your API Key, pagination (there is no 1,000 limit here), and getting the child entitities (worklogs, changelogs, comments, etc...)

You can plug this example call into a browser (of course, adjust it with your URL and poject key).  The Result is JSON

https://splitdimedata.atlassian.net/rest/api/3/search?jql=project=CONFIG

You can execute these REST calls directly from Excel. You go the Data Tab > Get Data > From Web.    To do it in Excel, you have to provide an Authorization Header.

if you want to learn a little more, feel free to shoot an email to me (dnickell@splitdimedata.com).  We can hop on a zoom call (or maybe I will record a quick video) showing you how you can do the simple calls on your own.

Thanks

TalisS · Answer

Hey David, thanks for the reply. Depending on the method being used to achieve this within the file (I'm assuming it's VBA?), I would first need to square it away with my cyber security admin.

David Nickell · Answer

Good moring.  If you are still stuck, I can provide you with an excel file that will accept your instance URL, your API Key, and your JQL (or Filter) to pull back all of the issues plus the changelogs, worklogs, and comments.

This is all done through the Atlassian REST APIs directly into Excel.  This is NOT a plugin and there is nothing to install.

I am offering this to you for free in exchange for your feedback. Next week this spreadsheet will be bundled in with our PowerBI Reports and sold under monthly licensing agreements.

Thanks