Email Parser

Extract data from incoming emails and automate your workflow

MENUMENU
DOCUMENTATION TOPICSDOCUMENTATION TOPICS

Handling SQL SELECT result

See also:
Running a SQL statement in a Microsoft SQL server database
Running a SQL statement in a MySQL server database
Running a SQL statement in a ODBC-compatible database
Example – Complete newsletter system with subscription handling and email delivery

 

 

If you use an SQL SELECT sentence in any of the database actions available (MySQL, SQL Server or ODBC) Email Parser will automatically add to the available fields the retrieved data. For example:

 

Table name: parts
part_id name quantity
1 Screwdriver 5cm 234H 432
2 White scotch type 129
3 Black plastic panel 34

 

If you use the following SQL sentence:

SELECT part_id, name, quantity FROM parts;

 

 

The resulting fields are made available to the next actions:

 

With these set of fields you can then use Run a set of actions multiple times to launch actions for each fetched row.