---
title: "How to build a JSON table from an array - Cloud"
canonical: "https://support.appfire.com/space/TBL/74810614/How%20to%20build%20a%20JSON%20table%20from%20an%20array%20-%20Cloud"
format: markdown
---
> Macro (aura-html)

# <span style="color: #000000">Overview</span>

<span style="color: #000000">This page shows how you produce a simple table from JSON data using the</span> [JSON Table macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74812316)<span style="color: #000000">, which is part of the</span> [Advanced Tables for Confluence](https://appfire.atlassian.net/wiki/spaces/TBL) <span style="color: #000000">app.</span>

# <span style="color: #000000">Macro browser input</span>

## <span style="color: #000000">Select this macro</span>

|  |  |
| --- | --- |
| <span style="color: #000000">**Macro name**</span> | <span style="color: #000000">*Advanced Tables - JSON Table*</span> |
| <span style="color: #000000">**Macro syntax (Old editor)**</span> | <span style="color: #000000">*{json-table}*</span> |
| <span style="color: #000000">**Macro syntax (New editor - case insensitive)**</span> | <span style="color: #000000">*/JSON Table*</span> |

## <span style="color: #000000">Define these parameters/values</span>

|  |  |
| --- | --- |
| <span style="color: #000000">***Paths to fields***</span> | <span style="color: #000000">*$*</span> |
| <span style="color: #000000">***Paths to fields to be included***</span> | <span style="color: #000000">*a,b,c*</span> |
| <span style="color: #000000">***Auto number on each row***</span> | <span style="color: #000000">On</span> |
| <span style="color: #000000">***Auto total row***</span> | <span style="color: #000000">On</span> |
| <span style="color: #000000">Macro body</span><br><span style="color: #000000">Old editor:</span><br><span style="color: #000000">New editor:</span> | <sup>[{a:10,b:20,c:30,d:40},{a:15,b:6}]</sup>  
  
<sup>[{"a":10,"b":20,"c":30,"d":40},{"a":15,"b":6}]</sup> |

## <span style="color: #000000">Parameters set in the macro editor</span>

![Advanced Tables JSON Table macro settings for array data](media://548f130a-dd93-4edb-ac25-2e8a0c808472)

![Advanced Tables JSON Table macro with selected columns from array data](media://78165314-9c44-4524-a6c4-2ee9b62a4c49)

<span style="color: #000000">The macro looks as follows before the page is published:</span>

![Advanced Tables simple JSON table shown in edit mode](media://2bd355ad-6984-4149-8886-57e849c8cc53)

# <span style="color: #000000">Wiki markup input (Old editor)</span>

```plaintext
{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}
```

# <span style="color: #000000">Example result</span>

![Advanced Tables simple JSON table output in page view](media://692e1559-3432-4a37-ae11-16a16d1040b6)

# <span style="color: #000000">Other examples</span>

<span style="color: #000000">Visit our</span> [full list of product examples](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74814716) <span style="color: #000000">for additional inspiration!</span>