- 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.
- Bot Security Program
- Business Process
- Information TechnologySupport
- ProductivityRPA Developer ToolsUtility
- Automation Type
- Last Updated
- July 28, 2020
- First Published
- March 9, 2020
- Enterprise Version
Download the Bot and follow the instructions to install it in your AAE Control Room.
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
That's it - now the Bot is ready to get going!
Requirements and Inputs
- AAE 11.3.3 (or above)