JSON

Last updated: January 18, 2021

JSON querying tools

With a large JSON file, it is impractical to manually look through to find a specific value. JSON query tools solve this problem by giving programmatic access to filtering and manipulating JSON content without the overhead of writing a custom script in something like Ruby or Python.

• jq is sed for JSON — this is the most well-known JSON query tool
• JSONiq - The JSON Query Language
• JMESPath — JMESPath

Other JSON tools

• gron: Make JSON greppable!: transforms JSON into a format that can be searched with grep
• jid: json incremental digger: command line tool for interactively searching/filtering JSON

• glom: a Python library for digging through nested data

  from glom import glom
  
  target = {'a': {'b': {'c': 'd'}}}
  glom(target, 'a.b.c')  # returns 'd'

• Renderjson: Render JSON into collapsible HTML