Talend Pass Dynamic values from excel into tSOAP

Anonymous — Thu, 16 Aug 2018 14:08:19 GMT

I am using BD5.6.1 i am using the tSOAP component and if i use the blow flow it works fine. tsoap --> LogRow I can paste the SOAP Request message into SOAP Message section of the tsoap node and it works fine.. But now i want to read the excel file and dynamically pass the value to SOAP Message of tSOAP component how this can be done?

Sample SOAP Message i need to pass.

the parameter is FirstName values are in the file . I need to read these value from excel file and construct the soap message and then send it to tSOAP Component.

I saw on the forum that we can do that

on tSOAP, define the SOAP message to use a dynamic value passed from tFileInputExcel like this: "...."+(String)globalMap.get("row1.First_Name")+"..."

//First_name is one of the column defined on tFileInputExcel, this column read the FirstName value from excel file.

But is not work for me

"<soapenv:Envelope xmlns:soapenv=\"http://schemas.xml\" xmlns:urn=\"urn:HPD_Inc_Create_WS\">
<<urn:HelpDesk_Submit_Service>

<urn:search_id>   </urn:search_id>
<urn:Impact>  </urn:Impact>

</urn:HelpDesk_Submit_Service>
</soapenv:Body>
</soapenv:Envelope>"

tFileInputExcel--main(row1)--tFlowToIterate--iterate--tSOAP--main--tLogRow But it not work
For check i tried to do this tFileInputExcel--main(row1)--tFlowToIterate--iterate-tjava

The column is search_id

Re: Talend Pass Dynamic values from excel into tSOAP

fdenis — Mon, 20 Aug 2018 15:13:16 GMT

you are using a tFlowToIterate. in this component you can define global values you have to use this values not row1.xxxx

Re: Talend Pass Dynamic values from excel into tSOAP

fdenis — Mon, 20 Aug 2018 15:15:30 GMT

if your job is running for one FirstName.
define FirstName in context values.
create an other job who call the first one with this parameter.
good luck

topic Re: Talend Pass Dynamic values from excel into tSOAP in Talend Studio

Talend Pass Dynamic values from excel into tSOAP

Re: Talend Pass Dynamic values from excel into tSOAP

Re: Talend Pass Dynamic values from excel into tSOAP