Skip to main content
Solved

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

  • July 5, 2023
  • 1 reply
  • 59 views
R
Forum|alt.badge.img+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.

 

Best answer by russell-jerseypost

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!

This topic has been closed for replies.

1 reply

R
Forum|alt.badge.img+1

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!

State of AI Data Connectivity Report: 2026 Outlook
Terms and ConditionsCookie settingsAccessibility statement