cancel
Showing results for 
Search instead for 
Did you mean: 

Strange issue - data and email results the same but email doesn't come on execute, only on preview

mmussitsch
New Contributor II

To keep things simple, Email snap is set with Validate & Execute so that it will fire on preview tests as well as execute.
Data is simple, pulls 46 rows from a table, merges the count i.e. 46 and sends the results to an email. Email comes reliability with preview every time. But when execute, it goes all the way thru, same results, same data but no email.

One other REALLY weird thing I found is when pulling a date/timestamp field to build the query and get the 46 rows, if the field is set to pull using Date.parse($LAST_RUN_DATE.Timestamp).toString().substr(0,10), the date returns to “2019-01-01” and results continue fine, preview sends email, but execute does not.

If I adjust this expression to be hard coded i.e. Date.parse(“2019-01-01”).toString().substr(0,10), which also returns “2019-01-01” and results continue fine but preview AND execute send email. What in the world?

Please advise.
Melissa

3 REPLIES 3

mmussitsch
New Contributor II

Going to add some images:

First is results of MM_LAST_RUN_DATE result so you can see.
Second is proof of preview/execute all the way thru.
Third is result of email after execute, even tho email never shows up.
MM_LAST_RUN_DATEPulled
executeresults
executeafteremail

Hi @mmussitsch,

From the output preview I can see that the field “from” is null, which shouldn’t be. Make sure the attribute “From” in the Email Sender snap is always populated.

Thank you for catching this.
I did adjust to add the FROM but unfortunately same results. Preview sends email, Execute does not.
emailfromchange
emailinbox