JMESPath JSON filter with multiple matches

json amazon-cloudformation jmespath
Sam picture Sam · Jun 21, 2016 · Viewed 7.2k times · Source

I have a json block that looks a bit like this (have you guessed from AWS)

{ "Vpcs":[ 
  {
    "VpcId":"vpc-blabla1",
    "OtherKey":"Value"
  },
  {
    "VpcId":"vpc-blabla2",
    "OtherKey":"Value"
  },
  {
    "VpcId":"vpc-blabla3",
    "OtherKey":"Value"
  },
  {
    "VpcId":"vpc-blabla4",
    "OtherKey":"Value"
  }]
}

I want to use JMESPath to get the OtherKey value for vpc-blabla1 and vpc-blabla3 (Examples, could be any list of vpc-id)

I can get blabla1 with JMESpath filter 

Vpcs[?VpcId=='blabla1'].OtherKey

But I can't find the syntax for multiple values? I have tried the Or syntax || and the composite syntax | but neither works? - See below for things I have tried.

 Vpcs[?VpcId=='blabla1' || 'blabla1'].OtherKey
 Vpcs[?VpcId=='blabla1' || ?VpcId=='blabla1'].OtherKey
 Vpcs[(?VpcId=='blabla1') || (?VpcId=='blabla1')].OtherKey
 Vpcs[?VpcId=='blabla1' | ?VpcId=='blabla1'].OtherKey

Any suggestions? Is this possible or am I going to have to gather one result set at a time and recombine the results I want?

Answer

jamesls picture jamesls · Jun 21, 2016

The general syntax for multiple is [? expr1 || expr2] so in your case, you can use:

Vpcs[?VpcId=='vpc-blabla1' || VpcId=='vpc-blabla2'].OtherKey

Another option, if you have many VPC ids you're search for, you can also say:

Vpcs[?contains(`["vpc-blabla1", "vpc-blabla2"]`, VpcId)].OtherKey

Related questions

Can I use "Fn::Join" in "Parameters" of AWS Cloudformation json template

I want to use in Parameters of Cloudformation json template shortcut of some Policy/Loadbalancers tags name, like that: "SomeScalingGroupName": { "Type": "String", "Default": {"Fn::Join": ["", ["Process-", {"Ref": "Env"}, "-Some-Worker-Name"]]} }, And I get error: Template validation error: Template format error: Every …

Read More
AWS: Cloud Formation: Is it possible to use multiple "DependsOn"?

Given i have this example template: { "AWSTemplateFormatVersion" : "2010-09-09", "Mappings" : { "RegionMap" : { "us-west-1" : { "AMI" : "ami-655a0a20" }, ... } }, "Resources" : { "Ec2Instance" : { "Type" : "AWS::EC2::Instance", "Properties" : { ... }, "DependsOn" : "myDB" }, "myDB" : { "Type" : "AWS::RDS::DBInstance", "Properties" : { ... } }, "myDB2" : { "Type" : "AWS::RDS::DBInstance", "Properties" : { ... } } } } Is it …

Read More
Template error: instance of Fn::GetAtt references undefined resource

I have this cloudformation template : "InstanceProfileProd": { "Type" : "AWS::IAM::InstanceProfile", "Properties": { "Path": "/", "Roles" : [ { "Ref" : "InstanceRole"} ] } }, "CompLayer": { "Type": "AWS::OpsWorks::Layer", "DependsOn" : "OpsWorksServiceRole", "Properties": { "AutoAssignElasticIps" : false, "AutoAssignPublicIps" : true, "CustomJson" : { }, "awscli" : { "profils" : { "default" : { "role_arn": { "Fn::GetAtt": [ "InstanceProfileProd","Arn" ] } } } }, }, "CustomSecurityGroupIds" : { "Ref" : "SecurityGroupIds" }, "…

Read More