Foreword
- Thanks for providing the app! I use your app via CLI.
- I looked into the manpage but found no options to achieve my goal.
- So I think this is de facto a feature request
User Story
From a large JSON file containing a lot of stuff I want the option to select only a particular object for export to CSV.
With a syntax like --select "path.to.object"
Or another argument name you deem appropriate as the mnemonics -s and -S are both already taken.
Given example.json
{
"version": "1.5",
"global_option_a": "something",
"global_option_b": "else",
"global_option_c": 123,
"people": [
{
"firstname": "Jon",
"lastname": "Doe",
"birthday": "1978-02-19",
"gender": "m"
},
{
"firstname": "Jane",
"lastname": "Doe",
"birthday": "1982-04-21",
"gender": "f"
},
{
"firstname": "Dave",
"lastname": "Meyer",
"birthday": "1964-12-03",
"gender": "m"
}
],
"locations": {
"Europe": [
{
"ID": "1",
"Name": "London"
},
{
"ID": "2",
"Name": "Paris"
},
{
"ID": "3",
"Name": "Madrid"
}
],
"Asia": [
{
"ID": "4",
"Name": "Tokio"
},
{
"ID": "5",
"Name": "Seoul"
}
]
}
}
To get people.csv I'd run…
$ json2csv example.json --select "people" > people.csv
which results in:
firstname,lastname,birthday,gender
Jon,Doe,1978-02-19,m
Jane,Doe,1982-04-21,f
Dave,Mayer,1964-12-03,m
To get locations-asia.csv I'd run
$ json2csv example.json --select "locations.Asia" > locations-asia.csv
which results in:
Foreword
User Story
From a large JSON file containing a lot of stuff I want the option to select only a particular object for export to CSV.
With a syntax like
--select "path.to.object"Or another argument name you deem appropriate as the mnemonics
-sand-Sare both already taken.Given example.json
{ "version": "1.5", "global_option_a": "something", "global_option_b": "else", "global_option_c": 123, "people": [ { "firstname": "Jon", "lastname": "Doe", "birthday": "1978-02-19", "gender": "m" }, { "firstname": "Jane", "lastname": "Doe", "birthday": "1982-04-21", "gender": "f" }, { "firstname": "Dave", "lastname": "Meyer", "birthday": "1964-12-03", "gender": "m" } ], "locations": { "Europe": [ { "ID": "1", "Name": "London" }, { "ID": "2", "Name": "Paris" }, { "ID": "3", "Name": "Madrid" } ], "Asia": [ { "ID": "4", "Name": "Tokio" }, { "ID": "5", "Name": "Seoul" } ] } }To get
people.csvI'd run…which results in:
To get
locations-asia.csvI'd runwhich results in: