Security News
Introducing the Socket Python SDK
The initial version of the Socket Python SDK is now on PyPI, enabling developers to more easily interact with the Socket REST API in Python projects.
github.com/yukithm/json2csv
Convert JSON into CSV. CSV header is generated from each key path as a JSON Pointer. json2csv can be used as a library and command line tool.
Use go get
or just download binary releases.
go get github.com/yukithm/json2csv/cmd/json2csv
json2csv reads JSON content from STDIN or the file specified by the argument.
json2csv example.json
cat example.json | json2csv
Convert object array:
[
{
"id": 1,
"name": "foo",
"favorites": {
"fruits": "apple",
"color": "red"
}
},
{
"id": 2,
"name": "bar",
"favorites": {
"fruits": "orange"
}
},
{
"id": 3,
"name": "baz",
"favorites": {
"fruits": "banana",
"color": "yellow"
}
}
]
$ json2csv example1.json
/id,/name,/favorites/color,/favorites/fruits
1,foo,red,apple
2,bar,,orange
3,baz,yellow,banana
Convert object:
{
"status": 200,
"result": [
{
"id": 1,
"name": "foo"
},
{
"id": 2,
"name": "bar"
}
]
}
$ json2csv example2.json
/status,/result/0/id,/result/0/name,/result/1/id,/result/1/name
200,1,foo,2,bar
Convert an array of the object:
Use --path=<JSON Pointer>
option.
$ json2csv --path=/result example2.json
/id,/name
1,foo
2,bar
Transpose rows and columns:
$ json2csv --transpose example1.json
/id,1,2,3
/name,foo,bar,baz
/favorites/color,red,,yellow
/favorites/fruits,apple,orange,banana
By default, header is represented with JSON Pointer.
--header-style=STYLE
option can change styles.
style | example |
---|---|
jsonpointer | /foo/bar/0/baz |
slash | foo/bar/0/baz |
dot | foo.bar.0.baz |
dot-bracket | foo.bar[0].baz |
Note: slash
style similar to jsonpointer
style, but slash
style doesn't start with '/' and doesn't escape special characters ('/' and '~') defined in RFC 6901.
Note: dot-bracket
style similar to dot
style, but dot-bracket
style uses square brackets for array indexes.
MIT
Yuki (@yukithm)
FAQs
Unknown package
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
The initial version of the Socket Python SDK is now on PyPI, enabling developers to more easily interact with the Socket REST API in Python projects.
Security News
Floating dependency ranges in npm can introduce instability and security risks into your project by allowing unverified or incompatible versions to be installed automatically, leading to unpredictable behavior and potential conflicts.
Security News
A new Rust RFC proposes "Trusted Publishing" for Crates.io, introducing short-lived access tokens via OIDC to improve security and reduce risks associated with long-lived API tokens.