What is the difference between JSONPath and JMESPath?

JSONPath is a standard query language for JSON, often using `$.` syntax. JMESPath is another query language optimized for complex filtering and transformations, commonly used in tools like the AWS CLI.

Can I run multiple queries at once?

Yes, you can enter multiple expressions by placing each one on a new line in the query input field.

What does the 'Flatten Array Results' option do?

It merges nested arrays returned by your queries into a single, flat list, making it easier to read and copy the extracted values.

How are the results displayed?

You can choose 'Highlighted JSON' to see matches colored within your original input, or 'Match List' to see only the extracted values and their exact paths.

Is there a limit to the number of matches?

Yes, to ensure performance, the tool limits the output to a maximum number of matches, which you can adjust up to 200 using the settings.

Elysia Tools

Navigation

Data Processing

JSON Path Extractor

Query JSON with JSONPath or JMESPath-style expressions, inspect matched paths, and highlight extracted values in the original document

Execution

Run this tool

Fill in the form, run the tool, and review the result in one place.

Prepared example runs

Click an example to fill the form automatically. File inputs still need an upload.

2 examples

Extract admin names with JSONPath filters

Pull matching objects and individual fields from an API response, then inspect them in the highlighted JSON view

<div>Expressions: 2, Matches: 2, highlighted JSON with $.users[0] and $.users[0].name</div>

Traverse nested arrays with JMESPath-style syntax

Use wildcard and comparison filters to extract high-value line items from nested order data

<div>Matches: $.orders[0].items[1].sku, $.orders[1].items[0].sku</div>

Inputs

Set the required fields, then run the tool.

7 options

ContentPaste or type the main input values.2

JSON InputtextareaRequiredQuery ExpressionstextareaOptionalUse one expression per line. Supports field access, array indexes, wildcards, and simple filters.

SettingsAdjust formats, ranges, numbers, and modes.3

Query EngineselectOptionalDisplay ModeselectOptionalMaximum MatchesnumberOptional

TogglesEnable or disable optional behavior.2

Flatten Array ResultscheckboxOptionalEnabled when checkedInclude Null ValuescheckboxOptionalEnabled when checked

Result

Ready for a run

Run the tool to preview files, text, structured data, or streamed output here.

Samples

JSON Path Extractor

Run this tool

Prepared example runs

Inputs

Result

Examples that match this tool

Continue with connected tools and hubs

Prepared example runs

Inputs

Result

Learn when to use this tool, what it supports, and how real users apply it.

Key facts

Overview

When to use

How it works

Use cases

Examples

1. Extracting Admin Users from API Response

2. Finding High-Value Order Items

FAQ

Terraform Plan JSON Samples

Chat Transcript JSON Samples

JSON Samples

Rich Media JSON Samples

Structured Log Analyzer

JWK Generator & Parser

CSV Filter

JSON Key Extractor

JSON Interchange and Format Translation Tools

JSON Inspection, Diff, and Transformation Tools

JSON Schema, Mock Data, and API Fixture Generators

JSON Formatting, Diff, and Normalization Tools