Talend Pass Dynamic values from excel into tSOAP

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

Twelve 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!

Twelve 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 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog