How to Attach Multiple Files from URLs in Outlook for Workato Emails Using a Corporate Account
Hi All. I have a recipe where a JSON list is submitted to the recipe of the details of a number of files. Each list item consisting of a fileName and an S3 pre-signedURL to the that file's content. I want to turn that list of files into email attachments and send them out. This works beautifully in "Mail for Workato". I just pass it the source list and choose "Use file URL" and it does all the work. Very cool. However, I need to use a corporate email account as the From address for this function (The recipients wonder why they are getting mail from mailer@au.workato.com and not our company domain) So I need to use the Outlook for Workato Send Mail action. That seems to work for everything except the attachments. It won't take the list of URLs and automatically download and attach them like Workato does. It insists on the attachment list having the actual binary content for each file. There is an Attachment URL option in the Outlook mailer, but that only allows for one file to be attached. I need all the files in the list to be attached. Has anyone found a way of dong this? I tried to create a list variable to hold the name and then read in binary content using Get File from URL, but Workato doesn't seem to want to allow a list element to have binary content. Strings, Integers, Numbers, Booleans etc. Yes. BLOBS, No. Any suggestions for workarounds would be appreciated!