Convert Soap Document to CSV

ptromblee — Wed, 02 Jul 2014 20:45:09 GMT

Hi,
I'm using tSoap to connect to a Soap Web Service and I can output the response with tLogRow. Now I need to convert the response to CSV but am struggling with how to do it. I'm assuming I need to use tMapXML as I don't need to output everything. However I'm unsure how to build the schema of the soap document.
This is the schema. Can someone help me? Much Appreciated.

<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://www.JOI.com/schemas/ViaSub.WMS/" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="FindOrders">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="orders">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="order" maxOccurs="unbounded" minOccurs="0">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element type="xs:string" name="CustomerName"/>
                    <xs:element type="xs:string" name="CustomerEmail"/>
                    <xs:element type="xs:string" name="CustomerPhone"/>
                    <xs:element type="xs:string" name="Facility"/>
                    <xs:element type="xs:byte" name="FacilityID"/>
                    <xs:element type="xs:byte" name="WarehouseTransactionID"/>
                    <xs:element type="xs:string" name="ReferenceNum"/>
                    <xs:element type="xs:string" name="PONum"/>
                    <xs:element type="xs:string" name="Retailer"/>
                    <xs:element type="xs:string" name="ShipToCompanyName"/>
                    <xs:element type="xs:string" name="ShipToName"/>
                    <xs:element type="xs:string" name="ShipToEmail"/>
                    <xs:element type="xs:string" name="ShipToPhone"/>
                    <xs:element type="xs:string" name="ShipToAddress1"/>
                    <xs:element type="xs:string" name="ShipToAddress2"/>
                    <xs:element type="xs:string" name="ShipToCity"/>
                    <xs:element type="xs:string" name="ShipToState"/>
                    <xs:element type="xs:string" name="ShipToZip"/>
                    <xs:element type="xs:string" name="ShipToCountry"/>
                    <xs:element type="xs:string" name="ShipMethod"/>
                    <xs:element type="xs:string" name="MarkForName"/>
                    <xs:element type="xs:string" name="BatchOrderID"/>
                    <xs:element type="xs:dateTime" name="CreationDate"/>
                    <xs:element type="xs:string" name="EarliestShipDate"/>
                    <xs:element type="xs:string" name="ShipCancelDate"/>
                    <xs:element type="xs:string" name="PickupDate"/>
                    <xs:element type="xs:string" name="Carrier"/>
                    <xs:element type="xs:string" name="BillingCode"/>
                    <xs:element type="xs:float" name="TotWeight"/>
                    <xs:element type="xs:float" name="TotCuFt"/>
                    <xs:element type="xs:float" name="TotPackages"/>
                    <xs:element type="xs:float" name="TotOrdQty"/>
                    <xs:element type="xs:float" name="TotLines"/>
                    <xs:element type="xs:string" name="Notes"/>
                    <xs:element type="xs:string" name="OverAllocated"/>
                    <xs:element type="xs:string" name="PickTicketPrintDate"/>
                    <xs:element type="xs:date" name="ProcessDate"/>
                    <xs:element type="xs:string" name="TrackingNumber"/>
                    <xs:element type="xs:string" name="LoadNumber"/>
                    <xs:element type="xs:string" name="BillOfLading"/>
                    <xs:element type="xs:string" name="MasterBillOfLading"/>
                    <xs:element type="xs:string" name="ASNSentDate"/>
                    <xs:element type="xs:string" name="ConfirmASNSentDate"/>
                    <xs:element type="xs:string" name="RememberRowInfo"/>
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="totalOrders" type="xs:byte"/>
</xs:schema>

Re: Convert Soap Document to CSV

ptromblee — Wed, 02 Jul 2014 22:37:32 GMT

What I have right now is:
tSoap ---> OrderTemplate (created a file xml schema) ---> tLogRow
I get 1 row returned between tSoap and OrderTemplate but 0 rows to tLogRow.
Am I going about this the correct way?

topic Re: Convert Soap Document to CSV in Talend Studio

Convert Soap Document to CSV

Re: Convert Soap Document to CSV