Overview

This page shows how to use Augments when using the JSON Table macro, which is part of the Advanced Tables for Confluence app. In this example, one of the columns that is an embedded JSON array field is expanded into a table using the wiki markup version of the JSON Table macro. This data is taken from publicly available download data on 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 format > Paths to fields	versions
JSON Table settings > Data format > Paths to fields to be included	version,sums
JSON Table settings > Data format > Augments to data row values	,"{json-table: paths=monthlies\|fieldPaths=month,sum\|sortColumn=1\|sortDescending=true\|autoTotal=true\|headingAugments=Month,Total}%2%{json-table}"
JSON Table settings > Data format > Augments to heading row values	Version, Downloads
Column settings > Numbering & Totaling > Insert auto number column	On
JSON Table settings > Data settings > Output format	wiki
JSON Table settings > Data source > Method of locating JSON data (URL) > URL of JSON data	https://marketplace.atlassian.com/rest/1.0/plugins/org.swift.confluence.table/downloads?startDate=2013-01-01&numVersions=4

Screenshot

Wiki markup input

To get this example on your own page, edit the page, copy the text below and paste into the Insert > Markup dialog for Confluence wiki.

Wiki markup equivalent

{json-table:output=wiki|
paths=versions|
fieldPaths=version,sums|
url=https://marketplace.atlassian.com/rest/1.0/plugins/org.swift.confluence.table/downloads?startDate=2013-01-01&numVersions=4|
headingAugments=Version,Downloads|
augments=, "
  %[%json-table:
    paths=monthlies%!%
    fieldPaths=month,sum%!%
    sortColumn=1%!%
    sortDescending=true%!%
    autoTotal=true%!%
    id=$mpKey.%1%.month%!%
    headingAugments=Month,Total%!%
  %]%
  %2%
  %[%json-table%]%"|
autoNumber=true|
sortColumn=1|
sortDescending=true}
{json-table}

Live example

Using augments with JSON table - Live example

Example result

Other examples

Visit our full list of product examples for additional inspiration!

Use augments with JSON table - 8.x