As JSON becomes the lingua franca of web-based APIs, you might find yourself needing a way to query large chunks of data in JSON format.

jsawk from Micha Niskin provides awk-like functionality:

cat /data/athletes | jsawk 'this.sports = this.sports.join(",")'

In this example, we read the contents of a JSON file and pipe it into jsawk and concatenate the array of sports into a delimited string.

jsawk also supports the popular JSONQuery syntax with the -q option.

Be sure to check out full installation instructions and extensive examples in the README.

[Source on GitHub]


Have comments? Send a tweet to @TheChangelog on Twitter.

Subscribe to The Changelog Weekly – our weekly email covering everything that hits our open source radar.