F-Script

Auslesen einer xml-Datei mit Namespaces

<Document xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.1" type="standard" xmlns="http://www.moderna.ch/XMLSchema/2.1">
    <JourNalNo>2018-11-23-001.002.003</JourNalNo>
    <SalDocs>
        <SalDoc>
        <SalDoc.InternalNo>5000</SalDoc.InternalNo>
        <SalDoc.CustNo>1000</SalDoc.CustNo> 
            <SalDocItems>
                <SalDocItem>
                    <SalDocItem.ArtNo>101</SalDocItem.ArtNo>
                    <SalDocItem.Name xmlns="http://www.moderna.ch/namen">Winkelschleifer A</SalDocItem.Name>
                </SalDocItem>
                <SalDocItem>
                    <SalDocItem.ArtNo>102</SalDocItem.ArtNo>
                    <SalDocItem.Name xmlns="http://www.moderna.ch/namen">Winkelschleifer B</SalDocItem.Name>
                </SalDocItem>                
             </SalDocItems>
        </SalDoc>     
    </SalDocs>
</Document>

Common.XmlQuery
SourceFile= myXML.xml
Namespace=ns1,http://www.moderna.ch/XMLSchema/2.1
Namespace=ns2,http://www.moderna.ch/namen
Rows=/ns1:Document/ns1:SalDocs/ns1:SalDoc/ns1:SalDocItems/ns1:SalDocItem
Column=SalDoc.ArtNo,ns1:SalDocItem.ArtNo/text()
Column=SalDoc.Name,ns2:SalDocItem.Name/text()