Automation; display results of web request in table

[Brian King]

I've setup a new Confluence Automation Rule which calls an API, and gets back a list of items.

I've got an 'Edit Page' action which is editing an existing page to append the results.   The results are in a 'Smart values code snippet' as below:

{{#webResponse.body.issues}}
   {{fields.duedate}} {{key}} {{fields.summary}} {{fields.status.name}} 
{{/}}

This is working fine, with the results being appended to the page.  However I'd like the results to be displayed as a table.  I've not been able to work out how to do this.

[David Nickell]

This looks like Work Item data, which, you could use a Filter Results Widget on the confluence page to display.   Instead of creating  the displayed results, use your automation to flag the results in JIRA (perhaps with a label or dedicated checkbox).  then all the basic tools (FIlter, Confluence widget) will do all the heavy lifting for you.  In addition, your flag (or filter) can be used to drive other reporting or meeting discussions.

One other thing -- be sure you know how long you want the results included on your page. 

• You may want to clear flags before your automation runs so as to keep the return list accurate
• Or, maybe the list is also governed by some other attribute.  For example your page is sprint specific so your filter should include sprint in the JQL.

I'm guessing by the time you've read this sentence you've already coded a workable solution :-).  Hope this helps