On this page
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:
- Within your Confluence page.
- From a file residing on the Confluence server (Server only).
- From a Space Template (Server only).
- From a page attachment.
- 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 for modifying column headings and column data.
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
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)
Other Macros
Below is a list of all other Macros available within this Add-on:
-
Attachment Table Macro (Advanced Tables for Confluence)
-
CSV Macro (Advanced Tables for Confluence)
-
JSON Table Macro (Advanced Tables for Confluence)
-
Table Plus Macro (Advanced Tables for Confluence)
Additional References
- JSON.org home
- JSONPath
- JIRA REST API Example - Query issues
- Confluence Remote API Content examples
- Augments
- Common table capabilities
- Scripting for Confluence
- Run CLI Actions in Confluence
- SQL for Confluence
- Beanshell Macro
- Groovy Macro
- Jython Macro
- How to deal with templates on Confluence 4.3 and later
