topic Re: Passing Source Column through twebserviceinput to Target Table in Talend Studio

Passing Source Column through twebserviceinput to Target Table

AAA999 — Thu, 17 Jan 2019 20:05:36 GMT

Gurus,

How to pass the source column using twebserviceinput to the target table.

Flow

table--->tflowiterate---->twebserviceinput--------->filedelimited

Table has multiple columns. verifying currency by country using twebserviceinput. I tried joining the output from twebserviceinput with the source column in tmap but not working.

can someone provide me a solution?

Thanks

Re: Passing Source Column through twebserviceinput to Target Table

vapukov — Thu, 17 Jan 2019 22:03:35 GMT

Hi,

not very clean described your design

but normally it is:

table -> tFlowToIterate - this part read row by row and store all row in globalMap, with names "rowxxx.columnname", where rowxxx - name under line between table and tFlowToIterate
tFlowToIterate -> tFixedFlowInput. in tFixedFlowInput you define schema - what you want to path forward. For example Curency, and in value put (String)globalMap.get("rowxxx.columnname") (String - just an example)
connect tFixedFlowInput ->tMap -> twebServiceInput, in tMap you prepare structure accepted by your webservice - XML or JSON or just a text in proper column

Re: Passing Source Column through twebserviceinput to Target Table

AAA999 — Thu, 17 Jan 2019 22:29:25 GMT

Thanks, for the quick reply. Looks like you can not connect tmap to twebserviceinput but can connect to twebservice. is there a way you can join the source columns to the output column of the twebserviceinput component?

Source has 4 input column (f1,f2,f3,f4) .Only 2 required columns are passed to tflowiterate and the output column from tflowiterate is then passed to twebserviceinput.

f1----->tflowiterate

f2---> tflowiterate

output column from tflowiterate passed to twebserviceinput. Output column from twebserviceinput needs to be joined back to column f3 and f4. before loading the target table.

Re: Passing Source Column through twebserviceinput to Target Table

vapukov — Thu, 17 Jan 2019 23:00:13 GMT

I can not undestand this, could you publish pictures of your design and show - what and what you try to connect (and why? 🙂 )

Re: Passing Source Column through twebserviceinput to Target Table

AAA999 — Fri, 18 Jan 2019 15:13:56 GMT

How to pull the additional three cols region, id ,desc from source to the tgt?

Re: Passing Source Column through twebserviceinput to Target Table

Anonymous — Fri, 24 Apr 2020 16:34:22 GMT

I also have similar requirement. Did you get answer for your question

Re: Passing Source Column through twebserviceinput to Target Table

AAA999 — Sat, 25 Apr 2020 00:14:10 GMT

Hi,

I have attached the design and the values passed in each component. In twebservice component in the output schema add the source column you want to pass to the target. In tFixedflow pass the global variables. under the Value press ctrl space and slect the global variable with the column name you want to pass to the twebservice input.

In tJavaRow please note the last column is pulled from row2 link. After tJavarow pass you pass the value to tgt.

Hope this is what you were looking for.

tjavarowcomponent.JPG
twebservicecomponent.JPG
tfixedflowinput.JPG
twebserviceflow.JPG

Re: Passing Source Column through twebserviceinput to Target Table

Anonymous — Sun, 26 Apr 2020 15:31:52 GMT

Thanks for reply and solution. will try to implement in this way.