topic Help on parsing a XML Document in Talend Studio

Help on parsing a XML Document

Karuetl — Tue, 14 May 2019 16:56:31 GMT

Need help to parse ID and Name from below xml

<?xml version="1.0" encoding="ISO-8859-15"?>
<root>
<row>
<Soap><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<GetFilteredCustomReportResponse xmlns="abcIP">
<GetFilteredCustomReportResult>
<DtoObject>
<ReportData>[{"ID":1,"Name":"Active"},{"ID":3,"Name":"Canceled"}]</ReportData>
<NumberOfPages>1</NumberOfPages>
</DtoObject>
<Response>Successful</Response>
<Successful>true</Successful>
</GetFilteredCustomReportResult>
</GetFilteredCustomReportResponse>
</soap:Body>
</soap:Envelope>
</Soap>
</row>
</root>

Re: Help on parsing a XML Document

nfz11 — Tue, 14 May 2019 18:10:03 GMT

You would first have to parse the XML to get the contents of the ReportData element as a string. Those contents are JSON. You would then parse those contents to get the id and name.

Look at tExtractXMLFields for the former and tExtractJSONFields for the latter.

Re: Help on parsing a XML Document

Karuetl — Tue, 14 May 2019 18:25:55 GMT

in tFileInputXML

What should be the Column and Xpath Query under mapping