create http request for each row of a table

[Anonymous]

Hi everybody !

I didn't find any clues for resolving my problem :

I have an input sql table, and for each line of this table, I'm trying to post http request and send the fields of my input sql table in the body of the http request without passing by parameter's file.

Thanks a lot !

[Anonymous · Accepted solution]

We will need to know a bit more about the service before we can really help. However, as a starter you can use the tRestClient. It receives and body and string column. I assume that your service requires its body to be either XML or JSON. If it requires XML, then you need to create an XML document and pass it to the body. If it is JSON, you need to create a JSON String and pass it to the string column. 

Take a look here: https://help.talend.com/reader/hCrOzogIwKfuR3mPf~LydA/~V42EBQClKxKQghNvzHF1g

It actually has an example of a file being read and its data being passed to the tRestClient, which is similar to what you are describing.

[fdenis]

you may try to use tFlowToIterate.

[Anonymous]

Thanks a lot !

Using tRestClient solved my problem