SQL Table Transformer: Convert JIRA Table Markdown to Confluence Table

To convert Jira Table Markdown to Confluence table:

  1. Add SQL Table Transformer macro container to your Confluence page.

  2. Place the Jira markdown text directly into the macro container body.
    Commonly used Jira table markdown is:
    ||Col 1||Col 2||Col 3||
    |Val 1|Val 2|Val 3|

  3. Edit the macro input parameters: set Input Body Type to “Direct JIRA Table”.

  4. To include all the data into the output table, leave “SQL Query” input parameter default value as is, i.e., “SELECT * FROM table_1”.

  5. Save the macro.

  6. Save the page.

  7. When the page loads you should see Confluence table, created from your JIRA Markdown text.