Sending MySQL data to Webservice

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

-----------

All Replies
Thirteen 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

-----------
Employee

Re: Sending MySQL data to Webservice

Hi,

 

    Could you please share the screen shot of the issue?

 

Warm Regards,

Nikhil Thampi