json-leaves 1.2.2

Extract the leaves from a JSON file and show the paths to said leaves

json-leaves

@readwithai - X - blog - machine-aided reading - 📖⚡️🖋️

Turn a JSON object into path-value pairs suitable for grepping.

JSON is quite nice but digging through JSON can be a pain - as can building queries to fetch the values you have found. json-leaves allows you to use grep and other command-line tools to find what you want and then gives you a selector (suitable for use in other tools like python or jq so that you can programmatically do the same thing).

NB: This tool is near identical to the established tool gron - "Grep JSON" written in Go. This tool was written without knowledge of gron's existence

Alternatives and prior work

I could not quickly find a command-line tool to the same thing. I found a recipe for jq but this sufficiently unwieldy that I do not want to use it - though it could be placed in a script that you place on your path. I wanted to make something reusable on any machine.

After writing and sharing this tool, I discovered that gron which is highly-starred and performs near identical functionality. The additional flags for json-leaves may be of value, such as displaying just paths, just strings, unquoted and nodes as well as leaves. gron has an ungron feature to convert from value-path pairs back to values - which seems like a very nice idea since it allows modification to happen the flat path-value form before recreating a JSON file. The plethora of flags in json-leaves might make adding this to this tool confusing. jello a variant of jq which uses a domain specfic language embedded with Python (and so able to leverage Python knowledge for advanced queries ) provides a -s flag which produces output similar to gron.

More generally, any use of this tools likely wants to be aware of the jq tool which provides a DSL to perform many JSON operations from the command-line.

This tool is somewhat related to GenSON which will return the schema of JSON data in that it helps you understand unknown JSON data. The author wrote short-schema some years ago which renders the output from GenSON easily readable.

Those who are incapable of using the command-line and used to spending their lives clicking because they are too lazy to learn anything, may well use JSON browsers such as those in VSCode or browsers. Or you may simply prefer these tools.

Installation

You can install json-leaves using pipx:

pipx install json-leaves

Usage

This fetches data related to the pip installations of the kitty-plotnine package and then unpacks all leaves and values.

curl https://pypistats.org/api/packages/kitty-plotnine/python_major | json-leaves

If you want to show just the values you can use:

curl https://pypistats.org/api/packages/kitty-plotnine/python_major | json-leaves

To distinguish between strings and integers (or nulls) --quote (or -q).

curl https://pypistats.org/api/packages/kitty-plotnine/python_major | json-leaves -q

You can also output JSON data with --json and include nodes as well as leaves with --nodes

Support

If you found this piece of software useful you could give me money (maybe $2) on my ko-fi.

You might consider reviewing some of the other command-line tools I have created or reading some of the things I have written. Users of this tool might be particularly interested in zshnip of my notes on drive by note taking with Obsidian.

About me

I am @readwithai. I create tools for reading, research and agency sometimes using the markdown editor Obsidian.

I also create a stream of tools that are related to carrying out my work.

I write about lots of things - including tools like this - on X. My blog is more about reading and research and agency.