JSON query

Query a JSON document with a path expression and pull out just the values you want.

Runs in your browser — nothing you type here is sent anywhere.

Document

{
  "requestId": "req_8f21ac",
  "status": "ok",
  "page": { "limit": 3, "offset": 0, "total": 47 },
  "deploys": [
    {
      "id": "dpl_a91c",
      "env": "production",
      "ok": true,
      "durationMs": 84210,
      "commit": {
        "sha": "9f2c1ab",
        "message": "cache warm on boot",
        "author": { "name": "chance", "email": "hi@chancesanders.dev" }
      },
      "tags": ["web", "edge"]
    },
    {
      "id": "dpl_b73d",
      "env": "staging",
      "ok": false,
      "durationMs": 12980,
      "commit": {
        "sha": "41ba90c",
        "message": "bump image tag",
        "author": { "name": "ops-bot", "email": "bot@chancesanders.dev" }
      },
      "tags": ["api"]
    },
    {
      "id": "dpl_c04e",
      "env": "production",
      "ok": true,
      "durationMs": 60115,
      "commit": {
        "sha": "77de102",
        "message": "drop dead flag",
        "author": { "name": "chance", "email": "hi@chancesanders.dev" }
      },
      "tags": ["web", "worker", "edge"]
    }
  ],
  "warnings": []
}

1,047 characters

Path

Dots and brackets: a.b, [0], [-1], [*], [1:3], ..key anywhere below the root, and keys() / length() / type() last. The leading $ is optional.

Syntax

Paths in this document

matches

string

"chance"

string

"ops-bot"

string

"chance"

Finding one field inside a large response means scrolling, or writing a script. A path expression is faster, and it is the same syntax you will end up using in the code anyway.

Enter a path and matching values are extracted and listed live as you refine it. It is a quick way to confirm an expression is correct before it goes into a jq command or a mapping layer.

What people open it for

Extracting one field from every element of a large array
Testing a path expression before using it in code
Exploring the shape of an unfamiliar response

In the terminal

tools jsonpath

Every utility is also a command in the desktop's shell.

More text tools

Open the full desktop, with all 47 utilities