Email Parser

Extract data from incoming emails and automate your workflow

Documentation topics:

Handling SQL SELECT result

See also
Example – Complete newsletter system with subscription handling and email delivery

 

Select sentences retrieve a set of rows from the database and create multiple sets of fields that contain the corresponding row. For example, given the following database table:

 

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 in Email Parser will be the following:
sql_select_example

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