JSON Tools

Overview

Given a huge JSON to process and store in the database, this plug-in avoids using a long string in the process model and improves performances and memory usage. The big JSON can then be stored in a document and the document passed to the plug-in through a process instance.

Key Features & Functionality

Smart Services:

Load JSON to a database
Cast a JSON Array document to CSV document

Functions:

Validate a JSON
Validate a JSON against a schema
Remap a JSON
Filter a within a JSON
Run json expressions against json data

Appian AppMarket 28 days ago
v1.9.0 Release Notes
- Added new functions: appendJsonListByPath, deleteJsonElementByPath, jsonPathIfExists, updateJsonByPath
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 1 month ago
v1.8.2 Release Note
- Json-smart library upgraded for security patch.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 2 months ago
v1.8.1 Release Notes
- Fixing min version in plug-in
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 3 months ago
v1.8.0 Release Notes
- Adding pretty print json formatting function
- Adding functionality to evaluate json expressions and merge json data with text template.
- Functionality is based on this library: github.com/.../JSONata4Java
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 4 months ago
v1.7.0 Release Notes
- Adding functionality to evaluate json expressions and merge json data with text template.
- Functionality is based on this library: github.com/.../JSONata4Java
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 4 months ago
v1.6.0 Release Notes
- Replace references to private Appian APIs
- [private] com.appiancorp.common.ArrayUtil.asList(java.lang.Object[])
- [private] com.appiancorp.common.ArrayUtil.isEmpty(java.lang.Object)
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Anna P 9 months ago

Hi Team,

could you please help us in Load JSON to database configuration, there is no documentation so we tried to understand by looking into code but we observed parameters are different in SS configuration and the code.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 11 months ago
v1.5.0 Release Notes
- Upgraded ValidateJSONBySchema to validate JSON messages that have arrays at the top level, including nested arrays.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
pierpaolo.longobardi over 1 year ago

Hi, is there a way to download the older versions of this plug in?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket over 1 year ago
v1.4.1 Release Notes
- Upgraded json-path library for security fix
- Cancel
- Up 0 Down
- Reply
- More
- Cancel