Struggling to define JSON Path for an object which can also be an array

Question

I have some JSON data from a third-party and I am using JSON Path to transform the data. Below is a sample of the JSON data and the expressions I am trying.

{
  "Traveller": [
    {
      "FirstName": "Passenger",
      "LastName": "One",
      "EmailAddresses": {
        "Email": {
          "EmailAddress": [
            "[email protected]",
            "[email protected]"
          ]
        }
      }      
    },
    {
      "FirstName": "Passenger",
      "LastName": "Two",
      "EmailAddresses": {
        "Email": {
          "EmailAddress": "[email protected]"
        }
      }
    }
  ]
}

I can get the array of email address fine using the following expression:

$..Traveller[*].EmailAddresses.Email.EmailAddress[*]
Returns
[
  "[email protected]",
  "[email protected]"
]

But I require an expression which will return just the "[email protected]".

I have tried the following expressions:

$..Traveller[*].EmailAddresses.Email.EmailAddress.*
$..Traveller[*].EmailAddresses.Email.EmailAddress[2]

I think I need someway of filtering to the EmailAddress where it is NOT an array.

moonwave99 · Accepted Answer · 2025-01-06 18:47:06Z

1

From all the Traveller:

get all whose EmailAddresses.Email.EmailAddress are not array accessible ([?([email protected][0])]);
then extract their EmailAddresses.Email.EmailAddress.

All together:

$..Traveller[?([email protected][0])].EmailAddresses.Email.EmailAddress

answered Jan 6 at 18:47

moonwave99

22.9k3 gold badges48 silver badges71 bronze badges

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

Collectives™ on Stack Overflow

Struggling to define JSON Path for an object which can also be an 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