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
Product video fallback

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

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

Customer Reviews

0.0(0 reviews)

No reviews yet.