topic How to get name of xml node with tExtractXmlFields in Talend Studio

How to get name of xml node with tExtractXmlFields

droth — Fri, 08 Dec 2017 09:39:55 GMT

Hello,

i'm trying to extract the name of an Xml Node with tExtractXmlFields.

This works fine for my first usecase, but for the second use cases i'm facing a problem.

The Problem is, that the node i'm trying to get the name from has a xmlns-attribute.

Error:

Works fine:

...

<web:myFunctionResponse>

I am getting the following error:

Exception in component tExtractXMLField_1
java.lang.ArrayIndexOutOfBoundsException: -1

My XPath-Query:

"name(//soap:Envelop/soap:Body/*[1])"

also tried with:

"local-name(//soap:Envelop/soap:Body/*[1])"

"name(//soap:Envelop/soap:Body/*[@xmlns='http://tempuri.org/Webservice/Function'])"

Does anyone can help me on how to fix it?

Best regards,

Dominik

droth — Mon, 18 Dec 2017 15:51:42 GMT

Does nobody know how to solve this?

Best regards,

Dominik

droth — Wed, 18 Jul 2018 15:20:20 GMT

Found out the solution by myself.

Just put "name(...)" around the xpath expression like "name(//*[1])".

vincentB1 — Fri, 08 Feb 2019 18:09:46 GMT

@droth wrote:

Found out the solution by myself.

Just put "name(...)" around the xpath expression like "name(//*[1])".