Skip to main content

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

Project description

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

jsonflattifier-1.1.6.tar.gz (5.2 kB view hashes)

Uploaded Source

Built Distribution

jsonflattifier-1.1.6-py3-none-any.whl (7.6 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page