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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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