Perform Various JSON Operations

This bot is used for converting an input JSON string to a flat structure and 2D array

Top Benefits

  • This MetaBot can handle any level of nesting, including attributes of string or array type
  • This MetaBot accepts any valid JSON strings as input and provides a 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 an 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 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.

Access Now

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
228
Vendor
Automation Type
Bot
Last Updated
January 28, 2021
First Published
March 9, 2020
Platform
11.3.3
ReadMe
ReadMe
Support

See the Bot in Action

Json processing
2D array output
Flattened JSON
PREV NEXT
Json processing
2D array output
Flattened 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)