Parsing xml with multiple headers Talend

Anonymous — Wed, 25 Apr 2018 23:33:23 GMT

Hello community,

I'm trying to read xml data received from trestclient which have multiple header

Example :

<?xml version="1.0" encoding="utf-8"?>                         
 <RepeaterData>
<Version />
<Items>
    <Item>
        <year>2017</year>
        <Additional>
            <?xml version="1.0" encoding="utf-8"?>
            <RepeaterData>
                <Version />
                <Items>
                        <Name>toto</Nom>
                </Items>
            </RepeaterData>
        </AdditionalCharge>
    </Item>
    <Item>
        <year>2018</year>
        <Additional >
            <?xml version="1.0" encoding="utf-8"?>
            <RepeaterData>
                <Version />
                <Items>
                    <Item>
                        <element type="System.String">3</Sousdept>
                        <Name type="System.String">toto</Nom>
                        </Item>
                    <Item>
                        <element type="System.String">3</Sousdept>
                        <Name type="System.String">tata</Nom>
                        </Item>
                </Items>
            </RepeaterData>
        </Additional>
    </Item>
</Items>

I tried also to delete the xml header with StringHandling.EREPLACE ( b ,"<?xml version=1.0 encoding=utf-8?>",""); but it's not working

Help please !!!!

Re: Parsing xml with multiple headers Talend

vapukov — Thu, 26 Apr 2018 03:30:49 GMT

You have a lot of errors in this XML

and additional header is only part of many

You need seriously debug structure with proper XML tools, as variant - Oxygen or Altova (or similar)

Re: Parsing xml with multiple headers Talend

Anonymous — Thu, 26 Apr 2018 07:42:11 GMT

@vapukov OK for Xml errors but how to parse an XML with two headers with Talend ? ( this Xml i get it from a TRestClient )

topic Re: Parsing xml with multiple headers Talend in Talend Studio

Parsing xml with multiple headers Talend

Re: Parsing xml with multiple headers Talend

Re: Parsing xml with multiple headers Talend