Perform Various JSON Operations

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 the following functionality: -
Simply put this bot is used for converting input Json string to a flat structure.
JSON is 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 times very complicated and time-consuming to achieve.
This Metabot accepts any valid* json string as input and provides output in two formats
o 2-D Array: The first row of the array consists of the column header (Key Name), subsequent rows contain 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
Downloads
105
Vendor
Automation Type
Bot
Last Updated
July 28, 2020
First Published
March 9, 2020
Enterprise Version
11.3.3
Support

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)