email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Post here if you experience problems or get unexpected errors.
Hi there,

is there a way to catch feedback from the SQL process?

When I try to insert a duplicate key the message appears on the screen (Error. Violation of PRIMARY KEY constraint....................) which is as expected. Is there a way to put this message in a variable that can be used in en email?

Thanks!
Hi James

I am afraid there is no way. The only information that you get from a SQL sentence and is available for the next items are:

- if it was successful or not. See the automated processes run conditions:
https://www.emailparser.com/d/automated-processes-basics/run-conditions-automated-process-chaining

- the result from a SQL SELECT sentence:
https://www.emailparser.com/d/automated-processes-databases/handling-sql-select-result

The only workaround for this would be creating a script (C#) that does the SQL operation itself and captures the reply from the server and creates a new field from that.