topic Re: How to pass extra columns through webservice along with required columns to invoke webservice method in Talend Studio

How to pass extra columns through webservice along with required columns to invoke webservice method

Anonymous — Fri, 24 Apr 2020 16:45:56 GMT

Hi ,

I have a requirement like where i have 4 key columns and 3 more columns in a table A.

i need to send 3 columns data to web service and update the table with status (success fully sent web service or not based on the response from web service).

update table A set status='y' where four key columns.

as i started coding i come to know i cannot pass through additional columns to web service other than required 3 columns. how to capture the response and update the status.

how do i know the response is for a particular record?

Re: How to pass extra columns through webservice along with required columns to invoke webservice method

manodwhb — Mon, 27 Apr 2020 03:36:46 GMT

How are you passing the existing 3 columns? Check the below link you can try to pass with fixedflowinput.
https://help.talend.com/reader/c5cLvVomBhha3Yu7aMiCeg/eiZ0NStNK2HsYV86F_bFlA

Re: How to pass extra columns through webservice along with required columns to invoke webservice method

Anonymous — Wed, 06 May 2020 10:48:30 GMT

Here Iam able to pass only the columns which are input to webservice(3 columns) and in the output i am getting only one column (XML doc from webservice output) . I am not able to pass all other columns to the output. I need to store the XML along with other key columns but i am not able to carry forward those key fields. Is there any other way to achieve this

Re: How to pass extra columns through webservice along with required columns to invoke webservice method

manodwhb — Wed, 06 May 2020 11:30:04 GMT

@rrcr410, if possible can your job design.