On this page
Overview
This page explains how the Atlassian Product Versions page was created. It is an example of how to extract data from other applications that provide JSON data to show current information in Confluence. In this case, the data is publicly available from Atlassian Marketplace.
Macro Browser Input
Select this Macro
| Macro Name | Advanced Tables - JSON Table |
| Macro Syntax | {json-table} |
Define these Parameters/Values
| JSON Table settings > Data source > Method of locating JSON data (URL) > URL of JSON data | https://marketplace.atlassian.com/rest/1.0/applications/jira |
| JSON Table settings > Data format > Paths to fields | versions |
| JSON Table settings > Data format > Augments to heading row values | Version, Build, Release Date |
| JSON Table settings > Data settings > Column to display | version, buildNumber, releaseDate |
Column settings > Formatting > Column type (1 2 3) | S I MYYYYMMDDHHmmssZ~YYYY-MM-DD |
| Column settings > Numbering & Totaling > Insert auto number column | On |
Screenshot
Wiki Markup Input
{json-table:
paths=versions|
url=https://marketplace.atlassian.com/rest/1.0/applications/jira|
columns=version,buildNumber,releaseDate|
headingAugments=Version,Build,Release Date|
columnTypes=S,I,MYYYYMMDDHHmmssZ~YYYY-MM-DD|
autoNumber=true}
{json-table}
Example Result
See the live page: Atlassian Product Versions.
Extras
Jamie Echlin suggested linking to the product release notes. So the following was added to the JIRA section. Similarly for Confluence.
| JSON Table settings > Data settings > Output format | wiki |
|---|---|
| JSON Table settings > Data format > Augments to data row values | [%version%| https://confluence.atlassian.com/display/JIRA/JIRA+%version%+Release+Notes] |
Other Examples
Visit our full list of product examples for additional inspiration!