Forum Discussion

omair's avatar
omair
Contributor
5 years ago

SnapLogic Errors: Return custom payload and fail pipeline

Is it possible within SnapLogic to configure a pipeline to fail via a Snap but also to return a custom output back to the user (configured via a Mapper snap, e.g.) I have reviewed the video here: F...
cesar_bolanos's avatar
cesar_bolanos
New Contributor
6 years ago
Copy LinkReport

Unsure if this is the reason. We switched schemas from pg_temp to a regular schema, and it works fine. This is the first time we are trying to use pg_temp and it does not work with snap. Is snap trying to get the table definitions through a different connection? It would not see the table in the case if pg_temp

  • tlikarish's avatar
    tlikarish
    Employee
    3 years ago
    Copy LinkReport

    Could you include some more information regarding your implementation and what you’re trying to do? If I understand your question you are trying to check if there were failed insertions. If so, then the task should respond with an error message and a non-200 status code. If that’s correct then you might look at this kind of pipeline.

    You can use the JSON Generator to set the failed count, which will determine if there is an error. Here are some additional notes for the 4 key snaps required to get this done.

    1. This Router will check for failures and if surpasses the error threshold, routes the document to the bottom output view.
    2. The Set Error mapper snap will set an error message and status code that the task should return in the HTTP response.
    3. The exit snap will surpass the threshold and is used to put the pipeline in a failed state.
    4. The JSON formatter can be used to set the status code on the HTTP response. This is done by setting a special field called status in the binary document header.

    When executed as a triggered task, then you should see this kind of response. I removed some headers from the response to make it easier to read.

    < HTTP/1.1 500 INTERNAL SERVER ERROR
< Date: Wed, 02 Nov 2022 20:33:46 GMT
< Content-Type: application/json; charset=utf-8
< X-SL-StatusCode: 500
< X-Snapi-pipeline-ruuid: XXXX08ba
...
<
[{"status":500,"error":"oh no!"}]

    In the dashboard it’ll show up like this.

    Here is an attached pipeline if you’d like to try it out.

    exit-example_2022_11_02.slp (9.9 KB)