topic Send different tRestResponse if no rows returned from database in Talend Studio

Send different tRestResponse if no rows returned from database

Anonymous — Sat, 16 Nov 2024 06:45:00 GMT

Hi,

Hopefully this is a straight forward question.

I have a very simply job that take a rest request and queries a database to return a dataset and outputs the data as a rest response. I simply want to check to see if any rows have been returned from the database first and if not send a different rest response. Screen shot attached

I m a beginner here so any and information or examples would be much appreciated.

Thanks

Paul

Re: Send different tRestResponse if no rows returned from database

vapukov — Sat, 26 Jan 2019 11:48:35 GMT

Hi,

you could use RunIf triggers for any number of conditions and prepare different responses depending from condition:

- if count > 0

- if count = 0

for example below, it returns an error if account not found, tJavaFlex - put conditions into variables

Re: Send different tRestResponse if no rows returned from database

Anonymous — Wed, 30 Jan 2019 16:34:22 GMT

Do you have examples of what you put in the tJavaFlex (CheckStatus) components?