topic Re: Empty retourne from TextractXmlField in Talend Studio

Empty retourne from TextractXmlField

hbensaid — Sat, 02 Jun 2018 13:24:07 GMT

Hi,

Can you please help to solve this issue:

I'm sending one getBank WS correctly, but when i'm tryinng to extract specific field i got empty result:

[statistics] connecting to socket on port 3368
[statistics] connected
|||
[statistics] disconnected

the WS result when i use tlogRow without tExtractXmlField:

<ns1:details xmlns:ns1="http://thomas-bayer.com/blz/">
<ns1:bezeichnung>Sparkasse KölnBonn</ns1:bezeichnung>
<ns1:bic>COLSDE33XXX</ns1:bic>
<ns1rt>Köln</ns1rt>
<ns1lz>50667</ns1lz>
</ns1:details>

Re: Empty retourne from TextractXmlField

Anonymous — Sat, 02 Jun 2018 14:09:36 GMT

You shouldn't need the "." in your loop XPath. Just use "/details". You will also need to use the "Ignore namespace" option in the advanced settings tab. You may need to tweak your column XPaths, but you will be on the right path.

Re: Empty retourne from TextractXmlField

hbensaid — Sat, 02 Jun 2018 14:52:35 GMT

Thank very much rhall, it's ok now the "Ignore namespace" option it's what i missed.