Talend Pass Dynamic values from excel into tSOAP

Highlighted
Four Stars

Talend Pass Dynamic values from excel into tSOAP

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

Highlighted
Thirteen Stars

Re: Talend Pass Dynamic values from excel into tSOAP

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Highlighted
Thirteen Stars

Re: Talend Pass Dynamic values from excel into tSOAP

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog