Map input schema with webservice output schema in tmap

Highlighted
Five Stars

Map input schema with webservice output schema in tmap

Map input schema with webservice output schema in tmap

I am not sure how to do this, my goal is to read output schema from webservice and to be syncd to other component.

I tried to create a job where it reads data from MySQL database and index data into elasticsearch server.
I have created a custom component to index data from input row to elasticsearch server.

My problem now is I would like to map input fields schema to a pre-defined schema which is retrieved via webservice. tMap is used because the output schema field's name is different from input schema.

For example
tMysqlInput -> tMap - > next component

in tMap, output schema to be defined through webservice and field mapping from input to output can be done here, from there to sync the output schema to next component. is this possible to achieve?

Forteen Stars

Re: Map input schema with webservice output schema in tmap

Hi!

 

yes, it possible, but of course need little more information about Your Webservice response 

 

normally web service return JSON or XML data and You use tXMLMap for map to destination structure

 

but it also could return data as string (same with JSON or XML inside) in this case You need use tJSONParse or tXMLParse components

-----------

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