TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Sending Tables in Sendgrid Mail via TeamDesk
Hello to you all

With Teamdesk you can setup in no time e-mail alerts including text and attachments, and this is very handy.

If you want to control the email originator (neither Teamdesk nor dbflex) and improve the visual aspect of the mail, you have to use an email service provider such as Sendgrid, which TeamDesk controls efficiently using apis.

I would like to send tables (ex 4 columns / X lines) generated in TeamDesk via Sendgrid and I do not know how to do it.

I am sending many mails using Sendgrid, includes text, attachments, images, ...
I can form a table in CSV format
I do not know how to send the table in a clean format via Sendgrid. I expect I have to convert it into some kind of html, but I have no experience there.

Has any of you experience there ? or any idea on where to dig to find a way ?

Kind regards,

Pierre
ID
1482
Category
Integration/API
Author

Pierre
Date Created
11/17/2021 4:32:01 AM
Date Updated
11/19/2021 6:12:44 AM
Comments
cooper collier  11/17/2021 8:00:02 AM
I have done something similar, but not with sendgrid. The service I have been using is https://www.paubox.com
There API is dirt simple. They encrypt the emails with HIPAA compliance. Plus they are inexpensive.

This it the CallURL body I send to them.
The Teamdesk codes will likely be similar for Sendgrid..

ps... remember if you're sending with the clients email as the from, make sure you have the client update there spf records.


{
"data": {
"message": {
"recipients": [
<%=[TEMP Email Notes To (only 1 address at a time)]%>
],
"headers": {
"subject": "<%[Email Subject]%>",
"from": "me@sample.com",
"reply-to": "me.samle.com"
},
"allowNonTLS": false,
"forceSecureNotification": false,
"content": {
"text/html": "<%[Email Message (use the ? for formatting)]%>"
},
"attachments": [
{"fileName": <%=FileName([Temp Encrypt File 1])%>, "contentType": <%=FileType([Temp Encrypt File 1])%>, "content": <%=[Temp Encrypt File 1]%> }
<%? not IsNull([Temp Encrypt File 2]) %>, {"fileName": <%=FileName([Temp Encrypt File 2])%>, "contentType": <%=FileType([Temp Encrypt File 2])%>, "content": <%=[Temp Encrypt File 2]%> }<%?%>
<%? not IsNull([Temp Encrypt File 3]) %>, {"fileName": <%=FileName([Temp Encrypt File 3])%>, "contentType": <%=FileType([Temp Encrypt File 3])%>, "content": <%=[Temp Encrypt File 3]%> }<%?%>
<%? not IsNull([Temp Encrypt File 4]) %>, {"fileName": <%=FileName([Temp Encrypt File 4])%>, "contentType": <%=FileType([Temp Encrypt File 4])%>, "content": <%=[Temp Encrypt File 4]%> }<%?%>
<%? not IsNull([Temp Encrypt File 5]) %>, {"fileName": <%=FileName([Temp Encrypt File 5])%>, "contentType": <%=FileType([Temp Encrypt File 5])%>, "content": <%=[Temp Encrypt File 5]%> }<%?%>
<%? not IsNull([Temp Encrypt File 6]) %>, {"fileName": <%=FileName([Temp Encrypt File 6])%>, "contentType": <%=FileType([Temp Encrypt File 6])%>, "content": <%=[Temp Encrypt File 6]%> }<%?%>


]
}
}
}
Pierre 11/19/2021 6:12:44 AM
Hello Cooper

Thanks a lot for your answer which seems very actionable

[I have not been able to test it for the last couple of days / some business came in]
[sorry for answering late]

I will write back as soon as I have dealt with it

Pierre
Feedback
Back to Search Results