TRY CATCH STATEMENT

[vp340]

Hi,
Is there an equivalent of a try catch statement in surrealQL?
I explain my situation. I have a table service (web service) .... each service has a /healt endpoint. I would like to have a field 'status' with type future containing 'OK' or 'KO' based on the result of che http:get() call.
Something like this:

CREATE service SET status = <'future'> {

IF(http::get("https://myendpoint.org/health/status.php", { timeout: 1000 }) = 'OK'){
   RETURN "OK"; 
}ELSE{
    RETURN "KO";
}

}

It works well as long as the service is running... but as the documentation say " If the response does not return a 2XX status code, then the function will fail and return the error.". So if i execute the query to see which of my service is down...(KO) ..if one is really down i get an error and not the result...
It would be nice to try and catch the error ... something like :
CREATE service SET status = <'future'> {

TRY{
   http::get("https://myendpoint.org/health/status.php", { timeout: 1000 });
   RETURN "OK"; 
}CATCH{
    RETURN "KO";
}

}

Please help me find a way!
Thank you very much.

[n-mcnally]

It doesn’t look like theres supports for that currently. One option is to proxy or wrap the API so it always returns a 200 and includes the status in the body. That way you can branch on the response safely:

// success
{ "success": true, "data": { ... } }

// error (still 200)
{ "success": false, "error": "..." }

[vp340]

Thanks for the response, but i would like to have a cleaner solution without having something in the middle.
Maybe if anyone else come up with another solution i Will open an idea to implement the TRY/CATCH statement. In my opinion It could be very usefull
In the meantime thanks again

[LucyEgan]

This has come up a lot with no moment on it, the above workaround of proxying it via something that handles failures, falls apart when that proxy has issues that you again cant handle. Along with the issue that you cant do more than around 50 http::* per second for a sustained duration - #6171