topic Re: tExtractXMLFIelds and attributes with dot ( . ) in the name in Talend Studio

tExtractXMLFIelds and attributes with dot ( . ) in the name

Jacco_De_Zwart — Tue, 27 May 2025 07:54:44 GMT

Hi all,

I have an XML payload which is captured by tRestRequest. In this XML payload I have attributes in with a dot.

Like this :

<dispatch_status_entries>
<entry qualifier="dispatch.status.arrival">2025-05-25T16:12:23.000+02:00</entry>
<entry qualifier="dispatch.status.loading.begin">2025-05-26T17:45:30.000+02:00</entry>
<entry qualifier="dispatch.status.loading.end"/>
<entry qualifier="dispatch.status.departure"/>
</dispatch_status_entries>

</booking>

I have set 'Loop Xpath query' to "/booking" and the xpath for retrieve a entry looks like this :

/extensions/entry[@qualifier='dispatch.status.arrival']/text()

to get the arrival timestamp. But all I get is a null value.

How to I extract the values for the entry 'dispatch.status.arrival' using tExtractXMLField using XPath ?

Re: tExtractXMLFIelds and attributes with dot ( . ) in the name

Dave_Simo — Tue, 27 May 2025 08:51:53 GMT

Hello @Jacco_De_Zwart

You can use xpath query as below.

Best Regards

Re: tExtractXMLFIelds and attributes with dot ( . ) in the name

Jacco_De_Zwart — Tue, 27 May 2025 13:09:38 GMT

@Dave_Simo

Thanks for your tip !

Had to test it a few times. I had to check the box 'Ignore the namespaces' in advanced settings to get it working.

But you pointed in the right direction

Thanks