This article explains how to create tables and list issue from Jira to the Confluence page using Confluence Command Line Interface (CLI) and Jira Command Line Interface (CLI).
Instructions
Follow the below steps:
Combine getIssueList to list issues for a JQL query and storePage to create or update a Confluence page.
-a run -i "myjira -a getIssueList --jql project=TESTMKJMWE --columns 1,2,3,4 --outputType html -f @temp" -i "myconf -a storePage --replace --space SPAC --title SPAC --parent @home --noConvert -f @temp"
--jql input the JQL query which you want to display the list on the confluence page.
--columns specify the column names you want to display.
--outputType specify the output format type. Valid values are: text, table, HTML, JSON, variables.
--space enters the space key.- s
It is recommended to test this scenario in a non-production environment, or run the action with the --simulate parameter, to verify the behavior before deploying in the production environment.