Query JSON with Jsonata

What it can do

• Navigate JSON fields
• Filter array members
• Project selected values

How the recipe works

Demonstration

Sample input

{"orders":[{"product":"alpha","price":9},{"product":"beta","price":19},{"product":"gamma","price":25}]}

Expected result

beta

When to use it

• API-response analysis
• Extracting report fields
• Prototyping data transformations

Adapt it

Change the predicate and projection while keeping the sample structure visible for debugging.

Source and verification

Adapted from mattnotmax CyberChef recipes. The explanation and sample are written for Serialize, use synthetic or documentation-safe data, and are checked against the current operation catalogue. The workflow runs locally without an external API call.