Select Xpath element value based on value of another element

Question

I am trying to capture a value using XPath based on value of a different field.

Example XML:

<?xml version="1.0" encoding="UTF-8" ?>
<employees>
    <employee>
        <id>1</id>
        <firstName>Tom</firstName>
        <lastName>Cruise</lastName>
        <photo>https://jsonformatter.org/img/tom-cruise.jpg</photo>
    </employee>
    <employee>
        <id>2</id>
        <firstName>Maria</firstName>
        <lastName>Sharapova</lastName>
        <photo>https://jsonformatter.org/img/Maria-Sharapova.jpg</photo>
    </employee>
    <employee>
        <id>3</id>
        <firstName>Robert</firstName>
        <lastName>Downey Jr.</lastName>
        <photo>https://jsonformatter.org/img/Robert-Downey-Jr.jpg</photo>
    </employee>
</employees>

I am trying to get Xpath expression for value in the firstName field, when id value is 3.

Prophet · Accepted Answer · 2022-10-13 16:19:09Z

1

You can locate parent node based on the known child node and then find the desired child node of that parent, as following:

//employee[./id='3']/firstName

the expression above will give the desired firstName node itself.
To retrieve it's text value this can be used:

//employee[./id='3']/firstName/text()

answered Oct 13, 2022 at 16:19

Prophet

33.5k28 gold badges58 silver badges90 bronze badges

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

Collectives™ on Stack Overflow

Select Xpath element value based on value of another element

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related