Is it possible to write JMESPath expression to return a list of object names where a specific subproperty value is set? In the example below I'd like to get a list of all hostsnames where fileexist...

I am trying to use the Python Library for JMESPath to extract information from a large JSON file, a much simplified example is here: { "high_name":"test", "sections"...

I have a dictionary, I want to do a nested jmespath.search on the keys of the dictionary for keys that start with a specific string, but I can only seem to use the @ operator once. > d = {'foo1...

I would like to use the AWS CLI to query the contents of a bucket and see if a particular file exists, but the bucket contains thousands of files. How can I filter the results to only show key name...

I'm trying to filter a plain list I get from the Azure CLI, and am struggling to construct a query that filters the list properly. An example which encapsulates what I'm trying to accomplish would ...

Using aws-cli 1.3.6 I am trying to get a simple table of my ec2 instances with the Name and state. I have been looking at the --query and JMESpath documentation and I have been able to select the "...

I have list of dicts that contains another list in one of fields. I want to "flatten" that list, so it gives me every subelement with one field (or some fields) from parent copied into it. Example:...

I have a dictionary of packages with package-name being the key and a dictionary of some details being the value: { "php7.1-readline": { "latest": "7.1.9-1+ubuntu14.04.1+deb.sury.org+1", "orig...

I have a JSON object with two arrays — one keys array and one values array, both of the same length. Using jmespath, I want to construct a new object using the values of the keys array as the keys ...

JMESPath is a query language for JSON, used by Azure. Using its own example given from http://jmespath.org/ { "locations": [ {"name": "Seattle", "state": "WA"}, {"name": "New York", "state":...

In the example JSON at the bottom of this question, how can I count the number of key/value pairs in the array "Tags" using JMESPath? According to the JMESPath documentation, I can do this using t...

I have a JSON { "key": "processId-29231", "fields": { "attachment": [ { "id": "79572", "filename": "File1.png" }, { "id": "74620", "filename": "File2.docx" }, { "id": "79072", "filena...

With a json output like : { "Functions":[ { "CodeSha256":"7NBvXXacp9x3aK3cKaI=", "FunctionName":"function_1", "FunctionArn":"arn:aws:lambda:eu-west-1:1111:function:function_1", "LastModified...

I'm trying to filter by multiple values however I can't seem to get an and clause to work (e.g. filter1 and filter 2 ... etc.): Show me snapshots where the database name is 'testing' aws rds de...

I have the following JMESPath query query="Reservations[].Instances[].{ \ InstanceId: InstanceId, \ RootDeviceVolumeId: BlockDeviceMappings[?DeviceName==\`/dev/sda1\`] \ | [].Ebs.VolumeId | [0...

My Google search skills are failing me. How to get a list of all JSON object keys in JMESPath? i.e. how to go from: {"a": 1, "b": 2} to: ["a", "b"]

I write this: - name: test for seed debug: var: hostvars|json_query("*.ansible_host") And it prints every host. But this does not filter hosts: - name: test for seed debug: var: hostvars|js...

I'm trying to output multiple tags from an ec2 instances description. The tag values that I want are Name and aws:autoscaling:groupName. "Tags": [ { "Value": "somename", "Key": "Name" }, {...

The following JmesPath expression finds instances that have been tagged with a team: "Instances[?Tags[?Key=='team']]" Do you know how to find instances that are not tagged with a team? I have t...

Using JMESPath, is it possible to filter output based on the existence of multiple key/value pairs within the input? From the example JSON below, what I'd like to do is extract only the objects th...

Does anyone know what json-query filter can be used to select Tigger's food in the sample JSON below? The JSON is a simplified stand-in for a massive and relatively complicated AWS blob. Some back...