AWS Cli - Query output using an environment variable in powershell

Question

I am trying to query the output of an AWS cli command using an environment variable as the query string. This works fine for me using the AWS Cli in Linux but in Powershell I am having trouble getting the Cli to use the variable in Powershell.

For example - thsi works for me in Linux:

SECGRP="RDP from Home"
aws ec2 describe-security-groups --query \
'SecurityGroups[?GroupName==`'"$SECGRP"'`].GroupId' --output text

If i run this in Powershell:

$SECGRP="RDP from Home"
aws ec2 describe-security-groups --query \
'SecurityGroups[?GroupName==`'"$SECGRP"'`].GroupId' --output text

Error Details:

Bad value for --query SecurityGroups[?GroupName==`: Bad jmespath 
expression: Unclosed ` delimiter:
SecurityGroups[?GroupName==`
                       ^

I have tried a few combinations of quotes inisde the query expression but either get errors or no output.

I have also run the following to demonstrate i can get the correct output using Powershell (but not using a variable):

aws ec2 describe-security-groups --query \
'SecurityGroups[?GroupName==`RDP from Home`].GroupId' --output text

Mark Wragg · Accepted Answer · 2017-08-07 09:27:06Z

3

Try this:

$SECGRP="RDP from Home"
aws ec2 describe-security-groups --query "SecurityGroups[?GroupName=='$SECGRP'].GroupId" --output text

answered Aug 7, 2017 at 9:27

Mark Wragg

23.6k7 gold badges48 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Darren Reddick Over a year ago

Thanks for your response.

Collectives™ on Stack Overflow

AWS Cli - Query output using an environment variable in powershell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related