JMESPath multiple conditions

jq is typically used for the former, JMESPath for the latter . There’s no reason why the remote service couldn’t accept a jq filter, or that you couldn’t use a JMESPath-based executable.

JMESPath (JSON Matching Expression paths) is a query language for search JSON documents . It allows you to declaratively extract elements from a JSON document.

JSON is case-sensitive . You must refer to SQL names in JSON code using the correct case: uppercase SQL names must be written as uppercase.

A final remark is that all JMESPath queries are case sensitive !15 Mar 2021