| Div | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
Overview
This page shows how to use Augments when when using the JSON Table macro, which is part of the the Advanced Tables for Confluence app 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 Namename | Advanced Tables - JSON Table |
| Macro Syntaxsyntax | {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 → Insert > Markup dialog for Confluence for Confluence wiki.
| Code Block | ||
|---|---|---|
| ||
{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
/wiki/spaces/TBL/pages/134152250
Example
...
result
Other
...
examples
Visit our full list of product examples for additional inspiration!