Perform Various Json Operations

Simply put this bot is used for converting input Json string to a flat structure and 2D Array

Top Benefits

  • Simply put this bot is used for converting input Json string to a flat structure.
  • This MetaBot can handle any level of nesting, including attributes of string or array type
  • This Metabot accepts any valid* json string as input and provide 2D Array output and flattened JSON

Tasks

  • Convert JSON to 2D Array
  • Convery JSON to Flattened Format

JSON Metabot offers following functionality: -
• Simply put this bot is used for converting input Json string to a flat structure.
• JSON is now a days widely used by vendors to exchange information and most often or not all the vendors have different JSON output. In order to process the output of JSON every time a logic is required. This becomes very challenging and at time very complicated and time consuming to achieve.
• This Metabot accepts any valid* json string as input and provide output in two formats
o 2-D Array: The first row of the array consists of the column header (Key Name), subsequent rows contains the values corresponding to the key.
o String (Flattened Json): This contains the output as a string, each line of the string is a combination of Key and value.
• This MetaBot can handle any level of nesting, including attributes of string or array type.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
March 9, 2020
First Published
March 9, 2020
Enterprise Version
11.3.3
ReadMe
ReadMe
Support

See the Bot in Action

Json Processing
2D Array Output
Flatten Json
PREV NEXT
Json Processing
2D Array Output
Flatten Json

Setup Process

Install

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

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

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

Requirements and Inputs

  • AAE 11.3.3 (or above)