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 Name | JSON Table |
Macro Syntax | {json-table} |
Define these Parameters/Values
Paths to array fields | versions |
Paths to fields to be included | version,sums |
Auto number on each row | selected |
Output format | wiki |
URL to JSON data | https://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 values | Version, 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.
{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!
Log a request with our support team.
Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.