In a post last year, I found a simple csv to JSON technique that worked well - but today I noticed a significant limitation - all numbers were converted to strings, which isn’t very useful for setting up mock data for
I created the simple
node.js file below to convert an existing JSON file (using the technique above), by specifying one or more values to convert in the file. It’s not especially robust, but it works for my current needs. A few comments:
- input file must be
- null values converted to string type get set to blank values.
- strings of
"null"are converted to
nullfor int or float types.
- you may specify any number of inputs fields.
- Only supports simple file structures, no nested arrays inside the JSON objects.