How to use a cli variable in AWSCLI query

Question

How do I use a variable with an AWS query??

There does not seem to documentation on the query syntax, mearly examples.

Im trying to do the following:

API_ID=$(aws apigateway get-rest-apis --query 'items[?name == `${API_NAME}`] | [0].{id: id}' --output text)

The problem is that ${API_NAME} is read literally. Any ideas?

cosbor11 · Accepted Answer · 2016-02-09 20:55:53Z

21

I figured this out after sometime...

AWS uses JMESPath, as the spec for their --query option. When passing jmespath filter expression as a string:

You can use double quotes (") instead and wrap the variable in single quotes ('). This will not prevent the variable from being replaced.

So it worked when I changed it to:

API_ID=$(aws apigateway get-rest-apis --query "items[?name == '${API_NAME}'] | [0].{id: id}" --output text)

answered Feb 9, 2016 at 20:55

cosbor11

16.4k11 gold badges62 silver badges76 bronze badges

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

1 Comment

Inspiraller Over a year ago

This works inline in the bash terminal but it doesnt' work in a bash script if just declaring the variable above it. The variable must be exported to work in a bash script file.

Collectives™ on Stack Overflow

How to use a cli variable in AWSCLI query

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