| Div | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
Overview
This page shows how you bring Rest REST API data from a JIRA 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 | {json-table} |
Define these
...
parameters/
...
values
| JSON Table settings > Data format > Paths to fields | issues |
| JSON Table settings > Data format > Paths to fields to be included | key,fields.summary,fields.issuetype.name,fields.issuetype.id,fields.fixVersions[*].name |
| JSON Table settings > Data source > Method of locating JSON data (URL) > URL of JSON data | |
| Column settings > Numbering & Totaling > Insert auto number column | On |
| Tip | ||
|---|---|---|
| ||
Click on the URL link above to view the live JSON data. |
Screenshot
Wiki
...
markup input
| Code Block | ||||
|---|---|---|---|---|
| ||||
{json-table:
paths=issues|
fieldPaths=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!