JSON Tools

• Adding functionality to evaluate json expressions and merge json data with text template.  
• Functionality is based on this library: github.com/.../JSONata4Java

• Replace references to private Appian APIs
• [private] com.appiancorp.common.ArrayUtil.asList(java.lang.Object[])
• [private] com.appiancorp.common.ArrayUtil.isEmpty(java.lang.Object)

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.

• Upgraded ValidateJSONBySchema to validate JSON messages that have arrays at the top level, including nested arrays.

Hi, is there a way to download the older versions of this plug in?

• Upgraded json-path library for security fix

Could any sort of documentation or sample app be included? The screenshots no longer match up to the smart service

• 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.

• Upgraded jackson-databind, jackson dataformat library and Json tools for security fix.

I am trying to load a JSON file to a table. When I try loading a JSON that only contains a JSON array, everything works fine. However, when the JSON array is located inside another JSON, it fails (I am using the JsonPath parameter).

FIRST .json:

[

{...},

{...},

]

SECOND .json:

{"key1": {

"key2": {""},

"key3": [

{...},

{...},

]

}

}

JSON PATHs USED:

$.key1.key3

$.key1.key3.*

$.key1.key3[:]

$.['key1'].['key3']

Do anyone know how to use this parameter?

Thank you!