jmespath :select json object element based on other (array) element in the object

Question

I have this JSON

{
    "srv_config": [{
             "name": "db1",
             "servers": ["srv1", "srv2"],
             "prop": [{"source":"aa"},"destination":"bb"},{"source":"cc"},"destination":"cc"},]
         }, {
             "name": "db2",
             "servers": ["srv2", "srv2"],
             "prop": [{"source":"dd"},"destination":"dd"},{"source":"ee"},"destination":"ee"},]
         }
     ]
 }

I try to build a JMESPath expression to select the prop application in each object in the main array, but based on the existence of a string in the servers element.

To select all props, I can do:

*.props [*]

But how do I add condition that says "select only if srv1 is in servers list"?

Take care that your manual edition of your JSON made it invalid. — β.εηοιτ.βε
– β.εηοιτ.βε, Commented Aug 8, 2021 at 21:02

β.εηοιτ.βε · Accepted Answer · 2021-08-08 21:04:41Z

1

You can use the contains function in order to filter based on a array containing something.

Given the query:

*[?contains(servers, `srv1`)].prop | [][]

This gives us:

[
  {
    "source": "aa",
    "destination": "bb"
  },
  {
    "source": "cc",
    "destination": "cc"
  }
]

Please mind that I am also using a bit of flattening here.

All this run towards a corrected version of you JSON:

{
   "srv_config":[
      {
         "name":"db1",
         "servers":[
            "srv1",
            "srv2"
         ],
         "prop":[
            {
               "source":"aa",
               "destination":"bb"
            },
            {
               "source":"cc",
               "destination":"cc"
            }
         ]
      },
      {
         "name":"db2",
         "servers":[
            "srv2",
            "srv2"
         ],
         "prop":[
            {
               "source":"dd",
               "destination":"dd"
            },
            {
               "source":"ee",
               "destination":"ee"
            }
         ]
      }
   ]
}

answered Aug 8, 2021 at 21:04

β.εηοιτ.βε

40.3k14 gold badges81 silver badges104 bronze badges

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

1 Comment

user63898 Over a year ago

its working in the Jmespath Tester but in my ansible code it just return empty string

Collectives™ on Stack Overflow

jmespath :select json object element based on other (array) element in the object

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