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.
See the Bot in Action
Setup process
Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Configure
Use the Bot in a bot, configure keys and other credentials the Bot will need (see the ReadMe for details.)