Transform JSON

Transform JSON activity takes input data in JSON format and transforms it into JSON format according to the Jolt specifications.

General

The General tab has the following fields.

Field Literal Value/Module Property Description
Name No The name to be displayed as the label for the activity in the process.
Spec File Yes Specify the location of Jolt specification file.

For more information, see Jolt Specification at Github.com.

Note: The input specification file takes priority followed by the Spec File in the General tab. If none of the specification files are provided, then the specification file generated from mappings is used.
Input Json Schema File Yes The input json payload file location. The file provided must be a valid json file with a .json file extension. The .json file must contain either a sample json payload or a valid json schema string. The first element of the payload must have all the elements that need to be mapped. If the input provided is a json schema file then output must also be json schema.
Output Json Schema File Yes

The output json payload file location. The file provided must be a valid json file with a .json file extension. This .json file must contain the output json payload.

Note: The first element of the payload must have all the elements that need to be mapped. This is valid only in case of the json payload file.
Build Spec File No Select the Map Input Output Json button to open the Jolt Json Mapper dialog. For more on the Jolt Json Mapper dialog, see Jolt Json Mapper

Description

Provide a short description for the Transform JSON activity.

Input

The Input tab has the following fields.

Field Description
JsonInput Mandatory. Input content in the JSON format.
SpecContent Provide Jolt specification file content in the JSON format.

You can either provide a path to the file in the General tab or provide file content in the SpecContent field.

Output

The Output tab has the following fields.

Field Description
JsonOutput Output in the JSON format converted as per the Jolt specification used.

Fault

The Fault tab has the following fields.

Fault Generated When.
JSONTransformException There is invalid Jolt specification file or JSON input.
Note: If you are using an external file for JOLT specification in SpecContent field, make sure that the file path is accessible to the application container.