Everyone here mentions jq but no one mentions "fx". It's an awesome cli app to browse json. It can modify json too, but I think jq has shorter DSL. If you want to browse or navigate through nested json, this is the best tool I know.
I wouldn't use GUI for this simply because piping data and mouseless env are more convenient to me. These are my other use cases:
- validation & auto fixing: fix-busted-json (python)
- tabular view : visidata (vd) can do this directly on json files. it has tons of other features like histogram, charts, sort, filter, edit, etc
- summarizing and querying: duckdb. Example: select sum(price), count(*) from 'orders.json'
- conversion: json2csv, it works both way
- diff: simply diff, but sometimes jq for ordering keys is required
I wouldn't use GUI for this simply because piping data and mouseless env are more convenient to me. These are my other use cases:
- validation & auto fixing: fix-busted-json (python)
- tabular view : visidata (vd) can do this directly on json files. it has tons of other features like histogram, charts, sort, filter, edit, etc
- summarizing and querying: duckdb. Example: select sum(price), count(*) from 'orders.json'
- conversion: json2csv, it works both way
- diff: simply diff, but sometimes jq for ordering keys is required