WebServiceClient SOAP response multipart

Support/help with CloverETL implementation problems

cristi.axe
Posts: 2
Joined: Thu Apr 13, 2017 8:06 am

WebServiceClient SOAP response multipart

Postby cristi.axe » Thu Apr 13, 2017 8:35 am

Hi,

I try to extract values from a WebServiceClient result component. The response look exactly like this:

------=_Part_1_234234232345
Content-Type: application/xop+xml; charset=utf-8; type="text/xml"

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/><SOAP-ENV:Body><XxResponse xmlns="http://server/service/test/" xmlns:ns0="http://test><uuid>56c584a5-7884-41b1-8086-93245sdfvf2d</uuid></XxResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
------=_Part_1_234234232345--


Is there any way to use Response mapping property of WebServiceClient component to manage this kind of response? Or other approach?
The current solution is to make the call by cUrl using ExecuteScript and Reformat stdOut response to a valid xml that can be read by an XMLExtract component by connecting IN port source stream to Reformat out port. But I'm sure Clover can do it better!

thank you,
Axe

cristi.axe
Posts: 2
Joined: Thu Apr 13, 2017 8:06 am

Re: WebServiceClient SOAP response multipart

Postby cristi.axe » Fri Apr 14, 2017 1:14 pm

Hi,

Changed ExecuteScript to HttpConnector, looks better now but still reformat of content response needed using substring/indexOf functions.

thank you,\Axe

cholastal
Posts: 106
Joined: Tue Sep 01, 2015 1:22 pm

Re: WebServiceClient SOAP response multipart

Postby cholastal » Fri Apr 21, 2017 3:35 pm

Hi Axe,

Unfortunately, neither WebServiceClient or HTTPClient has the ability to parse multipart responses. Your current solution with HTTPConnector and Reformat is the most convenient. However, you're right, sometimes it really may be useful to have such feature implemented. Therefore I've created an improvement proposal in our system. You can visit the page by following this link: https://bug.javlin.eu/browse/CLO-10820.

Thank you and best regards,
---
Lukas Cholasta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support