I'd like to select elements from a list based on the value of bar in the params key-value pair. See example below. I have the following code: with open('foobar.json', 'r') as fp: data = json.load(fp) expr = '[].record' records =…
I'm new in JMESPath, so I'm not so familiar with a complex query. I have tried quite a lot of queries and they are far from giving me the final results that I wanted. Target: Get the first instanceId of…
I am trying to compare 2 security groups in AWS that are in 2 different accounts, using aws ec2 describe-security-groups. Even if the security groups are exactly the same, it's impossible for me to detect that because the json response…
When I go like this, I get a nice table view, which (awesomely too) pretty much always contains just what I need. az ad app list --all --output table Now, as a true developer (read: problem solver), while totally satisfied,…
I am stuck in this piece of work.. i have tried so many things but i think i have gone far into the abyss that i cant think outside now. I have a a fact with the list: set_fact is…
I have a JSON file with some data on it, like the below one: { "84d0da32-c945-9844-86cc-4b4bd6100dc5": { "UUID": "84d0da32-c945-9844-86cc-4b4bd6100dc5", "GroupName": "TEST1", "EntryTitle": "host1", "Username": "sys", "NewPassword": "@PVmkiajauauajjhfz-5/NN" }, "test": { "UUID": "5c3c162f-0a80-f949-85a0-afcf9aedb6c8", "GroupName": "TEST2", "EntryTitle": "host2", "Username": "sys", "NewPassword": "H7-uPz2mkaaua@ki7q?NSs?"…
I am searching through Azure container and want to filter out blobs ending with certain suffixes. When I use the --query parameter with a JMESPath contains function, it is giving me an error. When I run the command az storage…
Input data: s = {'111': {'name': 'john', 'exp': '1'}, '222': {'name': 'mia', 'exp': '1'}} Code: import jmespath jmespath.search("(*)[?name=='john']", s) Output: [{'name': 'john', 'exp': '1'}] Output I want: [{'111': {'name': 'john', 'exp': '1'}}]
I'm trying to select the SerialNumber of a specific AWS MFADevice for different profiles. This command returns the list of MFADevices for a certain profile: aws iam list-mfa-devices --profile xxx and this is a sample JSON output: { "MFADevices": […
I have list of executionArn of stepfunction execution, I am filtering those executionArn by status == 'FAILED'. Now, how can I get the exact failure of the stepfunction in Python, (meaning: at which point the execution has failed)?