How to build a JSON table from an array - Cloud

Overview

This page shows how you produce a simple table from JSON data using the JSON Table macro, which is part of the Advanced Tables for Confluence app.

Macro browser input

Select this macro

Macro nameAdvanced Tables - JSON Table
Macro syntax (Old editor){json-table}
Macro syntax (New editor - case insensitive)/JSON Table

Define these parameters/values

Paths to fields$
Paths to fields to be includeda,b,c
Auto number on each rowOn
Auto total rowOn

Macro body

Old editor:

New editor:


[{a:10,b:20,c:30,d:40},{a:15,b:6}]

[{"a":10,"b":20,"c":30,"d":40},{"a":15,"b":6}]

Parameters set in the macro editor

The macro looks as follows before the page is published:

Wiki markup input (Old editor)

{json-table:
paths=$|
fieldPaths=a,b,c|
autoNumber=true|
autoTotal=true}
[{a:10,b:20,c:30,d:40},{a:15,b:6}]
{json-table}

Example result

Other examples

Visit our full list of product examples for additional inspiration!