How to Attach Multiple Files from URLs in Outlook for Workato Emails Using a Corporate Account | Workato Builders Community

Workato Builders Community

How to Attach Multiple Files from URLs in Outlook for Workato Emails Using a Corporate Account | Workato Builders Community

Aaron W.
·
·
Hey Evan! I'm tagging in Bill P. and Chris M. to take a look at this and will share it internally as well. Thanks so much for posting your question in the Community 🙂
👍1
Chris M.
·
·
evan.yates I'm going to "spitball" here in lieu of a confirmed solution. I suspect multiple file attachments is something we may ultimately need to raise with the platform team as a feature request. The first thing that jumps out at me is that it sounds like the downloaded files may be being stored in a format different from the original. In HTTP downloads (outside of Workato) you can specify a content-type in the request, and that defines the way the file is saved. Think text/html, image/jpeg, etc. So I'm wondering if this is an area to seek validation of the source and written file formats actually are. Second, if there's only an option to attach one file, perhaps you could zip the files into a single archive and attach that? The problem with this is that Zip files are seen as an attack vector and often rejected by the receiving email system. Another option might be to include the pre-signed URLs in the email body. This would allow the user to download the files directly, albeit I believe there is an expiration date on the URLs, which would prevent downloading if not done in a reasonable period of time. That creates more problems. Regarding Mail for Workato, I suspect our email address is used because we manage "Email Authentication" (SPF, DKIM, DMARC) to ensure delivery. We don't support custom email address likely due to the complexity of configuring email auth. This actually inspires my final idea. What about creating a custom action using Python and "rolling your own" email delivery agent? You could possibly relay email through your Microsoft org using SMTP Auth on a dedicated acoount, through an SMTP API if they offer one. Although this is fraught with some complexities, it might be possible. Lastly, I think this is worth bringing up with your Customer Success Manager, they might have suggestions I have missed, and it also helps to circulate product feedback. I'm happy to ideate here as well.
evan.yates
·
·
Thanks for the reply, Chris. For most of your points, I have come to the same conclusion as you have in discarding the option.
ZIP files being junked/blocked by email services.
Including the URLs in the email body makes link expiry an issue.
I am hesitant to start developing custom code as the whole idea of adopting Workato was to make our workflow processing as low-code/no-code as possible. I'll try the Success Manager, but that means waiting for the slow gears to grind in their development backlog. I thought I'd ask the community if there was an easy answer first. Much appreciated.
👀1
evan.yates
·
·
Ok. I think I have solved my own issue. What I have done is loop through the list of attachments and turned them into a Workato list variable of file_name and file-contents using the Get file from URL. The trick is that I convert it to base64 text using a Ruby .encode_base64 before adding it to the list variable. Then when it comes time to send the email I specify the binary contents for each attachment as the list item .decode_base64
🙌3
Aaron W.
·
·
Evan. Thank you so much for coming back to share your answer. Future folks with similar issues will be saved by you contributing this.