Panodata Community

JSONata: JSON query and transformation language

About

./jq (*2012) gets a new sister query language. It is JSONata (*2016) and it is getting more popular through jfq.

Synopsis

curl -s \
  https://api.npmjs.org/downloads/range/last-year/jsonata \
  | jfq 'downloads{$substring(day, 0, 7): $sum(downloads)}'

Features

  • Lightweight query and transformation language for JSON data
  • Inspired by the location path semantics of XPath 3.1
  • Sophisticated query expressions with minimal syntax
  • Built in operators and functions for manipulating and combining data
  • Create user-defined functions
  • Format query results into any JSON output structure

Implementations


Resources