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

[Jacco_De_Zwart]

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

<ns8:ExtractValidReferenceDataRespMsg xsi:schemaLocation="" xmlns:ns0="http://xmlns.ec.eu/BusinessObjects/CSRD2/ReferenceDataExportBASServiceType/V2" xmlns:ns1="http://xmlns.ec.eu/BusinessObjects/CSRD2/MessageHeaderType/V2" xmlns:ns2="http://xmlns.ec.eu/BusinessObjects/CSRD2/RDEntityEntryListType/V2" xmlns:ns3="http://xmlns.ec.eu/BusinessObjects/CSRD2/RDEntityType/V2" xmlns:ns4="http://xmlns.ec.eu/BusinessObjects/CSRD2/RDEntryType/V2" xmlns:ns5="http://xmlns.ec.eu/BusinessObjects/CSRD2/RDStatusType/V2" xmlns:ns6="http://xmlns.ec.eu/BusinessObjects/CSRD2/RDValidityPeriodType/V2" xmlns:ns7="http://xmlns.ec.eu/BusinessObjects/CSRD2/LsdListType/V2" xmlns:ns8="http://xmlns.ec.eu/BusinessActivityService/CSRD2/IReferenceDataExportBAS/V2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

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

<ns4:ExtractValidReferenceDataReqMsg xmlns:ns6="http://xmlns.ec.eu/BusinessObjects/CSRD2/ExtractType/V2" xmlns:ns5="http://xmlns.ec.eu/BusinessObjects/CSRD2/OperationType/V2" xmlns:ns8="http://xmlns.ec.eu/BusinessObjects/CSRD2/ExportingEntitiesType/V2" xmlns:ns12="http://xmlns.ec.eu/BusinessObjects/CSRD2/FilterRefType/V2" xmlns:ns10="http://xmlns.ec.eu/BusinessObjects/CSRD2/RDEntityFilterPairType/V2" xmlns:ns16="http://xmlns.ec.eu/BusinessObjects/CSRD2/LanguageDescriptionsType/V2" xmlns:ns15="http://xmlns.ec.eu/BusinessObjects/CSRD2/SynchronisationExtractType/V2" xmlns:ns14="http://xmlns.ec.eu/BusinessObjects/CSRD2/RetrieveType/V2" xmlns:ns2="http://xmlns.ec.eu/BusinessObjects/CSRD2/ExportType/V2" xmlns:ns4="http://xmlns.ec.eu/BusinessActivityService/CSRD2/IReferenceDataExportBAS/V2" xmlns:ns3="http://xmlns.ec.eu/BusinessObjects/CSRD2/StatementsType/V2">

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

</ns4:dataGroup>

</ns4:dataGroup>

</ns3:RDEntry>

</ns2:RDEntity>

</ns0:RDEntityList>

</ns8:ExtractValidReferenceDataRespMsg>

[Greg_Taffer]

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.