Excel to Json Conversion Bot

Overview

1. Useful in scenarios where there is a need of composing JSON requests by fetching data from excel sheets.
2. Saves time required in any web-api hits that require json request, the process of creating a json by referring to the data in the excel sheets is entirely automated.
3. This component can be hooked to any existing appian application by the use of connected systems and can be triggered via the connected system hit with the proper request parameters.

Key Features and Functionality

1. Conversion of data in excel sheet into json format.
2. They key in json is the column name and the value in json is the column contents.
3. Based on the number of entries and occurrence of entries the structure of the JSON changes.