Overview

This page shows how you 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 add-on.

Macro Browser Input

Select this Macro

Macro Name	JSON Table
Macro Syntax	{json-table}

Define these Parameters/Values

Paths to array 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://bobswift.atlassian.net/rest/api/latest/search?jql=key%20in%20(TBL-174%2C%20TBL-300)%20order%20by%20key
Auto number on each row	selected

Screenshot

Wiki Markup Input

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