JSON Reader Package

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)

Top Benefits

  • Process JSON response from API
  • Parse JSON once, query multiple times
  • Ability to decide behavior in case of missing keys/value (null)
  • Supports all JSON datatype

Actions

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

Input:
JSON formatted string
Output:
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

Get Package

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Vendor
Automation Type
Package
Last Updated
October 13, 2021
First Published
October 12, 2021
Platform
Automation 360
ReadMe
ReadMe
Support

See the Package in Action

Start Session: Parse JSON string into session
Get Value: Query keys using dot /square notation
Get Value: Handle missing keys/value
PREV NEXT
Start Session: Parse JSON string into session
Get Value: Query keys using dot /square notation
Get Value: Handle missing keys/value

Setup Process

Install

Download the Package and follow the instructions to install it in your AAE Control Room.

Configure

Use the Package in a bot, configure keys and other credentials the package will need (see the ReadMe for details.)

Run

That's it - now the Package is ready to get going!

Requirements and Inputs

  • Properly formatted JSON object as a string