| Div | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
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 field 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
| Code Block | ||||
|---|---|---|---|---|
| ||||
{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} |
Example Result
Other Examples
Visit our full list of product examples for additional inspiration!
| Include Page | ||||
|---|---|---|---|---|
|
| Include Page | ||||
|---|---|---|---|---|
|