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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Data from and to a webservice

Hi everybody,
I know that with Talend, you can easily design a job and then call it via a web-service.
My question is: can we pass data to this job, and then receive data from it?
To make my point clearer, let's imagine a situation where I have a simple form with 2 or 3 fields. Each time this form is submitted, i want to send the entered data (using a webservice call) to a Talend job that will store the data in the proper databases, and then I want the job to send a confirmation response back.
Can I use Talend to implement this situation?
Thanks

Labels (2)
15 Replies
Anonymous
Not applicable

Hi everyone,
Is tWebServiceOutput available in next release? I don't see this component available in 3.0.3.
Thanks,
CC
Anonymous
Not applicable

Hi all,
I use Talend to create two different kind of jobs :
- batch launched with a .sh file
- webservices called by other applications.
In those batches jobs I use context variables in order to determine datas needed for the database connection. No problem !
But in my webservices I would like to pass some parameters like a name or something else. Should I use context variables too or is there something else ?
I would like to distinguish system parameters (parameters for the database) and functional parameters (the real webservice parameters).

Sorry for my english ...
Thx in advance
_AnonymousUser
Specialist III
Specialist III
Author

I have a same question , I have job data base in talend and have to pass data from talend data base to web services through which i can create a data in mine data base
please suggest how can proceed for this
Thanks!
Anonymous
Not applicable

I have similar problem and I cannot fin the information in the forum.
My question is regarding in more details the usage of the web-service call (see the attached picture)
My web service have a method who takes two parameters like in the following exemple:
<ENVELOPE SOAPENV=" http://schemas.xmlsoap.org/soap/envelope/" NS=" http://www.restfulwebservices.net/ServiceContracts/2008/01">
<HEADER></HEADER>
<BODY>
<GETCONVERSIONRATE>

<FROMCURRENCY>CHF</FROMCURRENCY>

<TOCURRENCY>EUR</TOCURRENCY>
</GETCONVERSIONRATE>
</BODY>
</ENVELOPE>
I want these two parameters to be injected from a DB table (a view in fact).
I cannot find the place where I can define FromCurrency and ToCurrency in the webservice_input component.
Are the values passed by order (the 1st one will be FromCurrency, and the 2nd mapped to ToCurrency implicitely)
I tried like this but I got an error :
Exception in component tWebServiceInput_1
java.lang.RuntimeException: not know how to convert 'CHF' into org.apache.axis.client.Call@1f54c5f
at org.talend.DynamicInvoker.getParamData(DynamicInvoker.java:370)
...
Like the parameters are not in the right type (the values are String in DB and iterated from the mySqlInput)
Note that with SOAPUI, the service is working fine.
I tried to follow the instruction from this post: https://community.talend.com/t5/Design-and-Development/How-to-insert-a-delay/td-p/65062
Thanks in advance for your help.

Patrick
_AnonymousUser
Specialist III
Specialist III
Author

any update on this one? i seem to have the same need:
user input query in a web page --> talend exported job as web service --> call to database --->|
display db data as tables/db structure not SOAP <-- talend exported job as web service<-- returned db data <--- |
Anonymous
Not applicable

Hi All,
Even am also looking for the same.
Can anyone please help ?
Thanks,
Arun