CSV-To-JSON-Converter
CSV-To-JSON-Converter copied to clipboard
Properly parse json objects
This pull request adds support for json objects in the csv file. They are properly parsed now.
Hi @bartwalczak
Thanks for your contribution, can you elaborate on that and show me an example?
I was attempting to convert logs exported from kibana as csv to json, and ran into several issues with deeply nested json objects not being properly interpreted.
Here's an example:
"@timestamp","msg","host_ip","level","subject","origin","trigger","type","content","tags","timestamp"
"""2019-03-06T18:34:40.795+0000""","""CIS report""","""""","""info""","""internal workings""","""agent/cis""","""report""","""http-bulk""","{""assessment_date"":""03/06/2019 10:33:42"",""target"":""thinktank"",""database_host"":""N/A"",""database_name"":""N/A"",""benchmark_version"":""1.0.0"",""benchmark_id"":""xccdf_org.cisecurity.benchmarks_benchmark_1.0.0_CIS_MIT_Kerberos_1.10_Benchmark"",""benchmark_name"":""CIS MIT Kerberos 1.10 Benchmark"",""benchmark_dup_id"":""xccdf_org.cisecurity.benchmarks_benchmark_1.0.0_CIS_MIT_Kerberos_1.10_Benchmark"",""profile"":""KDC with DB2 Database"",""profile_id"":""xccdf_org.cisecurity.benchmarks_profile_KDC_with_DB2_Database"",""rule_id"":""xccdf_org.cisecurity.benchmarks_rule_2.4.3_Secure_the_administrative_server_log_location_admin_server"",""rule_section"":""2.4.3"",""rule_title"":""Secure the administrative server log location (admin_server)"",""result"":""pass"",""cceid"":""CCE-NONE""}","[""_logz_http_bulk_json_8070""]","""2019-03-06T10:33:47.633862905-08:00"""
"""2019-03-06T18:34:40.795+0000""","""CIS report""","""""","""info""","""internal workings""","""agent/cis""","""report""","""http-bulk""","{""assessment_date"":""03/06/2019 10:33:42"",""target"":""thinktank"",""database_host"":""N/A"",""database_name"":""N/A"",""benchmark_version"":""1.0.0"",""benchmark_id"":""xccdf_org.cisecurity.benchmarks_benchmark_1.0.0_CIS_MIT_Kerberos_1.10_Benchmark"",""benchmark_name"":""CIS MIT Kerberos 1.10 Benchmark"",""benchmark_dup_id"":""xccdf_org.cisecurity.benchmarks_benchmark_1.0.0_CIS_MIT_Kerberos_1.10_Benchmark"",""profile"":""KDC with DB2 Database"",""profile_id"":""xccdf_org.cisecurity.benchmarks_profile_KDC_with_DB2_Database"",""rule_id"":""xccdf_org.cisecurity.benchmarks_rule_2.2.2_Secure_the_kadmin_keytab__admin_keytab"",""rule_section"":""2.2.2"",""rule_title"":""Secure the kadmin keytab (admin_keytab)"",""result"":""pass"",""cceid"":""CCE-NONE""}","[""_logz_http_bulk_json_8070""]","""2019-03-06T10:33:47.633850552-08:00"""