JSONata cookbook

{{ score > 50 }}
{{ tier = 'gold' }}              // single =, not ==
{{ tier in ['gold', 'platinum'] }}
{{ score > 50 and tier = 'gold' }}
{{ found = false or status_code != 200 }}
{{ not (tier = 'free') }}

{{ name ? name : 'friend' }}                     // ternary
{{ $exists(name) ? name : 'unknown' }}           // explicit existence
{{ contact.email ?? 'no-reply@example.com' }}    // null-coalesce

{{ first_name & ' ' & last_name }}               // concat
{{ $uppercase(name) }}
{{ $lowercase(email) }}
{{ $trim(' hello ') }}
{{ $contains(message, 'urgent') }}
{{ $substring(phone, 0, 3) }}
{{ $replace(phone, '-', '') }}

{{ price * 1.08 }}                                // tax
{{ $round(price * quantity, 2) }}
{{ $floor(score) }}
{{ $abs(delta) }}
{{ $sum(items.price) }}                           // aggregate
{{ $count(items) }}
{{ $average(scores) }}

// indexing
{{ contacts[0] }}
{{ contacts[-1] }}                                // last element

// filter
{{ contacts[tier = 'gold'] }}                     // all gold contacts
{{ contacts[score > 50][0] }}                     // first high-scoring

// map (project a field)
{{ contacts.email }}                              // ['a@b', 'c@d']
{{ contacts.{ "id": id, "label": name } }}        // reshape each item

// boolean over array
{{ $count(contacts[tier = 'gold']) > 0 }}         // any gold?
{{ $count(contacts[tier = 'gold']) = $count(contacts) }}  // all gold?

// concat / flatten
{{ list_a & list_b }}                             // arrays merge with &? — use [list_a, list_b].**
{{ $each(contacts, function($v) { $v.email }) }}

{{ $keys(contact) }}                              // ['id', 'email', ...]
{{ $merge([contact, {"verified": true}]) }}       // shallow merge
{{ contact.{ "name": $.name, "tier": $.tier } }}  // pick fields

{{ score > 50 ? 'qualified' : 'not qualified' }}

// chained
{{ score > 90 ? 'a' : (score > 70 ? 'b' : (score > 50 ? 'c' : 'fail')) }}

// switch-style
{{ {
  "high":   score > 80,
  "medium": score > 50 and score <= 80,
  "low":    score <= 50
}[$$ = true] }}                                   // returns the matching key

{{ $now() }}                                      // current ISO timestamp
{{ $millis() }}                                   // current epoch ms
{{ $fromMillis(ms) }}
{{ $toMillis(iso_string) }}

"text": "{{ '<@' & user_id & '> new lead from ' & $.name }}"

"domain": "{{ $substringAfter(email, '@') }}"

"phone": "{{ contact.mobile ?? contact.work ?? contact.home }}"

"slack_channel": "{{ {
  'billing': 'C_BILLING',
  'support': 'C_SUPPORT',
  'sales':   'C_SALES'
}[intent] }}"

"qualified_revenue": "{{ $sum(leads[score > 50].arr) }}"