I new at talend stuck with a basic issue ,any help would be really appreicated I have a talend esb job that let me query my database via get request
Job Flow:
Trestrequest==>tflowIterate==>Redshift==>txmlmap==>trestresponse
Hi
404 exception means no data found, you may check if any data are found from database and then send different result as response based on the checking result, eg:
Trestrequest==>tflowIterate==>Redshift==tHashOutput--runIf1--tHashInput-->txmlmap==>trestresponse1
--runIf2--tFixedFlowInput-->
trestresponse1
set the condition of runif1 as:
((Integer)globalMap.get("tRedshiftInput_1_NB_LINE"))>0
tHashInput: read the data from memory, check 'clear cache after reading' box.
set the condition of runif2 as:
((Integer)globalMap.get("tRedshiftInput_1_NB_LINE"))==0
tFixedFlowInput:define the return value "{}" if no data are found from database.