Sending MySQL data to Webservice

[karivadhan]

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.

[vapukov · Accepted solution]

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

[Anonymous]

Hi,

    Could you please share the screen shot of the issue?

Warm Regards,

Nikhil Thampi