Free · Keep only the fields you need

JSON Field Picker

Turn each object into a smaller object with a chosen set of fields.

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

Pick JSON fields

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 45 / 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 an array of objects.
List the fields to keep.
Download the smaller result.

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.