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.
Need help configuring the program? Have any questions regarding its use?
Is it possible for a single Action to perform multiple SQL action queries? In my application the SELECT statement may return one or more rows (and three columns), and for each row I want to perform four actions in different database tables - one DELETE action, one INSERT action, and two other actions that will be INSERT or UPDATE depending on the result of an IF EXISTS statement. I entered my four statements separated by semi-colons (;) in the left hand SQL Sentence area of Email Parser, the first statement mentioning all three SELECT columns, but in the right hand logging area Email Parser returned "Error. Incorrect syntax near '@parameter3'..", suggesting it did not recognise my script syntax, perhaps the semi-colon. (I checked the script - I copied it with inserted values from the logging area and pasted it into SSMS where it ran successfully.)
Hello Colin,

Yes, this is possible. You have to create one SQL action for each SQL sentence you want to run and chain all of them setting the "Run after" of each item to the prvious one. Some screenshots are attached.

To conditionally run any action you have to use an action of type "Conditional run".

Regarding to the other error, could you contact me via the chat? This way we can share files etc.
Attachments
1.jpg
2.jpg
3.jpg
4.jpg