new to XML Parsing

[AmruthaPydeti]

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?

[JoeS]

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?

[AmruthaPydeti]

<?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..

[JoeS · Accepted solution]

Hi @AmruthaPydeti 

The attached should give you what you need

[AmruthaPydeti]

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.