Issue Converting JSON to CSV File

[Karthigeyan14]

Actually, I'm facing an issue while converting JSON to a CSV file. I deserialized it with a dynamic object, but the problem is that the headers are generated based on the first set of data. If the next set of data differs from the first, any missing data is not included in the CSV file. Do you have any suggestions...?

[Cinchoo]

use WithMaxScanRows on csv writer

            StringBuilder csv = new StringBuilder();
            using (var r = new ChoJSONReader(FileNameSample33JSON)
                .WithJSONPath("$..getUsers[*]", true)
                )
            {
                using (var w = new ChoCSVWriter(csv)
                    .WithFirstLineHeader()
                    .WithMaxScanRows(10)
                    .Configure(c => c.ThrowAndStopOnMissingField = false)
                    )
                    w.Write(r);
            }

[Karthigeyan14]

Thank you for your response! It's working. 👍

[Karthigeyan14]

@Cinchoo I have another issue. The field looks like this:

json

"extension": [
{
"Test": "value",
"value": [
"0",
"1",
"2"
]
},
{
"Test1": "Test",
"value": "20"
},
{
"Test2": "Test",
"value": "35"
}
]
The values 20 and 35 are missing because in the first object, the value field is a list, while in the subsequent objects, value is not a list. This inconsistency causes the values to be overlooked.

[Cinchoo]

duplicate #325

[Karthigeyan14]

@Cinchoo I have another issue. The field looks like this:

json

"extension": [ { "Test": "value", "value": [ "0", "1", "2" ] }, { "Test1": "Test", "value": "20" }, { "Test2": "Test", "value": "35" } ] The values 20 and 35 are missing because in the first object, the value field is a list, while in the subsequent objects, value is not a list. This inconsistency causes the values to be overlooked.

so how to fix this ..?