Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Introduction

This plugin is based on the default bundled JSON Tool.

This plugin was created to solve use cases where we need to format perform post-processing of the JSON response of a JSON API call in order to store before storing the data into a form or workflow variable.This plugin can be considered as an alternative to the default bundled JSON Tool. 

The configurations are exactly similar to the default bundled JSON Tool in Joget, just with an additional optional property to write bean shell a BeanShell script to format/modify the JSON response. The post-processed/formatted response is also returned at the end of the execute() method for further integration use case.

This plugin works just like the default bundled JSON Tool in Joget, but with the following added abilities:-

  • with GET, PATCH, PUT, and POST methods.
  • Send files in POST method.
  • Receive file and store into a Joget form file upload.

The plugin source codes can be found at JogetOSS Github. Feel free to clone and customize to suit your needs.

Enhanced JSON Tool Properties

Note
iconfalse

To learn how to configure the JSON Tool plugin, do see the KB page for for JSON API Tool.

This plugin's configuration is identical, only with the additional configurable properties below.

Format Response

NameDescription
Enable Response FormattingWhen checked, you can start writing
bean shell
a BeanShell script to format/post-process the JSON response.
Script

The "Enable Response Formatting" property must be enabled in order to write

bean shell script here.

the BeanShell script here.

Injected Variables:

  • data - This is a Map object of the JSON response from the JSON API call.

Expected Return Object:

It is expected to return a Map object that would later on be processed as configured to store to form and/or workflow variables.

Example:

Return the response only for the first item in a JSON array with the object name "apps".

Code Block
languagejava
return data.get("apps")[0];

Image Added

Figure 1: Enable Response Formatting

Download Sample App

APP_enhancedEnhanced_jsonJSON_tool-sampleAppTool.jwa

Notes:

  • This sample app already includes the Enhanced JSON Tool plugin. So just import it into your Joget server and start using !it.
  • The API Domain Whitelist / API IP Whitelist setting in General Settings needs to be configured to allow JSON API requests, in order for this sample app to work.