Help on parsing a XML Document

[Karuetl]

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>

[nfz11 · Accepted solution]

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.

[Karuetl]

in tFileInputXML 

What should be  the Column and Xpath Query under mapping