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?
Goal: to create a text file and/or poke into a SQL table, using both e-mail body values, AND values that would be returned from a SQL query contained in an "action" step, under 'SQL sentence".
I can use the "For Each Item" Action just fine, to obtain the e-mail body values.

e.g.
E-mail provides 4 values, via "For Each Item" action.
I would use 1 of those fields, to query SQL, and return 4 more values.
I would combine the two sets of data to either write out a text file, and/or write to SQL

make sense?
Rich
Hi there,

I think this is what you need:

https://www.emailparser.com/d/automated-processes-databases/handling-sql-select-result
maybe.. but the values I see them using in "Complete newsletter system with subscription handling and email delivery" , are ones derived from the email.

I'm wondering if , when I query SQL , can I use those results, just like I can use
the values such as: <%From%> ?

R
Yes, the SQL action, when you use the SQL command SELECT and the database returns the resulting rows, makes them as normal Email Parser fields. Each field for each retrieved database column.

But note that you should use SELECT (id, column1, column2...) etc if you just use SELECT * it will not work.

If you have more questions I guess I would need some screenshots to see how you have set up EmailParser.
appreciate the help.
I am selecting fields, not *
Attached some files..
I can see that the SQL query is not returning anything (saveToSQL Action)
You can see that I've hard-coded some values just as place holders("Import Set No" etc)

Rich
ps. if I don;t get to reply before COB today, I'm back in the office Tue.
Thanks much!
Attachments
1.PNG
1.PNG (58.27KiB)Viewed 1150 times
2.PNG
2.PNG (83.74KiB)Viewed 1150 times
3.PNG
3.PNG (89.42KiB)Viewed 1150 times
Can disregard this thread: it appears I do not need to perform the above action after all.

thank you
Rich