topic Re: [resolved] Passing values to tSOAP from tFileInputDelimited in Talend Studio

[resolved] Passing values to tSOAP from tFileInputDelimited

Anonymous — Sat, 16 Nov 2024 12:19:40 GMT

Hi i am a new to TOS.
My job is to call a web service and store the out put in a file.
Note: My web service uses external XSD and complex data type.
I used tSOAP to send soap request to the web service and it gives soap response. My soap request may have a two or more inputs.
Now my job is to use a tFileInputDelimited to read the request parameters from the csv file and pass those values to the tSOAP. In the below soap message I like to pass the Number1 and Number2 as input from csv file.
"<soapenv:Envelope xmlns:soapenv=\" http://schemas.xmlsoap.org/soap/envelope/\" xmlns:sch=\" http://treetechnologies.com/hr/schemas\">
<soapenv:Header/>
<soapenv:Body>
<sch:Input>
<sch:Number1> </sch:Number1>
<sch:Number2> </sch:Number2>
</sch:Input>
</soapenv:Body>
</soapenv:Envelope>"
Can any one help me to solve this or any other suggestiona to do it in a better way.

Re: [resolved] Passing values to tSOAP from tFileInputDelimited

Anonymous — Tue, 20 Mar 2012 07:56:12 GMT

Hi
Have you read the scenario of tSOAP in document ?
You mean you want to know how to generate this soap message?
Regards,
Pedro

Re: [resolved] Passing values to tSOAP from tFileInputDelimited

Anonymous — Tue, 20 Mar 2012 08:16:02 GMT

Thx pedro for ur earliest reply.
I doesn't want to know how to generate the soap message.
I have the soap message with me to communicate with my web service. My soap message takes two or may be more arguments to the web service as input. I like to call the web service for more than one time with different inputs. So i am storing those input arguments in the csv file and like to use tFileInputDelimited to read the inputs from the csv and pass it to the web service.

Re: [resolved] Passing values to tSOAP from tFileInputDelimited

Anonymous — Tue, 20 Mar 2012 08:21:30 GMT

Hi
Maybe you can create job as follow.
tFileInputDelimited--main-->tJavaRow
|
Iterate
|
tSOAP
Set "SOAP message" row1.ColumnName.
But I don't know the detail of this csv file.
Could you send an email to me and attach this csv?
Then I can make it clear.
Regards,
Pedro

Re: [resolved] Passing values to tSOAP from tFileInputDelimited

Anonymous — Tue, 20 Mar 2012 09:09:17 GMT

Once again thx for your earliest reply as well as for solving my problem.