Tools

The list enumerates a few tools that are also valuable to wrangle (deeply) nested JSON data.

• jp: A command line interface to JMESPath, an expression language for manipulating JSON.

• jq: A lightweight and flexible command-line JSON processor.

• jsonpointer: A commandline utility that can be used to resolve JSON pointers on JSON files.

• rq: A blazing fast JSONPath query engine written in Rust.

Examples

Use jq to convert JSON file into JSONL / NDJSON file.

cat data.json | \
  jq --null-input --compact-output  --stream 'fromstream( inputs | (.[0] |= .[1:]) | select(. != [[]]) )' \
  > data.jsonl

– https://stackoverflow.com/a/60961240

Todo

Integrate into Tikray CLI and API.