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!

Build the Atlassian Product Versions Page - 8.x

On this page