topic Re: [resolved] tRESTResponse returning 404 when no records found in Talend Studio

[resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 10:47:54 GMT

Hi all,
I want to have multiple tRestResponse component for each of my sujobs: if a record exists in my db, I should have a 200 http status code, else, it should be 404.
T tried a little thing (please find attached the screenshots) but I'm always having a 404 http status code.
thank you for your help
Cheers

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 10:54:18 GMT

*I tried to print the value of the ((Boolean)globalMap.get("FilmId")); it's always NULL !!

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 11:07:01 GMT

Basically, the data flow goes to both of the tRESTReponse components whether there is anything to output or not. You need to filter the flow.
Try using a tFilterRow to send the the data to the 200 or 404 output. You can filter on the boolean that you are filtering in the tMap at the moment. See below...

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 13:23:41 GMT

Well, if I filter on the boolean, I get a 500 server error on soap ui:

if I filter on the "film_id" that I want to retrieve, I get always a 404 status code,

and finally, if I remove the row "film_id" in the tfilterRow schema, I get always a 200 status code, even if the record doesn't exist in the db.
Regards

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 14:05:40 GMT

That is because the Boolean you are passing back is actually NULL. Your problem looks like it is centred on the ((Boolean)globalMap.get("FilmId")) . How are you setting this value and in which Job (parent or child)?

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 14:15:24 GMT

actually I thought it's a global variable that automatically stores the state of the excution of a component, for example, if my tRunJob "FilmId" has been executed well, automatically ((Boolean)globalMap.get("FilmId)) would be true. So I haven't set that variable anywhere

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 14:34:55 GMT

The way I've been thinking the whole thing was wrong. The tests that I made, concern "whether the subjob was successfully completed or not", and it works if I see it that way.
However, I don't want to test whether the job was successfull or not, I want to have 404 status error if the record I want to retrieve doesn't exist==> the job will be successfull but I'll have no results
could you help me with this please
Thank you for your time

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 14:56:19 GMT

I'm afraid globalMap variables don't work like that. You either need to set them in Java code or using the tFlowToIterate or tSetGlobVar components.
You can achieve your goal using the tFilterRow solution I suggested earlier. You simply need to set a boolean (or something else) in your tXMLMap to indicate the status of your FilmId query. Then pass that status out with the body Document. If the boolean is true, then filter it to go to the tRESTResponse with code 200, if it is false filter it to go to the tRESTResponse with code 404.
From memory, I believe you are sending the FilmId to the child job to be used in the tMySQLInput query. If you engineer that query so that it will always return a row regardless of whether the film is found or not, you can use the response in your tXMLMap to decide whether it is successful or not. Use that logic to set the boolean. Then, instead of having more than one output from the tXMLMap, have one output with the success/failure flag. Use that column with the tFilterRow component and then just map the filter/reject outputs to the appropriate tRESTResponse.

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 15:54:59 GMT

Okey, I'll work on it.
I built the parent and the subjobs, but I can't access them from the browser; I get an "inaccessible web page", is that normal??!!
that wasn't the case when I had just one job..

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 16:21:05 GMT

That doesn't sound right, but I'm confused by the use of a browser?? If you meant you are having issues opening the Job in the Studio, just restart the Studio. It can be a bit quirky sometimes, especially if it has been left on for a while.

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 16:30:02 GMT

No, I mean that my Rest Service is no longer accessible via google Chrome using : "http://localhost:8184/getActors"
When I execute my service via the studio, I can retrieve my data using the URL above, but when I build them (the parent and the subjobs), all I get is:

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 16:36:45 GMT

even in soap ui I can't access the service!!!

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 16:40:33 GMT

Ah, check that the service is actually running. Sometimes ports an become locked and you either need to change the port, restart your machine or just restart Talend.

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 16:48:11 GMT

Oh, I restarted Karaf and TOS and it's perfectly working. :-)
thank you veery much ^^

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Mon, 08 Jun 2015 17:32:31 GMT

Be careful if you are running the same service in your Karaf and your Studio at the same time. Ideally, you will only have it running in your Studio until you get these issues resolved, then put it in your Karaf to be tested there. Services tend to run slightly differently between the Studio and the Karaf as the Studio does not actually run its own Karaf, it emulates it.

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Tue, 09 Jun 2015 09:26:16 GMT

Thank you for those explanations.
Concerning the error code, I was inspired by your hint; instead of creating and setting a global variable in my tXmlMap, I just created a new variable in the output, and mapped it with the "film_id", I recovered the hole schema in the parent job and filtered on that new variable in the tFilterRow.

I would like to know if it's a proper way to behave.
Cheers

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Tue, 09 Jun 2015 10:15:31 GMT

What you have done looks OK and if it does what you expect, it is behaving properly 🙂

Re: [resolved] tRESTResponse returning 404 when no records found

Anonymous — Tue, 09 Jun 2015 10:29:39 GMT

Problem solved then thank you