CSV Connector reports "Multi level XML file is not supported."

Data Integration CData Arc
,
1

I have an XML input of

<?xml version="1.0" encoding="UTF-8"?><rows xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">  <row>    <DestCode>MET</DestCode>    <DestName>Middle East</DestName>    <Network>TD-PRIORITY</Network>    <Format>P</Format>    <LowerLimit>0 kg</LowerLimit>    <UpperLimit>0.5 kg</UpperLimit>    <ItemCount>19</ItemCount>    <KiloCount>2.506</KiloCount>  </row>  <row>    <DestCode>LTU</DestCode>    <DestName>Lithuania</DestName>    <Network>TD-PRIORITY</Network>    <Format>P</Format>    <LowerLimit>0 kg</LowerLimit>    <UpperLimit>0.5 kg</UpperLimit>    <ItemCount>3</ItemCount>    <KiloCount>0.312</KiloCount>  </row>  ...  <row>    <DestCode>FET</DestCode>    <DestName>Far East</DestName>    <Network>TD-PRIORITY</Network>    <Format>G</Format>    <LowerLimit>0 kg</LowerLimit>    <UpperLimit>0.1 kg</UpperLimit>    <ItemCount>176</ItemCount>    <KiloCount>2.335</KiloCount>  </row></rows>

Which is not a multi-level XML and matches the example in the CSV COnnector’s documentation

So I’m not sure what I’m doing wrong.

I have checked the XML file for validity.

2

So, after some investigation it turns out it doesn’t like me using “rows” or “row” in my input XML.

I changed it to

<?xml version="1.0" encoding="UTF-8"?><Items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">  <preadvice>    <DestCode>MET</DestCode>    <DestName>Middle East</DestName>    <Network>TD-PRIORITY</Network>    <Format>G</Format>    <LowerLimit>0 kg</LowerLimit>    <UpperLimit>0.5 kg</UpperLimit>    <ItemCount>19</ItemCount>    <KiloCount>2.506</KiloCount>  </preadvice>  <preadvice>    <DestCode>LTU</DestCode>...

And it works!