In Todays world, RESTful API's and JSON have become the format of choice for APIs and applications. Initillay, there was no common standard to describe the RESTful API's or request/response data strcutres on par with SOAP servcies (WSDL/XSD). To bring the same standards, JSON Schema came with specification and solved problem of describing RESTful API's clear, human- and machine-readable documentation.
However, JSON Schema is trickier to work with for many people. Creating the JSON Schema files manually is cumbersome and error prone. On other hand, tables are just simpler for people to understand and organize. More importantly, Excel provides great tools manipulating and organizing the table structure data.
The excel2jsonschema CLI tool, allows one to describe the JSON Schema in table format and the CLI tool generates JSON Schema files from table format (Excel Sheet). ###Example ####Input Excel
|Product||product_id||string||Unique identifier representing a specific product for a given latitude & longitude. For example, uberX in San Francisco|
|Product||description||string||Description of product.|
|Product||display_name||string||Display name of product.|
|Product||capacity||string||Capacity of product. For example, 4 people.|
|Product||image||string||Image URL representing the product.|
npm install -g excel2jsonschema
How to Execute:excel2jsonschema -i ./sample.xls -s Schema -o ./distUsage: excel2jsonschema [options]Options:-i, --inputExcelFile <inputExcelFile> 'File Localtion' which contains Schema definations-s, --sheetName <sheetName> 'Sheet Name' which contains Schema definations-o, --outputDir <outputDir> 'Output Directory' where JSON Schema files should be generated## Install