jsonflattifier 1.1.6

Converts a JSON Document with nested objects and their parameters to the JSON Document with Flat Denormalised Data.

jsonflattifier

Converts a JSON Document with nested objects and their parameters to the JSON Document with Flat Denormalised Data.

Installation

> pip install jsonflattifier

Input

{
  "name": "John",
  "has": [
    "apple",
    "peach"
  ]
}

Get flat JSON

> python3 -m jsonflattifier flattify '{"name":"John","has":["apple","peach"]}' --json --jsonpath-keys --no-table

[
  {
    "$['name']": "John",
    "$['has'][0]": "apple"
  },
  {
    "$['name']": "John",
    "$['has'][1]": "peach"
  }
]

Get CSV

> python3 -m jsonflattifier flattify '{"name":"John","has":["apple","peach"]}' --csv --no-table

['name'],['has']
John,apple
John,peach

Print Table

> python3 -m jsonflattifier flattify '{"name":"John","has":["apple","peach"]}'

['name']	['has']
John	apple
John	peach

2 rows in set

More Examples

https://gitlab.com/v.grigoryevskiy/json-flattifier/-/tree/master/tests/data