alexwennerberg/json2csv

Convert JSON to CSV in Rust

Hello World

Most of my active projects are on https://git.alexw.nyc

Patches or a git-request-pull message can be sent to: https://lists.sr.ht/~aw/patches

or my email (found on git commits)

I mirror things here sparsely. I would prefer not to.

I'm pretty active on my personal website, which I host on a Gemini/HTTP site builder I made, flounder:

https://alex.flounder.online

json2csv's Issues

replace csv library with just some util fns

• escape csv value
• print

dont need a full library here

Have a library to use in code

Hello,

Nice crate. Do you think it's a good idea to add a library to use it in code? I wanted to do use in my code so it will be very useful for me. I can help you to do it if you agree to do it.

better error messaging

Allow for array input

Probably have to do something like this but for whatever alternative json library I use serde-rs/json#404

json2csv doesn't work on arrays of objects

Given the following:

[
    {
        "name": "michael",
        "family": [
            {
                "name": "theodore",
                "relation": "father"
            }
        ]
    },
    {
        "name": "john",
        "family": [
            {
                "name": "jane",
                "relation": "sister"
            },
            {
                "name": "janet",
                "relation": "mother"
            }
        ]
    }
]

jslint test.json
(node:46179) Warning: Accessing non-existent property 'runMain' of module exports inside circular dependency
(Use `node --trace-warnings ...` to show where the warning was created)

test.json is OK.

Yields the following:

RUST_BACKTRACE=1 json2csv test.json                     
thread 'main' panicked at 'called `Option::unwrap()` on a `None` value', /Users/ehiggs/.cargo/registry/src/github.com-1ecc6299db9ec823/json2csv-0.1.0/src/convert.rs:45:17
stack backtrace:
   0: <std::sys_common::backtrace::_print::DisplayBacktrace as core::fmt::Display>::fmt
   1: core::fmt::write
   2: std::io::Write::write_fmt
   3: std::panicking::default_hook::{{closure}}
   4: std::panicking::default_hook
   5: std::panicking::rust_panic_with_hook
   6: rust_begin_unwind
   7: core::panicking::panic_fmt
   8: core::panicking::panic
   9: json2csv::convert::write_json_to_csv
  10: json2csv::main
  11: std::rt::lang_start::{{closure}}
  12: std::rt::lang_start_internal
  13: main
note: Some details are omitted, run with `RUST_BACKTRACE=full` for a verbose backtrace.

Replace Clap with pico-args

Flatten doesnt work when smaller arrays are first.

Given the following input:

cat test.json 
{
    "name": "michael",
    "family": [
        {
            "name": "theodore",
            "relation": "father"
        }
    ]
}
{ 
    "name": "john",
    "family": [
        {
            "name": "jane",
            "relation": "sister"
        },
        {
            "name": "janet",
            "relation": "mother"
        }
    ]
}

Yields the following:

json2csv -F test.json
family.0.name,family.0.relation,name
theodore,father,michael
jane,sister,john

Replace serde json with lite-json or json_stream

panicks when converting json generated from serde_json

I have a rust project that outputs json data. Trying to run this to convert it into csv, I get below error:

thread 'main' panicked at 'called `Option::unwrap()` on a `None` value', /Users/nasifimtiaz/.cargo/registry/src/github.com-1ecc6299db9ec823/json2csv-0.1.0/src/convert.rs:47:14
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace

sort output keys