Build a Simple Table from Rest API Data - 8.x

Owned by Former user (Deleted)
Last updated: Aug 27, 2019
2 min read

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 app.

Macro Browser Input

Select this Macro

Macro NameAdvanced Tables - JSON Table
Macro Syntax{json-table}

Define these Parameters/Values

JSON Table settings > Data format > Paths to fieldsissues
JSON Table settings > Data format > Paths to fields to be includedkey,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

https://bobswift.atlassian.net/rest/api/latest/search?jql=key%20in%20(TBL-174%2C%20TBL-300)%20order%20by%20key

Column settings > Numbering & Totaling > Insert auto number columnOn

JSON data

Click on the URL link above to view the live JSON data.

Screenshot



Wiki Markup Input

{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!