JSON Tools
by Appian Corporation
Description
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.
Features
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
- Fix json
Release notes
- Added new function getdeepestvalidjsonpath
Version history (24)
1.11.1
Added new functions: fixjson (attempts to fix json errors often seen when generating via prompts)
1.10.0
Added new functions: fixjson (attempts to fix json errors often seen when generating via prompts)
1.9.0
Added new functions: appendJsonListByPath, deleteJsonElementByPath, jsonPathIfExists, updateJsonByPath
1.8.2
Json-smart library upgraded for security patch.
1.8.1
Fixing min version in plug-in
1.8.0
New Feature:
1.8.0 Adding pretty print json formatting function
1.7.0 Adding functionality to evaluate json expressions and merge json data with text template.
Functionality is based on this library: https://github.com/IBM/JSONata4Java
1.7.0
Adding functionality to evaluate json expressions and merge json data with text template.
Functionality is based on this library: https://github.com/IBM/JSONata4Java
1.6.0
Replace references to private Appian APIs [private] com.appiancorp.common.ArrayUtil.asList(java.lang.Object[]) [private] com.appiancorp.common.ArrayUtil.isEmpty(java.lang.Object)
1.5.0
Upgraded ValidateJSONBySchema to validate JSON messages that have arrays at the top level, including nested arrays.
1.4.1
Upgraded json-path library for security fix
1.4.0
Added a new function called validatejsonbyschema which validates a given json string against a given json schema and returns a dictionary with two keys - the isValid key that has the boolean result of the validation and the exceptionMessages key that has an array of string exception messages with details of the elements in the json data string that did not match the schema.
1.3.1
Upgraded jackson-databind, jackson dataformat library and Json tools for security fix.
1.3.0
Upgraded jackson-databind, json libraries and updated deprecated APIs, added License File, and changed the application minimum version to 23.2
1.1.0
Added function to return differences between two JSON Strings
1.0.10
Updates to Json, Jackson datafront, and Jackson databind libraries.
1.0.9
Updated guava library
1.0.8
Updated guava library
1.0.7
Updated json, json-smart, asm, and accessors-smart libraries
1.0.6
Updated json library version
1.0.5
Security Updates
1.0.4
Security Updates
1.0.4
Security Upgrades
1.0.3
Security updates
1.0.2
Security Updates