JMESPath query API

Runs a JMESPath-style expression (dotted projections, [n], [], list filters [?expr], | pipes) over a JSON document and returns the projected result. Answers 'What does this JMESPath expression return?', 'How do I project and filter JSON like the AWS CLI?'.

Price$0.02per request

MethodPOST

Route/v1/data-transform/jmespath

StatusLive

MIME typeapplication/json

Rate limit120/minute

Cache0s public

data-transformjmespathqueryjsonprojectionfilterpipewrangle

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

Integration docs

Example request

{
  "document": {
    "people": [
      {
        "name": "a",
        "age": 30
      },
      {
        "name": "b",
        "age": 40
      }
    ]
  },
  "expression": "people[?age>`35`].name"
}

Example response

{
  "expression": "people[?age>`35`].name",
  "result": [
    "b"
  ]
}

Input schema

{
  "type": "object",
  "required": [
    "document",
    "expression"
  ],
  "properties": {
    "document": {
      "type": "object",
      "examples": [
        {
          "people": [
            {
              "name": "a",
              "age": 30
            },
            {
              "name": "b",
              "age": 40
            }
          ]
        }
      ]
    },
    "expression": {
      "type": "string",
      "examples": [
        "people[?age>`35`].name"
      ]
    }
  }
}

Output schema

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