Skip to main content
Question

UTF-8 in Gmail Channel

  • July 26, 2023
  • 0 replies
  • 150 views

Forum|alt.badge.img+3
Have a pipeline that sends a gmail.
 
The body is a field from my table.
 
I can read that field utf-8 encoded in quickbase, but when the email is sent it changes the characters to ascii
 
Using the gmail channel, any known workarround?
Thanks


------------------------------
eduardo valdes
------------------------------
This topic has been closed for replies.

  • Quickbase Alumni
  • July 26, 2023

Eduardo - I had a second so I did a quick check. Looks like you need to convert to Base64 when submitting to the api...  so there's probably some testing and research you'll need to do. 

I haven't dealt with this myself - but this is where I'd start....

What I found - 

https://developers.google.com/gmail/api/guides/sending - Mail API

RFC 2822 (https://datatracker.ietf.org/doc/html/rfc2822) 

Found this conversion for js - https://github.com/googleapis/google-api-nodejs-client/pull/1088

 const utf8Subject = `=?utf-8?B?${Buffer.from(subject).toString('base64')}?=`;

doing something similar with jinja/formula field might be possible? dunno. 

aged stackoverflow suggestion - https://stackoverflow.com/questions/61905243/does-gmail-restful-api-support-sending-of-non-ascii-emails-addresses#:~:text=At%20the%20moment%20of%20this,able%20to%20send%20the%20emails.



------------------------------
joe vandervest
------------------------------

Forum|alt.badge.img+6
  • Quickbase Alumni
  • October 11, 2023

My issue is with attachments as well, but it's not that I want to send one. The Gmail channel makes the Attachments URL a required field for some reason. Would love to turn this off, if anyone has experienced it.

In case you never figured out the ASCII issue, using HTML in the body solves this. I use this to send an email to an address from an email field on my table and use markup around the field placeholder in the body.

<p>Dear {{a.requester}},</p>

<p><b>Ticket:</b>{{a.task}}</p>

<p><b>Definition:</b></p>
<p>{{a.definition}}</p>

<p>----------------------------------------------------------</p>

<p><b>Solution:</b></p>
<p>{{a.solution}}</p>

<p>Thank you,</p>



------------------------------
Barry Dolan
------------------------------