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

[TalisS]

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]

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

[TalisS]

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]

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

[Joseph Chung Yin]

@TalisS -

Welcome to the community.  Since this is related to add-on (not out of the box provided by Atlassian) against your instance, you need to reach out the add-on vendor to obtain their technical assistance directly.

If you need to find out which add-on vendor, you should work with your Jira/JSM system admins to identify the vendor associated with the add-on in question.

Sorry.  Hope this helps.

Best, Joseph Chung Yin

[TalisS]

Hey Joseph, thanks for the quick response.

But I'm a bit confused, as the add-on is "published by" Atlassian.