REST API and database communication

[Anonymous]

Hi,

I'm trying to create a REST service using Talend Open Studio which will query the database and return a JSON response through an API request. Following is basic flow I need,

Request received -> Query data from DB -> Convert to JSON -> Send Response

I can't seem to put together the proper components needed for this. It would be great if someone could point me in the right direction.

Thanks!

[DataTeam1 · Accepted solution]

Hi @sahan you need to use these components

[Anonymous]

This worked! Thanks!