Overview

JSON (JavaScript Object Notation) has become a highly used interchange format because of its lightweight, simplicity, and ability for humans to read and write easily. Many REST APIs produce JSON format and the format is used predominantly in Atlassian REST APIs. There is also an abundance of support libraries associated with the format which makes it ideal for scripting output.

The JSON table macro can import, format and display JSON (JavaScript Object Notation) data from anywhere, by:

Reading the JSON data from any of these sources:
1. Within your Confluence page.
2. From a file residing on the Confluence server.
3. From a Space Template.
4. From a page attachment.
5. From an external URL.
Allowing customizable access to fields.
Supporting inclusion of Wiki Markup macros within the JSON data.
Combining with the Chart macro to produce powerful data visualization.
Leveraging the same table styling capabilities as the Table Plus macro.

This macro supports Common table capabilities.

Available in plugin release 6.3 and above.

Basic Use

This macro can be deployed using one of the following methods:

Selected from the Macro Browser	JSON Table
Markup Shortcut	{json-table}

Screenshot

Parameters

Click a column heading to toggle the sorting of that column.

Augment parameters

See Augments for details.

Common parameters

The following parameters are part of our common table capabilities that are available to many macros that produce or modify tables.

Click a column heading to toggle the sorting of that column.

Examples

Page:

Building a JSON Table from an Array
Page:

Building a Simple Table from Rest API Data
Page:

Building an Advanced Table from Rest API Data
Page:

Building the Atlassian Product Versions Page
Page:

JIRA Version List Using the JSON Table Macro
Page:

JSON Table Field Manipulation or Calculations
Page:

Using Augments with JSON Table

Compatibility

Chart Macro - the JSON Table Macro can be used to create data for a chart
Beanshell Macro - can be used to generate JSON Table Macro and data as output from Java code (use output=wiki)
Groovy Macro - can be used to generate JSON Table Macro and data as output from Groovy code (use output=wiki)
Jython Macro - can be used to generate JSON Table Macro and data as output from Jython code (use output=wiki)