Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Jacco_De_Zwart
Creator
Creator

tExtractXMLFIelds and attributes with dot ( . ) in the name

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 :

<booking>

<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 ?

 

 

 

Labels (3)
1 Solution

Accepted Solutions
Dave_Simo
Creator II
Creator II

Hello @Jacco_De_Zwart 


You can use xpath query as below.

Dave_Simo_1-1748335870290.png

Dave_Simo_0-1748335835196.png

Best Regards

 

View solution in original post

2 Replies
Dave_Simo
Creator II
Creator II

Hello @Jacco_De_Zwart 


You can use xpath query as below.

Dave_Simo_1-1748335870290.png

Dave_Simo_0-1748335835196.png

Best Regards

 

Jacco_De_Zwart
Creator
Creator
Author

@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