In this article, I’m going to describe a Talend ESB job created for a table lookup in PostgreSQL database over HTTP API.

Below is the table description of the service_details table, which is the table to be looked up. The main purpose of this article is to explain a technique to create HTTP API in Talend ESB that can be used for looking up single table in postgreSQL database. Therefore do not bother to interpret the actual meaning of the data in this table as those are meaningless without other surrounding table structure and application to which this table belongs to.

Part2 of this article will explain the creation of HTTP API in Talend ESB for looking up joined multiple tables in PostgreSQL database.