Links and discussion that helped me, docs and blogs

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.