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

Advanced Tables JSON Table macro settings for simple REST API data

Advanced Tables simple REST API JSON table rendered on a page

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

Advanced Tables JSON data sample for simple REST API table

Other examples

Visit our full list of product examples for additional inspiration!

How to build a simple table from REST API data - Cloud