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
Free
- Bot Security Program
-
Level 1
- Applications
-
- Business Process
- RPA Development
- Category
- RPA Developer Tools
- Downloads
- 358
- Vendor
- Automation Type
- Package
- Last Updated
- October 13, 2021
- First Published
- October 12, 2021
- Platform
- Automation 360
- ReadMe
- ReadMe
- Support
-
- Community Support Only
- Pathfinder Community Developer Forum
- Bot Store FAQs
See the Package in Action
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