Skip to main content

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.

 

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!

Reply


Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=
Terms and ConditionsCookie settings