Show Jira Issues in Confluence Page for non-Jira users

Question

We have a project planning table in Confluence that contains among other things, Jira issues. The problem is we have stakeholders who often view this page and all they see are error messages from the Jira issues. My question is, is there a way to display the Jira issues as static text for those non-Jira users?

Ron Chan_s5h7f7 · Answer

Thanks for the suggestions @Davin Studer

However, those sound like it would involve quite a bit of setup and overhead especially since this table will be updated frequently. The table contains a combination of Jira and other content that are directly entered into the tables, I can't even imagine how pulling from a database solution would look like.

Was hoping for a lighter approach.

Davin Studer · Answer

There are a couple ways I could think to do this.

* If you happen to have the SQL app for Confluence you could directly query the database and put the results on the page in a table.
* You could use the REST api as a service account and then parse that and put it on a page.