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