Email Parser

Extract data from incoming emails and automate your workflow


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:

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