jq

the ubiquitous

Icon  Name                    Last modified      Size  Description
[PARENTDIR] Parent Directory                             -   
[DIR] 15-examples/            2023-03-03 15:20    -   
[DIR] by-example/             2023-11-09 23:42    -   
[DIR] duckdb/                 2024-03-22 21:09    -   
[DIR] man/                    2023-03-03 15:21    -   
[DIR] multi-gigabyte/         2023-07-08 13:05    -   
[DIR] recursively/            2023-03-03 23:41    -
# simple input lines to one simple JSON array?

jq -R < input-rows.txt | jq -sc
R raw input, no interpretation
s slurp
c compact
# only choose some student data, skip staff and all names?

jq ' .student | .[] | .id , .courses ' < dump.json 

"123"
[
  "art",
  "business",
  "tech"
]
"321"
[
  "ict",
  "tech"
]
# list intsalled VSCode extensions: show name, version and path
# also export to CSV, transpose and clean up?

jq -r '[ .[].identifier.id ], [ .[].version ], [ .[].location.path ] | @csv ' < extensions.json |\
   rs -c, -C, -T | tr -d '"\\' 

ms-dotnettools.csharp,1.25.4,/mnt/.vscode/extensions/ms-dotnettools.csharp-1.25.4-win32-x64,
ms-toolsai.vscode-jupyter-slideshow,0.1.5,/mnt/.vscode/extensions/ms-toolsai.vscode-jupyter-slideshow-0.1.5,
ms-vscode.powershell,2023.2.1,/mnt/.vscode/extensions/ms-vscode.powershell-2023.2.1,
ms-toolsai.jupyter-keymap,1.1.0,/mnt/.vscode/extensions/ms-toolsai.jupyter-keymap-1.1.0,
ms-vscode-remote.remote-wsl,0.76.1,/mnt/.vscode/extensions/ms-vscode-remote.remote-wsl-0.76.1,
ms-toolsai.jupyter-renderers,1.0.15,/mnt/.vscode/extensions/ms-toolsai.jupyter-renderers-1.0.15,
ms-toolsai.jupyter,2023.2.1200692131,/mnt/.vscode/extensions/ms-toolsai.jupyter-2023.2.1200692131,
ms-toolsai.vscode-jupyter-cell-tags,0.1.7,/mnt/.vscode/extensions/ms-toolsai.vscode-jupyter-cell-tags-0.1.7,

JSON and other tools (and other formats)

JWT, Json Web Token (perl)

marshall with C#

popular Json.NET by Newtonsoft

in Perl you have JSON.pm etc

jo - simple create

Web tools jsonlint and Json Query Tool

Mitec Json Converter Win GUI

DuckDB JSON extension

SQLite JSON functions and operators

JsQuery PostgreSQL extension , validate with pg_jsonschema

MS SQL

JSONiq JSON Query Language

for Go, fast Sonic library

also jsonize your app output

yq - YAML, JSON and XML processor yq uses jq like syntax but...

fx, (github easy, interactive JSON processing

Miller query, shape and reformat data, e.g. CSV, TSV, JSON and JSON

GraphQL query language for your API, note: vs. REST

MistQL miniature embeddable language for performing computations on JSON-like structures

comma separated values? csvkit or QSV

ASN.1 oldies goldies to save even more resources? Abstract Syntax Notation One

jc universal converter - CLI tool and python library

FFS, create and edit like files and directories

binary files? fq - a tool, language and decoders

many formats, from or to CSV? csvkit