evan.yates

Commented on Ability to Include Recipe Function Result Schema i...·Posted inIdeas for Workato

This isn't what you asked, but as an alternative for Functions I quite often follow multiple processing paths to determine return values, but instead of having multiple return points, I declare variables at the start of the recipe, follow whatever path is necessary to set the variables to the appropriate return values from any applicable pathway. Then just return the variables values in the single Return step for the function. It is a bit more complicated , but all the Job report then has to do is show the values of the variables at the one return point.

Commented on Why Does the Workato Microsoft Fabric Connector Re...·Posted inQuestions

evan.yates

Thanks. That seems to work. I used the SDK to remove it. We'll see if it stops me from doing stuff I need to.

Posted in Questions·

evan.yates

Why Does the Workato Microsoft Fabric Connector Require Tenant.ReadWrite.All Scope?

Hi Team. I have a question about the Workato Microsoft Fabric connector. When I try to create a connector to our MS Fabric instance REST API, the Workato connector automatically asks for a scope of Tenant.ReadWrite.All Our security team are asking me, "Whoa, there buddy! Why do you need that high a level of permission?" I don't have an answer for them, but Workato always asks for it and you cannot seem to tell it not to ask for that scope when connecting the connector. The documentation just says it is required but doesn't go into detail as to why it is required. Does anyone know? Is there a way to change the connector config so it doesn't ask? Or will lacking that scope that render the connector inert?

2Comments

Commented on How to Attach Multiple Files from URLs in Outlook...·Posted inQuestions

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

Commented on How to Attach Multiple Files from URLs in Outlook...·Posted inQuestions

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.

Posted in Questions·

evan.yates

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!

5Comments

Posted in Say Hi·

evan.yates

Welcome Evan, the New Zealand Workato Practice Masterchef at AsureQuality

Hi Team. Just joined. I'm Evan, the Workato practice "Masterchef" (😁) at www.asurequality.com in New Zealand. 🇳🇿

2Comments