Creating report in confluence with inputs from Jira projects

Neeti Dargan

I need to create a weekly project status confluence report wherein there will be approx 15-20 projects tobe included.

All these projects will be created in Jira as well  which will used for test execution purpose.

Now in order to reduce the manual effort of the team, is it possible  to get all the details( project start date/end date, total test cases, defects etc) from each of the jira project and put them in the confluence report

Something like below?

 

Project Name	Start Date	End date	Total test cases	Passed	Failed	Defects
DM1234	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project
DM5678	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project

 

Radek Dostál

Not easily I reckon, if you do some googling around this you'll find some discussions like these:
 # https://community.atlassian.com/t5/Confluence-questions/User-Macro-fails-with-Ajax-call-to-JIRA/qaq-p/1167186

 # https://community.developer.atlassian.com/t/post-requests-to-applinks-proxy-fail/32516

 

I don't know what "Get from Jira Project" means really, but I will just assume you know how to get it, either via some jql query or otherwise.

The only idea I see here is that you could create a user macro that will fetch the data from Jira, you process the response, generate the table, render that table.

This would rely on application link between Confluence and Jira and using some form of applink proxy (similar to those posts above) so that the calls to Jira are authenticated by the user.

Without app links, you'd have to hardcode some auth credentials into the user macro, which would be entirely unsafe and negligent.

 

I can't give you any example of a proof of concept as I've never done this, but there should be a way to make this work (though with a lot of struggle).

I suspect it will require a heavy dose of javascript, which I don't know whether the user macro will even allow; though it should allow jQuery so I assume it's fine with JS.

I'm reasonably sure that a user macro is too minimalistic for this type of thing and it would be entirely too complex to fit a single little text box.

It probably will be pretty performance unfriendly also. A loaded page should be cached and okay, but loading several of such macros might start to be a concern depending on the complexity.

 

Long story short, this would be better as a plugin which will supply a macro for this, with actual backend support to do all the calls and reformats and so on, plus it has better access to Application Links API.

I think a user macro might be capable of doing it, but it's simply not a good fit. Also there is still a question whether a user macro will support script tags, or that the app link proxy endpoints work, etc.