Reading data from complex XML file (nested and multiple namespaces)

Jacco_De_Zwart — Wed, 20 May 2026 14:11:21 GMT

Hi all,

I have an xml file as shown here below (this is just a small part, the original file is 27Mb).

How do I extract the individual data elements from this file ?

Thanks in advance.

Jacco

<?xml version="1.0" encoding="utf-8"?>

<ns0:MessageHeader>

<ns1:AddressingInformation>

<ns1:messageID>46c25d63-6080-4be4-aba3-3a12be953294</ns1:messageID>

<ns1:relatesTo>e4c74663-9268-4a41-a3ae-4cf5910a61d1</ns1:relatesTo>

</ns1:AddressingInformation>

<ns1:RequestInformation>

<ns0:MessageHeader>

<ns1:AddressingInformation>

<ns1:messageID>e4c74663-9268-4a41-a3ae-4cf5910a61d1</ns1:messageID>

</ns1:AddressingInformation>

</ns0:MessageHeader>

<ns0:ExportType>

<ns2:Operation>

<ns5:Extract>

<ns6:SnapshotDate value="2025-10-06"/>

<ns6:ExportingEntities>

<ns8:RDView name="ICS2"/>

<ns8:RDEntityList>

<ns8:RDEntity>

<ns10:RDEntityName name="CustomsOffices"/>

</ns8:RDEntity>

</ns8:RDEntityList>

</ns6:ExportingEntities>

</ns5:Extract>

</ns2:Operation>

</ns0:ExportType>

</ns4:ExtractValidReferenceDataReqMsg>

</ns1:RequestInformation>

</ns0:MessageHeader>

<ns0:RDEntityList>

<ns2:RDEntity name="CustomsOffices">

<ns3:RDEntry>

<ns4:RDEntryStatus>

<ns5:state>valid</ns5:state>

<ns5:activeFrom>2021-01-22</ns5:activeFrom>

</ns4:RDEntryStatus>

<ns4:dataItem name="ReferenceNumber">AT010000</ns4:dataItem>

<ns4:dataItem name="CountryCode">AT</ns4:dataItem>

<ns4:dataItem name="PostalCode">8010</ns4:dataItem>

<ns4:dataItem name="PhoneNumber">+43 50 233 560</ns4:dataItem>

<ns4:dataItem name="EMailAddress">Post.za-bbw@bmf.gv.at</ns4:dataItem>

<ns4:dataItem name="GeoInfoCode">Q</ns4:dataItem>

<ns4:dataItem name="TraderDedicated">0</ns4:dataItem>

<ns4:dataGroup name="CustomsOfficeLsd">

<ns4:dataItem name="LanguageCode">DE</ns4:dataItem>

<ns4:dataItem name="CustomsOfficeUsualName">Zollamt Österreich</ns4:dataItem>

<ns4:dataItem name="StreetAndNumber">Conrad von Hötzendorf-Str. 14-18</ns4:dataItem>

<ns4:dataItem name="City">Graz</ns4:dataItem>

<ns4:dataItem name="PrefixSuffixLevel">E</ns4:dataItem>

<ns4:dataItem name="PrefixSuffixFlag">0</ns4:dataItem>

<ns4:dataItem name="SpaceToAdd">1</ns4:dataItem>

</ns4:dataGroup>

<ns4:dataGroup name="CustomsOfficeTimetable">

<ns4:dataItem name="SeasonCode">1</ns4:dataItem>

<ns4:dataItem name="SeasonName">ALL YEAR</ns4:dataItem>

<ns4:dataItem name="SeasonStartDate">20210101</ns4:dataItem>

<ns4:dataItem name="SeasonEndDate">20991231</ns4:dataItem>

<ns4:dataGroup name="CustomsOfficeTimetableLine">

<ns4:dataItem name="DayInTheWeekBeginDay">1</ns4:dataItem>

<ns4:dataItem name="OpeningHoursTimeFirstPeriodFrom">0800</ns4:dataItem>

<ns4:dataItem name="OpeningHoursTimeFirstPeriodTo">1600</ns4:dataItem>

<ns4:dataItem name="DayInTheWeekEndDay">5</ns4:dataItem>

<ns4:dataGroup name="CustomsOfficeRoleTrafficCompetence">

<ns4:dataItem name="Role">AUT</ns4:dataItem>

<ns4:dataItem name="TrafficType">C</ns4:dataItem>

</ns4:dataGroup>

<ns4:dataGroup name="CustomsOfficeRoleTrafficCompetence">

<ns4:dataItem name="Role">AUT</ns4:dataItem>

<ns4:dataItem name="TrafficType">AIR</ns4:dataItem>

</ns4:dataGroup>

<ns4:dataGroup name="CustomsOfficeRoleTrafficCompetence">

<ns4:dataItem name="Role">AUT</ns4:dataItem>

<ns4:dataItem name="TrafficType">R</ns4:dataItem>

</ns4:dataGroup>

<ns4:dataGroup name="CustomsOfficeRoleTrafficCompetence">

<ns4:dataItem name="Role">AUT</ns4:dataItem>

<ns4:dataItem name="TrafficType">V</ns4:dataItem>

</ns4:dataGroup>

</ns3:RDEntry>

</ns2:RDEntity>

</ns0:RDEntityList>

</ns8:ExtractValidReferenceDataRespMsg>

Re: Reading data from complex XML file (nested and multiple namespaces)

Greg_Taffer — Thu, 21 May 2026 12:59:47 GMT

Hey Jacco,

Here are some sample scenarios which may help:

https://help.qlik.com/talend/en-US/components/8.0/xml/xml-scenario

The component to be used should be tExtractXMLField.

If this does not help, please feel free to open a Support Ticket.

topic Reading data from complex XML file (nested and multiple namespaces) in Talend Studio

Reading data from complex XML file (nested and multiple namespaces)

Re: Reading data from complex XML file (nested and multiple namespaces)