Free · Find an object by ID or value

JSON Record Lookup

Look up matching records in a JSON array with one simple equality test.

Real JSONata 2.2 query
Private in your browser
Time and result safety caps

Find matching record

Paste JSON, edit the JSONata expression, and run it locally with time, depth, and result limits.

Add JSON and a queryBoth stay in this browser tab

JSON data 1,255 / 120,000 characters

{
  "store": {
    "name": "Little Leaf Market",
    "currency": "CAD"
  },
  "orders": [
    {
      "id": "A-100",
      "customer": "Mia",
      "city": "Toronto",
      "status": "paid",
      "total": 84.5,
      "items": 3,
      "tags": [
        "gift",
        "new"
      ]
    },
    {
      "id": "A-101",
      "customer": "Noah",
      "city": "Ottawa",
      "status": "pending",
      "total": 42,
      "items": 1,
      "tags": [
        "new"
      ]
    },
    {
      "id": "A-102",
      "customer": "Ava",
      "city": "Toronto",
      "status": "paid",
      "total": 126.25,
      "items": 4,
      "tags": [
        "vip",
        "gift"
      ]
    },
    {
      "id": "A-103",
      "customer": "Liam",
      "city": "Montreal",
      "status": "refunded",
      "total": 58.75,
      "items": 2,
      "tags": [
        "return"
      ]
    },
    {
      "id": "A-104",
      "customer": "Emma",
      "city": "Ottawa",
      "status": "paid",
      "total": 199,
      "items": 5,
      "tags": [
        "vip"
      ]
    },
    {
      "id": "A-105",
      "customer": "Mateo",
      "city": "Toronto",
      "status": "pending",
      "total": 72.25,
      "items": 2,
      "tags": [
        "gift"
      ]
    }
  ]
}

JSONata expression 20 / 1,000 characters

Bounded local queryJSONata 2.2.2 · 800 ms timeout · $eval off

See the resultReady when you are

Your query result will appear here

JSONata can filter, sort, group, calculate, and reshape the sample without an upload.

Three simple steps

How to use it

Paste the JSON records.
Enter the field and value to find.
Check the matching object or objects.

Your JSON stays on this device

JSONata reads and transforms the JSON inside this browser tab. Bookify does not upload or save the data or expression. Every run has time, sequence, stack, input, and output limits, and $eval stays disabled.