JSONPath query API

Evaluates a JSONPath expression against a document, returning every matched value plus its concrete normalized path; supports $ . .. * [n] [a,b] [start:end] and filters [?(@.x>v)]. Answers 'Which nodes match this JSONPath?', 'How do I extract values deep in nested JSON?'.

Price$0.02per request

MethodPOST

Route/v1/data-transform/jsonpath

StatusLive

MIME typeapplication/json

Rate limit120/minute

Cache0s public

data-transformjsonpathqueryjsonextractfilterpathwrangle

API URLhttps://x402.hexl.dev/v1/data-transform/jsonpath

Integration docs

Example request

{
  "document": {
    "store": {
      "book": [
        {
          "price": 8
        },
        {
          "price": 12
        },
        {
          "price": 20
        }
      ]
    }
  },
  "path": "$.store.book[?(@.price>10)].price"
}

Example response

{
  "path": "$.store.book[?(@.price>10)].price",
  "count": 2,
  "values": [
    12,
    20
  ],
  "paths": [
    "$['store']['book'][1]['price']",
    "$['store']['book'][2]['price']"
  ]
}

Input schema

{
  "type": "object",
  "required": [
    "document",
    "path"
  ],
  "properties": {
    "document": {
      "type": "object",
      "examples": [
        {
          "store": {
            "book": [
              {
                "price": 8
              },
              {
                "price": 12
              },
              {
                "price": 20
              }
            ]
          }
        }
      ]
    },
    "path": {
      "type": "string",
      "examples": [
        "$.store.book[?(@.price>10)].price"
      ]
    }
  }
}

Output schema

{
  "type": "object",
  "additionalProperties": true
}