JSON To Table Formatter Plugin

Introduction

The JSON To Table Formatter Plugin is a Joget Marketplace plugin that transforms raw JSON data into a formatted table display inside your Joget apps and datalists. It’s especially useful when you’re working with APIs or JSON responses and want to present them in a tabular format without custom coding.

Plugin information

• Plugin Name: JSON To Table Formatter Plugin.
• Joget Editions: Enterprise & Professional Edition.
• Joget Versions Supported: DX 7, DX 8 or higher.

Get started

Prerequisites

• Joget DX 7 or DX 8 installed.
• A Joget app where JSON data will be displayed (datalist, userview, etc.).
• JSON data available from a source such as an API or form variable.

Where to get the plugin

You can download the plugin from the Joget Marketplace.

How to install

1. Log in to your Joget server (local or cloud) as admin.
2. Navigate to Admin Bar > System Settings > Manage Plugins.
3. Click Upload Plugins and select the downloaded .jar file.

How to use it

1. Open your list in List Builder.
2. Make sure the column contains valid JSON data. Example:

[
  {
    "User": "pr059337",
    "Date": "06-Jun-2024 4:11 PM",
    "Status": "Draft",
    "Remark": "N/A"
  },
  {
    "User": "pr059337",
    "Date": "06-Jun-2024 4:33 PM",
    "Status": "Comments Required (KAM)",
    "Remark": "Updated"
  }
]

3. Click the JSON column in the list.
4. In the Properties panel, go to Formatter.
5. Select JSON To Table Formatter.
6. Configure the formatter by adding the required JSON objects and columns Labels.
   
7. Click Apply Change and Save the list.
8. Preview the list to see the JSON displayed as a table.
   

Download Sample App