---
title: jmespath
latest-connect-version: 4.118.0
latest-operator-version: v26.2.6
latest-console-tag: v3.14.0
latest-redpanda-tag: v26.2.7
docname: processors/jmespath
page-component-name: connect
page-version: master
page-component-version: master
page-component-title: Connect
page-relative-src-path: processors/jmespath.adoc
page-edit-url: https://github.com/redpanda-data/rp-connect-docs/edit/main/modules/components/pages/processors/jmespath.adoc
description: Executes a JMESPath query on JSON documents and replaces the message with the resulting document.
page-cloud-available: "true"
page-cloud-available-url: https://docs.redpanda.com/cloud-data-platform/develop/connect/components/processors/jmespath/
page-git-created-date: "2024-05-24"
page-git-modified-date: "2026-10-29"
page-generated-sources:
  - include: connect:components:partial$descriptions/processors/jmespath.adoc
    generator: null
    version: null
    source: the component specs in https://github.com/redpanda-data/connect
  - include: connect:components:partial$availability/processors/jmespath.adoc
    generator: null
    version: null
    source: the component specs in https://github.com/redpanda-data/connect
  - include: connect:components:partial$fields/processors/jmespath.adoc
    generator: null
    version: null
    source: the component specs in https://github.com/redpanda-data/connect
  - include: connect:components:partial$examples/processors/jmespath.adoc
    generator: null
    version: null
    source: the component specs in https://github.com/redpanda-data/connect
page-generated-content: partial
---

# jmespath

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [connect-full.txt](https://docs.redpanda.com/connect-full.txt)

<!-- Source: https://docs.redpanda.com/connect/components/processors/jmespath.md -->

Executes a [JMESPath query](http://jmespath.org/) on JSON documents and replaces the message with the resulting document.

> 💡 **TIP: Try out Bloblang**
>
> Try out Bloblang
>
> For better performance and improved capabilities try native Redpanda Connect mapping with the [`mapping` processor](https://docs.redpanda.com/connect/components/processors/mapping/).

#### Common

```yml
processor:
  label: ""
  jmespath:
    query: "" # No default (required)
```

#### Advanced

```yml
processor:
  label: ""
  jmespath:
    query: "" # No default (required)
```

## Fields

### `query`

The JMESPath query to apply to messages.

**Type**: `string`

## Examples

### Mapping

When receiving JSON documents of the form:

```json
{
  "locations": [
    {"name": "Seattle", "state": "WA"},
    {"name": "New York", "state": "NY"},
    {"name": "Bellevue", "state": "WA"},
    {"name": "Olympia", "state": "WA"}
  ]
}
```

We could collapse the location names from the state of Washington into a field `Cities`:

```json
{"Cities": "Bellevue, Olympia, Seattle"}
```

With the following config:

```yaml
pipeline:
  processors:
    - jmespath:
        query: "locations[?state == 'WA'].name | sort(@) | {Cities: join(', ', @)}"
```