Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ptromblee
Contributor
Contributor

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>
Labels (4)
1 Reply
ptromblee
Contributor
Contributor
Author

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?