Using Augments with JSON Table

On this page

Overview

This page shows how to use Augments when using the JSON Table macro, which is part of the Advanced Tables for Confluence add-on. 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 NameJSON Table
Macro Syntax{json-table}

Define these Parameters/Values

Paths to array fieldsversions
Paths to fields to be includedversion,sums
Auto number on each rowselected
Output formatwiki
URL to JSON datahttps://marketplace.atlassian.com/rest/1.0/plugins/org.swift.confluence.table/downloads?startDate=2013-01-01&numVersions=4
Augments to data row values,"{json-table: paths=monthlies|fieldPaths=month,sum|sortColumn=1|sortDescending=true|autoTotal=true|headingAugments=Month,Total}%2%{json-table}"
Augments to heading row valuesVersion, Downloads

Screenshot

Wiki Markup

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}

Example Result

Other Examples

Visit our full list of product examples for additional inspiration!