topic Re: Sending MySQL data to Webservice in Talend Studio

Sending MySQL data to Webservice

karivadhan — Sat, 16 Nov 2024 07:56:49 GMT

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.

Re: Sending MySQL data to Webservice

vapukov — Wed, 18 Jul 2018 10:02:06 GMT

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

Re: Sending MySQL data to Webservice

Anonymous — Thu, 19 Jul 2018 20:14:59 GMT

Hi,

Could you please share the screen shot of the issue?

Warm Regards,

Nikhil Thampi