JMESPath is a query language for JSON

Enter an expression in the search box to see JMESPath in action.

The expression is evaluated against the JSON data and the result is shown in the result pane.

To learn more about JMESPath, check out the JMESPath Tutorial and JMESPath Examples.

• JMESPath Specification — JMESPath
• JMESPath Tutorial — JMESPath
• JMESPath Examples — JMESPath

API Connector enables the use of JMESPath, which is a powerful query language for JSON with many useful applications:

• filter for certain fields in the response data
• filter for records that meet specified conditions
• change the report structure, for example to convert columns to rows or normalize JSON

If you just want to filter out fields from your report, you can use API Connector's visual field editor. However, if you're interested in more powerful filtering capabilities, read ahead for information on using JMESPath expressions in your requests.