ilovejson / ilovejson Goto Github PK

BASE: https://www.ilovejson.com
URL: https://www.ilovejson.com/json-to-table

Brief

Need to build JSON to HTML Functionality

• User will drag a JSON file
• User will click Generate. JSON file will be passed to API.
• API will convert it to html tabular format & zip it.
• Upload it to CDN.
• Response the CDN URL back to user browser.

BASE: https://www.ilovejson.com
URL: https://www.ilovejson.com/json-to-sql

Brief

Need to build JSON to SQL Functionality

• User will drag a JSON file
• User will choose which SQL file to generate (MYSQL, POSTGRES etc.)
• User will click Generate. JSON file will be passed to API.
• API will convert it to right format
• Upload it to CDN.
• Response the CDN URL back to user browser.

Describe the bug
AFAIK the data at https://cdn.ilovejson.com/ is publicly accesible & the resulting .json has the unix timestamp as it's name, meaning a third party could end up having the JSON you upload to this webpage if he tries out unix timestamps until he finds one that matches an uploaded file

To Reproduce
Steps to reproduce the behavior:

1. Go to csv to json
2. Upload a csv file
3. Click on convert
4. Click on download
5. See the file URL (https://cdn.ilovejson.com/csvtojson/unixtimestamp.json)

Expected behavior
Ensure files are stored only temporarily & viewed only by the uploader.
Alternatively put a BIG WARNING that the webpage is going to make the files you upload to it publicly accesible

Ref: https://www.npmjs.com/package/xml-js

Can be used to convert vice-versa as well

Build API Route to convert json to csv
Ref: https://www.npmjs.com/package/json2csv

BASE: https://www.ilovejson.com
URL: https://www.ilovejson.com/viewer#repair

Brief

Need to Integrate JSON Repair Utility Tool

• User will paste a JSON snippet on Left.
• Tool will parse a JSON and Repair it automatically.
• Repaired JSON will be shown to user on Right.

Describe the bug
In JSON viewer, when I try to add/ delete a field in output using popup buttons, it gets updated in the source box but not in the output.

To Reproduce
Steps to reproduce the behavior:

1. Go to '/viewer'
2. Add some valid JSON in the source
3. Change the output by add or deleting some fields
4. Only the source gets updated

Expected behavior
Both source and output should get updated

Desktop (please complete the following information):

• OS: MacOS
• Browser Chrome
• Version 85

BASE: https://www.ilovejson.com
URL: https://www.ilovejson.com/viewer#editor

Brief

Need to Integrate JSON Editor Utility Tool

• User will paste a JSON snippet on Left.
• Tool will parse a JSON and Allow user to edit smoothly on Right.

Tip

You can use same tool which was used in Viewer tool.