How to use JMESPath to filter array of object based on contains of value in subproperty arrary

Question

How use JMESPath to filter nodes that possess email receivers with exact email? I have JSON object:

   [     
     {
        "test":1,
        "emailReceivers": [
          {
            "emailAddress": "[email protected]",
          }
        ]
      },
      {
        "test":2,
        "emailReceivers": [
          {
            "emailAddress": "[email protected]",
          },
          {
            "emailAddress": "[email protected]",
          }
        ]
      }
    ]

I would like to get node after filtering by elememailReceivers that contains [email protected]:

     {
        "test":1,
        "emailReceivers": [
          {
            "emailAddress": "[email protected]",
          }
        ]
      }

I was trying to use documentation https://jmespath.org/ and examples but I failed.

β.εηοιτ.βε · Accepted Answer · 2021-05-25 16:27:51Z

4

You can indeed use contains on a filter and ask sub-keys containing a certain value.

With the query

[?contains(emailReceivers[].emailAddress, '[email protected]')]

This will give:

[
  {
    "test": 1,
    "emailReceivers": [
      {
        "emailAddress": "[email protected]"
      }
    ]
  }
]

On your example array:

[     
  {
    "test":1,
    "emailReceivers": [
      {
        "emailAddress": "[email protected]"
      }
    ]
  },
  {
    "test":2,
    "emailReceivers": [
      {
        "emailAddress": "[email protected]"
      },
      {
        "emailAddress": "[email protected]"
      }
    ]
  }
]

edited May 25, 2021 at 16:27

answered May 25, 2021 at 13:48

β.εηοιτ.βε

40.4k14 gold badges81 silver badges104 bronze badges

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

Collectives™ on Stack Overflow

How to use JMESPath to filter array of object based on contains of value in subproperty arrary

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