We are consuming a web service response xml and I am able to retrieve data for s

Correction....relative not realize...sorry

In XPath, using "//" says, "Get this node everywhere in the XML no matter where it is." In order to specify only some paths to the node, you will need to give the full path instead. I _think_ something like this should work, /root-element/parent/*[local-name(.)='ReturnCode']/text()")) = ""

"root-element" and "parent" should be replaced as appropriate based on your specific XML structure.

I've always relied on the W3Schools XPath tutorial as a reference. www.w3schools.com/.../

The XPath Tester (http://www.xpathtester.com/) is another good tool. It takes an XPath and XML as input and it displays the results from the XPATH transformation.

Owen - I tried what you stated (this is what I call absolute path) and it fails....

Here is the end tags and the error message. I cannot include the entire error due to confidentiality. The ReturnCode tag I ned to get is within the Account tag.

</Account> </Accounts> </Customer> </GetCustomerAccountsResponseMessage> </GetCustomerAccountsResponse> </soapenv:Body> </soapenv:Envelope>","/GetCustomerAccountsResponse/GetCustomerAccountsResponseMessage/Customer/Accounts/Account*[local-name(.)='ReturnCode']/text()")' (user=kwellman, exprId=268435793) could not be evaluated: An error occurred while trying to evaluate the XPath expression (/GetCustomerAccountsResponse/GetCustomerAccountsResponseMessage/Customer/Accounts/Account*[local-name(.)='ReturnCode']/text()). (APNX-1-4157-003) (Data Outputs)

This is the exact syntax for the node: if( (xpathsnippet(pv!accountResponseBody_Txt, "/GetCustomerAccountsResponse/GetCustomerAccountsResponseMessage/Customer/Accounts/Account*[local-name(.)='ReturnCode']/text()")) = "", "", xpathsnippet(pv!accountResponseBody_Txt, "/GetCustomerAccountsResponse/GetCustomerAccountsResponseMessage/Customer/Accounts/Account*[local-name(.)='ReturnCode']/text()") )

It looks like you might be missing a slash after "Account" You also probably need to user the local-name function at every level.

/*[local-name()='GetCustomerAccountsResponse']/*[local-name()='GetCustomerAccountsResponseN=Message']/*[local-name()='Customer']/*[local-name()='Accounts]/*[local-name()='Account']//*[local-name()='ReturnCode']/text()

This looks different then my syntax...I'll try this. Thanks!

is this part a typo? 'GetCustomerAccountsResponseN=Message'?

Yes

We were able to get this to work but we had to strip off the <soap> tags at the beginning and end of the xml response. Thanks Owen....this was critical to parsing the response! Now if I could just get the boolean logic to work, all my issues will be resolved.