I'm trying to create and xpath expression that returns me the value of a node however I found my self unable to do so as the element is within another element that has a different namespace from the root.
For example I'm trying to retrieve the InternalSystemId from the following xml but traditional XML won't work
XPATH I'm trying to use
/SomeMessage[1]
/MessageDetails[1]
/PAYLOAD[1]
/Call-Name[1]
/Body[1]
/ActionToTake[1]
/Fields[1]
/InternalSystemId[1]
XML I'm have
<?xml version="1.0" encoding="UTF-8"?>
<SomeMessage>
<MessageDetails>
<FROM/>
<TO/>
<PAYLOAD>
<Call-Name
xmlns:ns0="http://www.mysite.com/interface/genericnamespace"
xmlns="http://www.mysite.com/interface/genericnamespace">
<Header xmlns="">
<Transaction>
<Mandatory>
<TransactionId>111111</TransactionId>
</Mandatory>
<System-Use-Only>
<Name>Receiver</Name>
<Someone>Customer</Someone>
<Something>OUT</Something>
</System-Use-Only>
</Transaction>
</Header>
<Body xmlns="">
<ActionToTake>
<TransactionName>ActionToTake</TransactionName>
<Fields>
<InterfaceId>w00tie</InterfaceId>
<CustomerSystemId>555555</CustomerSystemId>
<InternalSystemId>4444444</InternalSystemId>
<SubmittedDate
>2011-04-14T12:00:00-00:00</SubmittedDate>
<EventType>A type</EventType>
</Fields>
</ActionToTake>
</Body>
</Call-Name>
</PAYLOAD>
</MessageDetails>
</SomeMessage>