convert the output from jq to array

Question

I have dynamodb table present in the aws account, I want to filter it based on the certain conditioning and get the result as an array

below is the aws cli query with jq

aws dynamodb scan  --table-name sample-table  | jq .Items | jq 'map(select(.VpcId.S != "None")) ' | jq  .[].VpcId.S

here is the output which I am getting:


"vpc-yyyyyyyyyyyyyyyyy"
"vpc-zzzzzzzzzzzzzzzzz"
"vpc-XXXXXXXXXxxxxxxxx"

I want the output as

[
"vpc-yyyyyyyyyyyyyyyyy",
"vpc-zzzzzzzzzzzzzzzzz",
"vpc-XXXXXXXXXxxxxxxxx"
]

so that I can pass it to the terraform.

below is the output of the actual command

aws dynamodb scan  --table-name sample-table

{
"Items": [
  {
   
    "VpcId": {
      "S": "vpc-yyyyyyyyyyyyyyyyy"
    }
  },
    {
   
    "VpcId": {
      "S": "None"
    }
  },
  {
   
    "VpcId": {
      "S": "vpc-xxxxxxxxxxxxxxxxx"
    }
  },
  }
]
}

customcommander · Accepted Answer · 2021-04-14 10:38:58Z

4

Replace .[].VpcId.S with map(.VpcId.S). The .[] syntax takes the elements out of the array.

You can combine your different jq filters together in this way:

.Items | map(select(.VpcId.S != "None") | .VpcId.S)

edited Apr 14, 2021 at 10:38

answered Apr 14, 2021 at 10:32

customcommander

19.3k6 gold badges70 silver badges96 bronze badges

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

Collectives™ on Stack Overflow

convert the output from jq to array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related