Wiki markup equivalent for JIRA macro

[Jason Friedman]

I want to create a Confluence page via a RESTful or command line interface and want the page to include the results of JQL.

[Bob Swift · Accepted solution]

CLI Plugin for Confluence and then use the getIssueList action.

An example:

{csv:macros=true|autoNumber=true}
{cli:profile=jira|panel=false}
--action getIssueList --project ZJIRACLI --quiet --suppressId --columns "key,id,type,summary,description,fix Versions"
{cli}
{csv}

Only use suppressId if you are on version 3.9.0 or above.

[Jason Friedman]

Hmm. Typically I do something like this to create a page:

$ cat my_file
{toc}
h1. Big heading
Hello World!

Then, I add it:

$ confluence.sh --server http://localhost:8090 --user admin --password PASSWORD addPage --replace --space MYSPACE --title 'MYTITLE' --file my_file

For a JIRA issue list on a wiki page I'm thinking something like this:

$ cat my_file
{toc}
h1. Big Heading
{jira:jql="Project = 'MYPROJECT'"}

But, I don't know what that {jira} macro should like like.

[Bob Swift]

Ah, I mis-understood your question. You are just asking about the wiki parameters for the jira macro? Just do a jira macro and look at the storage format to see what the parameters are and translate into wiki format.

[Jason Friedman]

Perfect, that storage format is useful, thank you Bob! Here's what I did:

{jira:columns=summary,updated|server=OURJIRA|serverId=5f2d82c5-db7e-be3a-3a91-ae5c81b5d4ae|jqlQuery=summary ~ "SOME TEXT"}

[Scott Paden]

Why isn't there a simple markup like {Jira: FOO-123}?  At least in the context of Atlassian cloud where Confluence and Jira are in the same cloud instance / URL.

[Scott Paden]

OOPS, my bad.  That does work.