Overview

This page shows how to bring REST API data from a Jira query directly into a Confluence table using the JSON Table macro, which is part of the Advanced Tables for Confluence app.

Macro browser input

Select this macro

Macro name	Advanced Tables - JSON Table
Macro syntax (Old editor)	{json-table}
Macro syntax (New editor - case insensitive)	/JSON Table

Define these parameters/values

*Paths to fields*	issues
*Paths to fields to be included*	key,fields.summary,fields.issuetype.name,fields.issuetype.id,fields.fixVersions[].name*
URL to JSON data	https://xxxxxxxx.atlassian.net/rest/api/latest/search?jql=key%20in%20(TBL-174%2C%20TBL-300)%20order%20by%20key
*Auto number on each row*	On

JSON data

Click the URL link above to view the live JSON data.

Parameters set in the macro editor

Wiki markup input (Old editor)

{json-table:
paths=issues|
fieldPaths=key,fields.summary,fields.issuetype.name,fields.issuetype.id,fields.fixVersions[*].name|
url=https://xxxxxxxx.atlassian.net/rest/api/latest/search?jql=key%20in%20(TBL-174%2C%20TBL-300)%20order%20by%20key|
autoNumber=true}
{json-table}

Example result

Other examples

Visit our full list of product examples for additional inspiration!