topic Re: Retrieve attachment (octet-stream) from SOAP or REST webservice in Talend Studio

Retrieve attachment (octet-stream) from SOAP or REST webservice

Anonymous — Tue, 07 Jan 2020 11:26:12 GMT

Hello,

I've done a lot of research and I can't find a reliable solution to my issue:

I'm using talend DI 7.1.

I'm trying to call a webservice (my provider publishes it as a REST as well as a SOAP webservice) and retrieve the PDF attchment returned by this webservice.

I successfully achieved this with SOAPUI (both ways; REST and SOAP) (soapui.png). But whith this tools, you only have to double click on the attachment to display it (soapui2.png).

But I really don't know how to do this with Talend DI.

talend1.png, talend2.png and talend3.png will show you how I managed it until now.

I successfully call the webservice (both ways; in the screenshot, I kept only REST), which returns "OK". But how to retrieve the attachment?

My issue seems to be an encoding issue, as characters are modified by tRestClient. (expected.png is what Soapui get, actual.png is what is written in my tFileouputDelimited).

FYI I tried UTF-8 and ISO-8859-15 as encoding (I 'm in France) and even if characters are different, the result is not the one I expect.

I read somewhere to use a tFileFetch to retrieve the attchment, using the URL sent in the response BUT there is no URL in the response.

I read that I need to get the response as binary but I don't know how to manage this.

And I read that the response could be encode64-based but I don't know how to manage this neither.

Could you please help me?

Don't hesitate to ask more details if needed.

Thanks

Re: Retrieve attachment (octet-stream) from SOAP or REST webservice

Anonymous — Tue, 07 Jan 2020 11:27:18 GMT

Adding last 2 screenshot with expected result and actual one.

Thanks

actual.png
expected.png

Re: Retrieve attachment (octet-stream) from SOAP or REST webservice

Anonymous — Fri, 17 Apr 2020 12:52:58 GMT

Re: Retrieve attachment (octet-stream) from SOAP or REST webservice

Anonymous — Tue, 21 Apr 2020 09:14:21 GMT

Hi,

I wanted to give the solution to this issue. (using the SOAP webservice)

FYI I tried every component allowing to call a webservice, I guess.

The one I successfully used to achieve this, is tHttpRequest.

- First write the xml file you wish to send to the webservice as parameters. (you need to write everything from the root node)

- Read this file in a tHttpRequest (checking option "Post parameters from file" (you can put "onComponentOk" beteween writing the xml and thttpRequest component)

- Set up the httpRequest with the webservice's endpoint in the "URI" field

- Check "the out to file option " (in French: "Ecrire le contenu de la réponse dans le fichier")

- Set the path of this output

- Read this file with a tFileInputRaw (you can pu a onComponentOK between thttpRequest en tFileInputRaw) (it doesn't seem to be mandatory to check "read the file as a byte array")

- Write in a tFileOutputRaw (with a main link between Input and output).

I'm not sur the encoding of the tFileoutputRaw is relevant, but I set it to my local encoding (ISO-8859-15)

Even if the response is a multipart one, it works, I'm not sure why. (I'm not used to webservices)

I'm pretty sure it will work with a REST webservice. But I won't try it right now.