Overview

This page shows an example of how to extract data from the Atlassian Marketplace to show how easy it is to show current information in Confluence from any available JSON source. In this case, the data is publicly available from Atlassian Marketplace.

Macro Browser Input

Select this Macro

Macro Name	JSON Table
Macro Syntax	{json-table}

Define these Parameters/Values

Paths to fields	versions
Auto number on each row	selected
URL to JSON data (example)	https://marketplace.atlassian.com/rest/1.0/applications/jira
Columns to show	version, buildNumber, releaseDate
Augments to heading row values	Version, Build, Release Date
Column types	S,I,MYYYYMMDDHHmmssZ~YYYY-MM-DD

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}