I am trying to parse a xml output from the Download tool. When I use the XML Parse tool it is splitting a total of 259 rows of data to 55 rows to one field1 and remaining field1_OuterXML1. When I parse again only 55 are coming and rest are again left in field1_OuterXML2 and so on. Is it possible to pull all 259 rows at a time?
Solucionado! Ir para Solução.
This will be dependant on the structure of the XML.
Are you able to upload an example of what the download tool gets or you workflow?
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<SearchRecordsByReportResponse xmlns="http://archer-tech.com/webservices/">
<SearchRecordsByReportResult>string</SearchRecordsByReportResult>
</SearchRecordsByReportResponse>
</soap:Body>
</soap:Envelope>
I am trying to parse the SearchRecordsByReportResult data..
I am not saying that the content of xml is splitting. Please see attached images. 1st image shows that SearchRecordsByReportResult returns 55 records then remaining are returned as SearchRecordsByReportResult_OuterXML. And if I parse the outer XML again I get another 55 records and returns remaining records in SearchRecordsByReportResult_OuterXML2.