new to XML Parsing

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?

Iterative Macro

Accepted answers

JoeS

Hi @AmruthaPydeti

The attached should give you what you need

XML.yxmd

All comments

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703