search

zemirco / json2csv

Convert json to csv with column titles
http://zemirco.github.io/json2csv
MIT License
2.72k stars 362 forks source link

the first object in array defines the schema and results in missing fields in csv output #585

Closed himanshu-pathak closed 1 year ago

himanshu-pathak commented 1 year ago

Tested this with 7.0.2 and 7.0.3 version of json2csv CLI.

Looks like the issue reported in these earlier 2 tickets is back.

https://github.com/zemirco/json2csv/issues/104 https://github.com/zemirco/json2csv/issues/335

Below is the sample json.

[ { "column1": "value 1", "column2": "value 2" }, { "column1": "value 1", "column2": "value 2", "column3": "Value 3" } ]

The output for the below command doesn't include column3.

json2csv -a -i test.json

Output

"column1","column2" "value 1","value 2" "value 1","value 2"

juanjoDiaz commented 1 year ago

Hi @himanshu-pathak ,

Your response is here already: https://github.com/zemirco/json2csv/issues/335#issuecomment-439191379

This repo is deprecated. If you need more help or more details about why things work the way they work, please raise the issue in the current repo: https://github.com/juanjoDiaz/json2csv I won't respond anymore here.