Free · Find the smallest and largest numbers

JSON Min and Max Finder

Return the minimum and maximum values from one numeric JSON field.

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

Find JSON range

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 62 / 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 records with number values.
Set the field used by $min and $max.
Review both ends of the range.

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.