Sending MySQL data to Webservice

Five Stars

Sending MySQL data to Webservice

Hi All,

          I am trying to send data from MySQL DB to a web service. I am storing the table data in tHashoutput and passing it to tFlowtoIterate. My flow looks like the below

tMySQLInput -> tHashoutput -> tFlowto Iterate = SUB_JOB1

tRestRequest -> tJavaRow -> tRestResponse.

 

On tJavaRow am calling the desired column using globalMap and passing it to the request body with GET attribute. 

The problem is am not receiving the data at the server. Is my approach correct? , is there any better way to do this? 

Any help will be appreciated.


Accepted Solutions
Forteen Stars

Re: Sending MySQL data to Webservice

may be I not fully understand idea, but as I understand You - You want SEND data to webservice

 

but

  • tRestRequest - listen for 3rd party requests
  • tRestResponce - return data back to requester 

if You want SEND data, You need first prepare body, it could be o tJava or tXMLMap or other component

and then tRestClient for send prepared body to webservice

-----------

View solution in original post


All Replies
Forteen Stars

Re: Sending MySQL data to Webservice

may be I not fully understand idea, but as I understand You - You want SEND data to webservice

 

but

  • tRestRequest - listen for 3rd party requests
  • tRestResponce - return data back to requester 

if You want SEND data, You need first prepare body, it could be o tJava or tXMLMap or other component

and then tRestClient for send prepared body to webservice

-----------

View solution in original post

Employee

Re: Sending MySQL data to Webservice

Hi,

 

    Could you please share the screen shot of the issue?

 

Warm Regards,

Nikhil Thampi

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

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now