...
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
...
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://bobswiftxxxxxxxx.atlassian.net/rest/api/latest/search?jql=key%20in%20(TBL-174%2C%20TBL-300)%20order%20by%20key |
Auto number on each row | On |
...
Parameters set in the macro editor
Wiki markup input (Old editor)
Code Block | ||||
---|---|---|---|---|
| ||||
{json-table: paths=issues| fieldPaths=key,fields.summary,fields.issuetype.name,fields.issuetype.id,fields.fixVersions[*].name| url=https://bobswiftxxxxxxxx.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!