Has anyone been able to figure out if an e-mail sent via HTML templates/REST API gets logged anywhere in the database? As we are testing, it's really frustrating when an e-mail doesn't come through that I can't figure out if it was actually sent and just caught in a quarantine folder or if it failed to send.
Thanks for any insights!
Madeline
Do they not get logged on Connections>Contact Log?
Hi Madeline,
You might find what you're looking for in T_TEMPLATE_QUEUE. Hope that helps!
-Sheela
Another approach that might help you would be to configure a BCC for your TR_EMAIL_PROFILE. We are on Google G Suite, so we created a Group address to capture all of our outgoing email, so we can refer back to it to answer these kinds of questions. An equivalent approach should be possible in other email environments.
Michele Keutsch said:Do they not get logged on Connections>Contact Log?
Yep; according to support the REST auths should be logged there starting w 15.1.
Another option is msdb..sysmail_sentitems, and msdb..sysmail_event_log.
Sheela - Once again, you're my hero!
Chris Jensen Since we're still on v15.0.2 I'm assuming I need to add a query to the LP that AP_CONTACT_LOG pulls from if I want to have REST e-mails sent reflected in the Contact Log prior to upgrade. Is that an accurate assumption?
Madeline Dummerth (Past Member) said:I'm assuming I need to add a query to the LP that AP_CONTACT_LOG
I've never modified LP_CONTACT_LOG myself, but, yes, looks like that would do what you want!
Hi Sheela,
So happy I stumbled upon this as we're now having this same issue! Do you happen to know what the values in the status column mean in this table? I see that some of the rows have a value of -1 and some have 1, but I can't seem to find what those values correspond to.
Thanks!-Sara
I'm reviving a very old thread to also ask this question - has anyone ever gotten info on what a value of -1 in the status column of T_TEMPLATE_QUEUE means? We are working with a patron who says password-reset emails are not reaching them despite what our logs say, and I am hoping to rule out the possibility that T_TEMPLATE_QUEUE tracks any sort of 'bounceback' or 'undeliverable' events that could be secretly affecting an email send behind the scenes. Thanks!
Hi Evan -
-1 in that table means that the email did not successfully send (negative = bad). 1 means that the send was successful (positive = good).
Thanks,
Patrick