- Start Session: Parse JSON to be queried and save into a session
- Get Value: Get value from particular parsed JSON session
- Get Value: dot and square notation allowed
- Get Value: Decide action behavior in case of missing queried key/value
Parse JSON and query using dot/square notation.
Supports all data types including null and boolean.
Choose action behavior in case of missing keys/value(null).
JSON formatted string
All queries return strings and sample queries are part of the demo task.
Following functions can be applied directly with the query on array objects:
min() Provides the min value of an array of numbers
max() Provides the max value of an array of numbers
avg() Provides the average value of an array of numbers
stddev() Provides the standard deviation value of an array of numbers
length() Provides the length of an array
sum() Provides the sum value of an array of numbers
Keys having (.) in their names can be queried like:
['key.with.dot'] which would otherwise fail in the case of a dot query.
You can decide the action behavior in case a queried key is missing:
1. throw error
2. return empty string
3. return string of your choice
You can decide the action behavior in case a queried key has a missing(null) value:
1. Return empty string
2. Return custom string
See the Package in Action
Download the Package and follow the instructions to install it in your AAE Control Room.
Use the Package in a bot, configure keys and other credentials the package will need (see the ReadMe for details.)
That's it - now the Package is ready to get going!
Requirements and Inputs
- Properly formatted JSON object as a string