Parsing AWS CLI commands

Question

I want to parse the output of AWS CLI command

aws ec2 describe-transit-gateways

From the above, the output I want to get is the name of the transit gateway which is given as a tag example: ("Name": "dev-tgw")

I am able to retrieve TGW ID and Transit Gateway Owner from the below script

result=`aws ec2 describe-transit-gateways --profile $acc`

  for tgw in $(echo "${result}" |jq -r '.TransitGateways[] | @base64'); do

    _jq() {

      echo ${tgw} | base64 --decode | jq -r ${1}

    }
    
    Tgw=$(_jq '.TransitGatewayId')
    Tgw_owner=$(_jq '.OwnerId')
    Tgw_name=$(_jq '.Tags.Name')

    echo "$acc.Name"
    echo "Transit_Gateway": "$Tgw"
    echo "TGW_Owner_ID": "$Tgw_owner"
    echo "TGW_name": "$Tgw_name"

But I am not able to retrieve the Name of the TGW using

 Tgw_name=$(_jq '.Tags.Name')
 echo "TGW_name": "$Tgw_name"

What am I missing or am I looping it wrong?

Marcin · Accepted Answer · 2021-03-17 06:48:10Z

1

You can try the following version:

result=$(aws ec2 describe-transit-gateways --profile $acc)

for tgw in $(echo "${result}" | jq -r '.TransitGateways[] | @base64'); do

    _jq() {
      echo ${tgw} | base64 --decode | jq -r "${1}"
    }
    
    Tgw=$(_jq '.TransitGatewayId')
    Tgw_owner=$(_jq '.OwnerId')
    Tgw_name=$(_jq '.Tags[] | select(.Key == "Name").Value')
    
    echo "$acc.Name"
    echo "Transit_Gateway": "$Tgw"
    echo "TGW_Owner_ID": "$Tgw_owner"
    echo "TGW_name": "$Tgw_name"
    
done

answered Mar 17, 2021 at 6:48

Marcin

241k16 gold badges315 silver badges368 bronze badges

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

3 Comments

Bala krishna Over a year ago

``` jq: error: Could not open file |: No such file or directory jq: error: Could not open file select(.Key: No such file or directory jq: error: Could not open file ==: No such file or directory jq: error: Could not open file "Name").Value: No such file or directory

Marcin Over a year ago

@Balakrishna did you copy exactly all code, not only one line of it?

Marcin Over a year ago

@Balakrishna No problem. Glad it worked out:-)

Collectives™ on Stack Overflow

Parsing AWS CLI commands

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related