Warm tip: This article is reproduced from stackoverflow.com, please click
boto3 jmespath python-3.x

Filter out ASGs that contain string in AutoScalingGroupName using boto3

发布于 2020-07-25 23:57:58

I am attempting to filter out auto scaling groups that contain the string 'base' in AutoScalingGroupName. I'm trying to use the JMESpath query language but cannot find any examples on filtering by the value, only for key. 

import boto3

session = boto3.Session(profile_name='prod')
asg_client = session.client(
    'autoscaling', 
     region_name='us-west-1'
)

paginator = asg_client.get_paginator('describe_auto_scaling_groups')
page_iterator = paginator.paginate(
    PaginationConfig={'PageSize': 100}
)

filtered_asgs = page_iterator.search(
    'AutoScalingGroups[] | AutoScalingGroupName[?!contains(@, `{}`)]'.format('base')
)

for asg in filtered_asgs:
    pprint.pprint(asg)

This returns

None
None

I've also tried

filtered_asgs = page_iterator.search('AutoScalingGroups[] | [?contains(AutoScalingGroupName[].Value, `{}`)]'.format('base'))

jmespath.exceptions.JMESPathTypeError: In function contains(), invalid type for value: None, expected one of: ['array', 'string'], received: "null"
Questioner
Gorgon_Union
Viewed
14
分享
airborne 2020-05-05 14:51

This is the correct syntax:

substring = 'base'
filtered_args = page_iterator.search(f"AutoScalingGroups[?!contains(AutoScalingGroupName,`{substring}`)][]")

If you prefer the "format-syntax" over f-strings you can of course also write:

filtered_args = page_iterator.search("AutoScalingGroups[?!contains(AutoScalingGroupName,`{}`)][]".format(substring))

And if the substring 'base' is constant you can also write it directly into the expression:

filtered_args = page_iterator.search("AutoScalingGroups[?!contains(AutoScalingGroupName,`base`)][]")

Most of the time you are not interested in the whole content of the response syntax. If you just care about the group name, you can write:

filtered_args = (page['AutoScalingGroupName'] for page in page_iterator.search("AutoScalingGroups[?!contains(AutoScalingGroupName,`base`)][]"))

If you prefer a list as a result over a generator, you can simple replace the surrounding parenthesis with square brackets:

filtered_args = [page['AutoScalingGroupName'] for page in page_iterator.search("AutoScalingGroups[?!contains(AutoScalingGroupName,`base`)][]")]
Gorgon_Union 1970-01-01 08:00:00

Is there a simple way to filter out a list of strings?

Related issues

1
Boto3 wait_until_exists for available image not waiting
2
Is there a way I can return data and provide additional arguments, python3 @click
3
InvalidSignatureException when using boto3 for dynamoDB on aws
4
Passing AWS role to the application that uses default boto3 configs
5
Retrieving results from Sandbox HIT returns empty xml dictionary
6
How to use wildcards for key/object to generate aws pre-signed url in django
7
List the SNS topic using boto3
8
S3 eventual consistency for read after write
9
S3 giving me NoSuchKey error even when the key exists
10
Load a pandas table to dynamoDb