Four Stars

Convert Soap Document to CSV

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>
1 REPLY
Four Stars

Re: Convert Soap Document to CSV

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?