Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Div
idProductTOC

On this page

Table of Contents
maxLevel1
excludeOn this page
typeflat
separatorpipe

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 NamenameAdvanced Tables - JSON Table
Macro Syntaxsyntax{json-table}

Define these

...

parameters/

...

values

JSON Table settings > Data format > Paths to fieldsversions
JSON Table settings > Data format > Paths to fields to be includedversion,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 valuesVersion, Downloads
Column settings > Numbering & Totaling > Insert auto number columnOn
JSON Table settings > Data settings > Output formatwiki
JSON Table settings > Data source > Method of locating JSON data (URL) > URL of JSON datahttps://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
titleWiki 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

/wiki/spaces/TBL/pages/134152250

Example

...

result

Image RemovedImage Added

Other

...

examples

Visit our full list of product examples for additional inspiration!Image Removed