Hi im looking for a solution to send emails from alteryx, using moden auth - since microsoft is disabeling basic auth.
https://learn.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basic-authentication-exchange-online
I can find Outlook 365 INPUT with modern auth, but no output. Have I missed something? Kind regards,
Hi @Hamder83
You are correct, at the moment there is only a Connector available to Input from Outlook and not to Output. Unless somebody has built something outside of Alteryx, but I have not seen this yet.
What I would recommend at this stage is to put in the idea to our Product Ideas page - https://community.alteryx.com/t5/Alteryx-Designer-Ideas/idb-p/product-ideas
Kind regards,
Will
You can get the tools here https://community.alteryx.com/t5/Community-Gallery/Outlook-365-Tool/ta-p/898140
Compatible with Alteryx Designer version 2021.4 and later
hi @gabrielvilella This is only an input tool right?
No, it's both input and output.
Hi @gabrielvilella I'm sorry but I don't understand to acheive that.I've installed the package, and I only have outlook 365 INPUT.if I login with that, i have no option to send emails using that connector?Would you mind showing me?
hi @wdavis It has been posted and accepted there.
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Create-Office-365-Email-tool-to-Oauth-2-0-Authentication/idi-p/879431/page/2#comments5 months ago by @VojtechT . I just found that afterwards.But still not connector anywhere?
Three years later and counting, no output tool yet.
The email tool was updated in 2022.3 to use OAuth2.0, so there is no Output Tool required.
Thank you KGT, but I must be missing something, I checked the link you provided and I tried to follow the "OAuth Authentication" for the Email tool, but I can do these two steps, "Select the Use Data Connection Manager (DCM) check box.", and "Select Set Up a Connection" but when it comes to "Select + Connect Credential after you create an email connection." I am just stuck and getting nuts. as if I tried to create an email connection, I am asked for SMTP Server, port and Encryption, which is not something we do with Office365. Also if I filled any name in the SMTP server to get to the next step, I can see the "+ Connect Credential" to click, but after clicking it, the next thing in the connection, the "Authentication Method" has no option for Azure OAuth or Azure OAuth (Alteryx Application), which is the step 4. what am I doing wrong?
Sorry about the length, I tried to include everything...
It will still use SMTP, but the DCM connection set up will use Azure OAuth for authentication. The +Connect Credential would then be populated with your Office 365 credentials. I believe that any email available through POP3 and IMAP4 clients needs SMTP. It is the standard for interacting between email servers. Setup is the same as setting up any other DCM connection and then linking it to credentials, except the SMTP connection info that would have gone in the tool, go in the DCM connection.
Note: an MS email server sending to another MS email server may not use SMTP, as it's all internal to Microsoft, but it will still be there for connecting to external servers.
There is a chance that SMTP is shut down by security protocols in an organisation and so no matter how hard you try, it may always fail to connect. This is organisation by organisation. In that case, you would need an api based tool. I know that when I've come across this, IT wouldn't let me send directly through any method, and so they set up a powerapp, and I called that API to send the bulk emails.
So, how that comes together... there is a chance that Alteryx could build an Outlook 365 output tool, but it's not being worked on currently as far as I know. That ideas page linked above from 3 years ago (adding OAuth2 to the Email tool) was marked implemented 3 years ago and so nothing would have happened to "progress" the sideline issue of companies shutting down access to SMTP in that time. (Hence why I responded, because there is nothing else expected on that idea, and so it will most likely be the same in 7 years).
Even further, If a company has shut down access to SMTP, which is the standard way to interact with a mail server for sending emails, then I'm not sure that a vendor creating another tool as a workaround will be high on the priority list and won't be blocked as well. But that being said, the best way is to post an idea for that, and see if it garners traction.
Thank you very much for the thorough response, much obliged.
I have googled for the smtp that I should use and found it is smtp.office365.com, but when I did continue to create the connection, the only option I had for Azur was Azur AD, and when I preceded I got that my organization blocking Alteryx from authorization, so I can’t use it. I appreciate your help though. Thank you.
So the Email tool with OAUTH, is still using SMTP to send the email, but using OAUTH for the authentication (instead of SMTP legacy/basic authentication). Alteryx doesn't have a graph based email option yet and there doesn't seem to be one on the roadmap. Our company is pursuing building a python graph based email package that we could theoretically embed in a python tool in a macro in our workflows. Note that the instructions in the email documentation says "You can choose to use Azure OAuth or Azure OAuth (Alteryx Application)." but the actual values in the tool are something like AZURE AD and AZURE AD - Private. We chose AZURE AD and it brought up the microsoft authorization dialog. We submitted it and had to have our AZURE admin find it and authorize send.mail for our application. Once that was done, it worked for all of our licensed users.
