topic Re: Web service : send a csv file in response in Talend Studio

Web service : send a csv file in response

Ahhouais — Sat, 16 Nov 2024 11:33:11 GMT

Hi everybody,
I would like to design a Web service that can send a user un file (.csv or .txt) containing some rows extracted from a table.
I want to call this Web service from a browser and I want to be able to give some parameters in the URL.
For instance, I want to send a file containing all the countries with a name starting by a letter.
The URL could be http://localhost:8040/listCountries?letter=F
For designing this Web service, which components can I use ?
I though to this orchestration :
tRESTRequest --tFlowToIterate--tMySQLInput--tXMLMap--tRESTResponse but I have some questions :
1) How can I get the parameter 'letter' given in the URL ?
2) Once I have executed the request, how can I set the tRESTResponse to send a file ?
Any help would be appreciated.
Thanks

Re: Web service : send a csv file in response

Ahhouais — Wed, 06 Aug 2014 14:29:44 GMT

Hi,
I have done this :
tRESTRequest--(main)-->tFlowToIterate--(iterate)--tJava--(onComponentOK)--tFixedFlowInput--(main)--tXMLMap--(main)--tRESTResponse
In the tJava, I have hardcoded some lines in order to put the file in a globalMap as a byte array :
String filePath = "C:/eula.1036.txt";
byte[] t_byte = (byte[]) routines.SynotisFileUtils.getByteArrayFromFile(filePath);
globalMap.put("mon_fichier", (byte[]) t_byte);
In the tRESTResponse, I have set the "Content-type" ("text/plain") and the "Content-disposition" ("attachment").
It seems to work but the file is empty...
Any idea ?

Re: Web service : send a csv file in response

Ahhouais — Tue, 12 Aug 2014 15:20:34 GMT

Any idea ?

Re: Web service : send a csv file in response

_AnonymousUser — Thu, 04 Sep 2014 04:14:05 GMT

4FMPci <a href="">gyzqdbdcujdu</a>, osbeugmytpcu, fgnyltdbsoen,

Re: Web service : send a csv file in response

Ahhouais — Wed, 24 Sep 2014 09:48:18 GMT

Sorry ?
Still can't send my result in the response...