Engine Works

Under the hood of Alteryx: tips, tricks and how-tos.
rpaugh
11 - Bolide

How does one automate that which cannot be automated?

 

We are in an information age.  An age where someone can monitor the security of their home and unlock their care from a mobile device; start streaming a movie at home, move to an iPad, and finish on a plane; and even blend, cleanse, and predict data with little or no data science knowledge.  And yet many, if not all of us, at some point have tried to gain access to data within our own organizations only to be met with the solution of “we can email you an Excel file”.  Really?!?  I can put money into my Starbucks account via my phone, and have Starbucks scan and recognize the payment, deduct the cost from my account and give me my bonus stars for the transaction, but the only solution you have to give me data is to email it to me?  Now is a good time to tell you something important about myself – I’m lazy.  I loathe manual, tedious, repetitive tasks.  I often joke with my coworkers that I’m going to automate everything I do so I can sit and watch YouTube all day.  In fact, were I to successfully automate myself out of a job I would consider that the single greatest accomplishment of my career.  As you can probably imagine, I was not willing to manually download and process Excel files each week.  Fortunately, I come from a software development background and was able to write code to extract attachments from Outlook emails and baked that into an SSIS package that ran weekly. 

 

Outlook Input toolOutlook Input toolFast forward a couple of years to Inspire 2017.  I was having breakfast before the opening keynote and I heard an Alteryx employee talking about using Alteryx to blend data from a file she receives from another department.  I had a hunch and asked her how she gets those files.  I stifled a literal “LOL” moment when she said she receives them via email.  I told her I had some code that might help her get to a fully automated solution.  Later in the conference I attended a session on using the Alteryx API and SDK.  I paid particularly close attention to the SDK portion because at the time I had no idea creating custom tools was even an option.  I know this is going to sound lame and cliché, but at that moment I was truly inspired to jump into code and build my own custom input tool to pull attachments out of Outlook emails.  I know, I know, too corny.  Moving on.  As a fantastic conference was coming to a close I just happened to spot one of the engineers, @JPKa,  who hosted the session on using the API and SDK at the closing reception.  I told him my idea and he pointed me in the right direction to get started.  Two weeks of personal time later I had  a solid version 1  of the tool and I shared it with my friends at Alteryx.

 

 

 

Working with the SDK

 

Outlook Input Tool ConfigurationOutlook Input Tool ConfigurationEverything I needed to get started was already installed with Alteryx Designer. I used a combination of reading through and interpreting the sample and the getting started documentation. Honestly, my first impression was confusion.  The sample project involves using an XML file containing Alteryx tool XML config information as an input to set the tool XML config information.  When it came to interpreting the code to understand how it was linking the xml config information to the input data I was often confused as to whether the xml components in question were part of the Alteryx configuration or the input tool that was providing the configuration.  Simply put, it was setting configuration from configuration. If anyone from Alteryx Product Management is reading this,  a better sample might be to pull dummy customer data from a .csv file and send it to an output stream.

 

My biggest obstacle was interpreting the sample code - figuring out how to separate the xml config as input from the xml config that was reading the input.  It makes perfect sense now, but when I was trying to understand the custom tool architecture and input file interpretation simultaneously for the first time I had some trouble.

 

 

Once I had a working tool I went back and forth with the folks at Alteryx and there were some limitations there with getting them the install and sharing attachments. I discovered I could wrap the install into a yxzp file and include instructions and a help file. JP was very helpful with identifying some of the nuances of working with the SDK and offered some suggestions on improving the tool. I needed to incorporate the "UpdateOnly" parameter because the C# code was executing every time a new tool was added to the canvas. I didn't know that the Alteryx Engine had a special feature where it runs the workflow (with no actual records other than metadata) every time a new tool is added.  

 

He also suggested I add some date filtering capability to the tool, allowing people to avoid downloading their entire inbox if they select “Inbox”.  For this I added a configuration element for the user to input a query string and included a link to the documentation to build the query.

 

 

 

Using the Outlook Input Tool

 

You may be tempted to point this sucker to your Inbox right out of the gate, and I don't know what your Inbox looks like, but if it looks anything like some of our testers, I'd advise against that. Play with your drafts folder or deleted items first.

 

You may find copying the search syntax from Outlook into the Query String helpful:

 

copy the query string from outlookcopy the query string from outlook

 

As for me, this is how I've been using the tool. In this example I filter out a specific Excel file and send it through a Dynamic Input tool to see the results. I'll leave it up to you to discover new and interesting ways to consume the files that you no longer have to manually fish out of your inboxes.

 

OutlookInputToolSample.png

 

 

giphy-downsized (2).gifBut wait, there’s more!  Act now and as a bonus you get the added message stream allowing you to perform any number of analytics on your email messages.  And if that isn’t enough, join the two streams together on Message ID for maximum analytical potential!!

 

 

 

 

What's included in the package

 

You'll find an Alteryx *.yxzp file attached to this post. When you open it in Alteryx Designer, you will see installation instructions:

 

Outlook Tools Install instructions.png

 

and a help file

 

Outlook Tools Install help file.png

 

The workflow is a single RunCommand tool that will install the Outlook Input tool. You can find my source code on Git Hub.

 

I hope you find the Outlook Input tool useful. This has been a fun and exciting project and I can't wait to see what creative ways the community finds to use this tool. Use the comments below to let me know your experience working with the tool.

 

UPDATE 8/1/2017:

A new version is available on the gallery: https://gallery.alteryx.com/#!app/Outlook-Tools-Install/597b35c2f499c716ec34a782.

 

Changes:

  • Implemented paging to prevent timeouts through the Exchange Web Services when working with large inboxes and complex filters.  Note: you still may need to adjust throttling settings on your server: https://msdn.microsoft.com/en-us/library/office/jj945066(v=exchg.150).aspx.
  • Updated the installer to remove previously installed versions of the tools so it's not cluttering up your programs list.
Comments
NPham00
8 - Asteroid

@rpaugh Thanks for your suggestion, i've tried the tool, i was able to connect to my Outlook Account via  OAuth 2.0. But i've got the error 503: "Service unavailable".
I just have all the standard settings, see below:

NPham00_0-1619525247933.pngNPham00_1-1619525277476.png

 

rpaugh
11 - Bolide

@NPham00 Have you tried entering a folder id? Try "Inbox" and see fi you get the same error.

EvaWick
5 - Atom

Can this only be used to access on-premise Outlook?

NPham00
8 - Asteroid

@rpaugh i tried with "Inbox" and "Draft" (in english and german, since i have german version of Outlook 365) but the same error popped up. 

JMart2135
8 - Asteroid

@rpaugh I downloaded the tool from the gallery and got it installed. I seem to be getting a similar error to a previous post.

 

"OutlookInputTool (1) There are no fields. Make sure your container element is set properly.¶ApplicationException¶ at OutlookTools.OutlookInputToolEngine.PI_PushAllRecords(Int64 nRecordLimit) ¶ at SRC.Alteryx.GenericNetPluginInterface.PI_PushAllRecords(GenericNetPluginInterface* , Int64 nRecordLimit)"

 

I have tried my username with and without the domain as well as tried my actual email address itself. Server version is 2016. Any ideas/tips? 

 

Thank you!

OutlookToolConfig.png

rpaugh
11 - Bolide

@EvaWick You can technically use this for Office365 if you know the endpoint, though Office365 is getting further and further away from the supported version of EWS that this tool uses. If you are using Office365, I highly recommend this version of the tool. Technically it says "beta" but that's only because so many people still use the current version that I didn't want to overwrite it with the Office365 one. Many people are using it and it is really production ready.

 

@NPham00 I'll have to think on this. This one is definitely a challenge :).

 

@JMart2135 It looks like you haven't selected any fields to output.

rpaugh
11 - Bolide

@NPham00 Are there any security settings that could be affecting this? I know many weird issues have arisen due to company IT departments tweaking security/access settings. Given that your test folder worked, it may be that local locations are accessible, but server locations are not.

JMart2135
8 - Asteroid

@rpaugh So i selected a few different fields to bring in but getting other errors now. i know in the past when i have had to log into my email accnt from another software i have had to use my domain/username instead of email for it to work. However, if i try that i get an immediate error that the email address is formed incorrectly. Below are screenshots of the errors i got when i did enter my actual email, with and without the server manually entered.

 

OutlookToolConfig2.png

 

OutlookToolConfig3.png

 

 

 

EvaWick
5 - Atom

@rpaugh I downloaded the beta version and I'm receiving the following window.  When I click 'OK', I do not have the tool available.

 

EvaWick_0-1620328232276.png

 

rpaugh
11 - Bolide

@JMart2135 The issue is probably with the formatting of the username. When using domain addresses you need to use the format <username>@<region/sub-domain>.<domain>.com. For example, john.doe@acme.com might become something like jdoe@na.acme.com, or just jdoe@acme.com if there is no region or sub-domain.

 

@EvaWick The Office365 version of the tool utilizes Alteryx's native tool installer so you don't need to download the workflow itself from the gallery. Click "Run" until you get to the final report page. Once there you will see a link to download the .yxi file. Run the .yxi file to trigger the installation process in Alteryx. Then the tool will appear.

JMart2135
8 - Asteroid

@rpaugh Thanks, that cleared that error. But now getting the following error.

 

"Error: OutlookInputTool (1): The request failed. The remote server returned an error: (401) Unauthorized.
ServiceRequestException
at Microsoft.Exchange.WebServices.Data.ServiceRequestBase.GetEwsHttpWebResponse(IEwsHttpWebRequest request)
at Microsoft.Exchange.WebServices.Data.ServiceRequestBase.ValidateAndEmitRequest(IEwsHttpWebRequest& request)
at Microsoft.Exchange.WebServices.Data.MultiResponseServiceRequest`1.Execute()
at Microsoft.Exchange.WebServices.Data.ExchangeService.FindItems(FolderId parentFolderId, String queryString, ViewBase view)
at OutlookTools.OutlookEmail.GetItemsFromFolder(ExchangeService service, Object folder, Boolean isRoot)
at OutlookTools.OutlookEmail.GetItems(Int64 recordLimit)
at OutlookTools.OutlookInputToolEngine.PI_PushAllRecords(Int64 nRecordLimit)
at SRC.Alteryx.GenericNetPluginInterface.PI_PushAllRecords(GenericNetPluginInterface* , Int64 nRecordLimit)"

 

Is there a default port selected within the tool itself? Something in the settings i guess is still blocking the connection because i know my pw is correct.

rpaugh
11 - Bolide

@JMart2135 That definitely looks like a username error (if you say your password is correct). You may have to work with your IT team to ensure you have the correct format for your username using the domain name format. Another option is to use the Office365 version of the tool, which uses OAuth and simplifies authentication.

VahidGoli
8 - Asteroid

Hi,

I am using this great tool, but the only problem is that it downloads all the files from that subject. Is there any way that I can filter based on the date that email received?

 

Thanks for your guidance.

FJ_Shafeek
7 - Meteor

hey @VahidGoli - you can use the QueryString documentation to filter the results you are downloading. The date-specific stuff is as follows:

 

FJ_Shafeek_0-1623255716178.png

 

rpaugh
11 - Bolide

@VahidGoli Which version of the tool are you using (legacy or Office365)?

VahidGoli
8 - Asteroid

Hi @rpaugh@FJ_Shafeek 

 

My email account is office365, and the tool that I am using is attached (with my current setup).

 

@FJ_Shafeek, I used the "Received:today", it seems it can detect them, but nothing is not downloaded to the destination.

 

Would you please guide me? 

OutlookTool-setup.PNG

rpaugh
11 - Bolide

@VahidGoli That configuration gets you no results?

VahidGoli
8 - Asteroid

@rpaugh No results. If I remove the query, it downloads all the attachments from day 1.

 

Do you have any idea why the query doesn't work?

 

 

rpaugh
11 - Bolide

@VahidGoli It could be a timing issue between your computer and your server. I've seen this before where the Exchange server is located in a different time zone than the user's local computer, causing the "today" and "yesterday" functions to not work as expected. If you change the Received filter to include a range of a couple of days does the correct email show up?

VahidGoli
8 - Asteroid

@rpaugh, you were right mate, it was fixed when I chose a range. Thanks a lot.

alberto_herni
9 - Comet

Hi @rpaugh,

 

In my company we are using the new version of the Oulook Input tool (office 365). We are trying to log into the tool with a system account (instead of my user) that has access to a shared mailbox, but the tool is not allowing us, it's always login me as my user, not the system account.

 

I guess that this could be happening because the tool is using the AD user logged in the machine?? Do you know any workaround to log in with a system account instead of my user account?

 

Thanks,

Alberto HM 

rpaugh
11 - Bolide

@alberto_herni If you have the credentials for the system account then use those in the OAuth login screen. That will allow the tool to run as that user.

A_Ribeiro
6 - Meteoroid

Hi @rpaugh! First, a huge thank you! I'm a happy long time user of the previous version, which was flawless for 2 years until our company moved to O365.

 

I'm now trying to move our flows to the new version Outlook Input (Office365) beta and I'm facing a: Outlook Input (Office365) (1) 400: Bad Request, whenever I input any query string.

If I run the tool without any filter from day 1 it works fine. I have tried several strings, encapsulating in quotes, double quotes. None work.

 

I went through this post and could not find other user with the same issue, so, could this be related to some setting on our servers?

 

Thank you once again and keep up the great work!

rpaugh
11 - Bolide

@A_Ribeiro I'm glad it's been working so well for you in the past. For the new tool Microsoft changed how Exchange Services are accessed which also means a change to how query strings are used. See this help document for an explanation of the new filter logic and examples. If you're still having trouble, send me examples of what you're trying to do and I'll see if I can figure out what's going on.

A_Ribeiro
6 - Meteoroid

@rpaugh Thanks a million for the instructions sir, string "ReceivedDateTime ge 2021-01-01 and receivedDateTime lt 2021-05-01" worked like a charm.

 

Best regards,

shahvinit
5 - Atom

Hi Rick Paugh,

 

I am trying to use this Outlook Input tool (2.0.0) with Alteryx version 2021.2. Is this compatible? @rpaugh

Outlook Input tool (2.0.0) works good with Alteryx version 2019.4.

Request to please help.

 

I get the below error in Alteryx version 2021.2.

 
Error: OutlookInputTool (1): The user name or password is incorrect.
 
IOException
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode)
at OutlookTools.OutlookEmail.GetAttachmentsFromItem(Item item)
at OutlookTools.OutlookEmail.GetItemsFromFolder(ExchangeService service, Object folder, Boolean isRoot)
at OutlookTools.OutlookEmail.GetItems(Int64 recordLimit)
at OutlookTools.OutlookInputToolEngine.PI_PushAllRecords(Int64 nRecordLimit)
at SRC.Alteryx.GenericNetPluginInterface.PI_PushAllRecords(GenericNetPluginInterface* , Int64 nRecordLimit)
 
Thanks,
Vinit Shah

 

 

rpaugh
11 - Bolide

@shahvinit That's interesting. Alteryx version shouldn't impact authenticating with EWS. Has something changed with your mail server? I know many IT departments have been increasing/changing security settings in the last few years and that has an impact. Also, are you using on-premise or Office365?

shahvinit
5 - Atom

It working now , Thanks for your help

tshepomatlhwane
5 - Atom

@rpaugh good day, the new query string parameters doesn't seem to work on my end. my old query string was as; from:'someone@***.com'  AND subject:'something nice' AND received:today. 

Any assistance?

rpaugh
11 - Bolide

@tshepomatlhwane you would do the following:

from/emailAddress/address eq 'someone@example.com' and subject eq 'something nice' and receiveddatetime ge '2021-08-16'

 

You'll have to dynamically calculate date and use that. For some reason the new Graph API Microsoft is using doesn't allow parameters such as "today" and "last month" in the filtering clause. 

FJ_Shafeek
7 - Meteor

Hi @rpaugh 

I've been the using the tool for the last several months without any issues, but then this morning I ran into this error. I contacted my IT team and they told me that since we are on Exchange 2016, that may be causing the error. However, I don't see 2016 as an option in the dropdown so I uninstalled the tool and reinstalled it to make sure I have the latest version, but I'm still not seeing it. Do you have any suggestions?

 

FJ_Shafeek_0-1629483412390.png

 

rpaugh
11 - Bolide

@FJ_Shafeek That version selector just ensures that you don't attempt to pick a later version than you have, since later versions often add fields/functionality. Selecting a lower version than you are actually running should not be an issue. Based on the error message I see there, the problem is likely that your Exchange 2016 server is demanding a TLS 1.2 connection, but the tool is not using TLS 1.2. I haven't figured out yet how to force this version of the tool to utilize TLS 1.2, so I see a handful of possible options at the moment:

  1. Wait until I'm able to figure out how to get the tool to use TLS 1.2 (if it's even possible).
  2. Try using the js version of the same tool which does use TLS 1.2 (this can be installed alongside your existing tool). There are some subtle differences, but overall it still functions the same and still uses Exchange Web Services so you can continue to use it with an on-premise server.
  3. Try using the Office365 version of the tool. This is the ideal option, but will only work if you are using a cloud or hybrid Exchange environment.
  4. Get your IT to relax the security requirement. I highly doubt they're going to do this, but wanted to throw it out there since it's technically a possibility.
rpaugh
11 - Bolide

@FJ_Shafeek Can you verify what version of the .NET framework you have installed on the machine running the tool?

rpaugh
11 - Bolide

@FJ_Shafeek I think I've got it. I updated the dependent .NET version and found a way to force the connection to use TLS 1.2. Take a loot at this version and let me know if it works for you. If it does I'll see about getting the tool version in the gallery updated as well.

JessieC
Alteryx
Alteryx

@rpaugh - I'm on the O365 version - 

 

When I click on OAuth Login - it loads to allow me to enter my email - 

JessieC_3-1631318268386.png

And then when it gets to the password page - 

JessieC_4-1631318324774.png

After I click sign-in the pop-up is blank - 

JessieC_1-1631318116217.png

 

I run the workflow, and get this error - 

JessieC_0-1631318028137.png

Error: Outlook Input (Office365) (1): Failed to receive initialization from JavaScript plugin, timeout "20000ms"

 

When I click sign out, it shows my account to allow me to select sign out - 

JessieC_2-1631318223572.png

 

Any ideas?

rjsebold
6 - Meteoroid

@JessieC Are you on the latest version of Alteryx designer that was released last week (2021.3.2)? I also received this error message after upgrading, but once I downgraded to the previous designer version (2021.3.1), the tool worked as expected. Perhaps this is a bug with the latest release or the tool needs to be updated for newer designer versions.

rpaugh
11 - Bolide

@JessieC @rjsebold It could be a bug due to the following update:

 

2021-09-13_13-56-51.png

 

I am unfortunately not on 2021.3.2 so I can't test this myself.

JessieC
Alteryx
Alteryx

@rjsebold @rpaugh - Yes, I am on 2021.3.2 on my new laptop. I tested on my old laptop with 2021.2.1 and it worked. 

rpaugh
11 - Bolide

@JessieC I raised a case with Alteryx support. I'll let you know what happens.

rpaugh
11 - Bolide

@JessieC @rjsebold I received the following information from Alteryx support:

 

"We are aware of an issue regarding authentication page not displaying (or being blank) for Alteryx Designer 2021.3.2 for several connectors including Outlook.
At the moment the only viable workaround is to downgrade to Alteryx Designer 2021.3.1 while we work on a fix.
I do not have timeline to provide but we have identified the root cause and should be able to prioritize accordingly.
Apologies for the inconvenient.

An update will be added to our release page under the defect TPM-245."

mst3k
11 - Bolide

UPDATE: i did get it to finally work, my windows installer was just thinking for a very long time about the folder browse. i waited 15 minutes and it launched. thanks for the awesome tool!

------------------------------------------------------

 

When I try to change the install path, it never launches the folder browse and locks up. So I tried just using the regular install path, and then cutting the Outlook and Settings folders out and moving them to the correct folder where Alteryx is stored, but that didn't seem to work... Any ideas what I could do?

 

Clicking the Change button here just leaves it spinning

 

mst3k_0-1632946843670.png

 

VahidGoli
8 - Asteroid

Hi,

I have been using this amazing tool since 6 months ago with no issue, but just in the last two days, I am randomly receiving the following error:

 

00:00:00.171 - ToolId 2: 9223372036854775807

00:00:11.622 - Error - ToolId 2: The request failed. The underlying connection was closed: An unexpected error occurred on a send.

ServiceRequestException

   at Microsoft.Exchange.WebServices.Data.ServiceRequestBase.GetEwsHttpWebResponse(IEwsHttpWebRequest request)

   at Microsoft.Exchange.WebServices.Data.ServiceRequestBase.ValidateAndEmitRequest(IEwsHttpWebRequest& request)

   at Microsoft.Exchange.WebServices.Data.MultiResponseServiceRequest`1.Execute()

   at Microsoft.Exchange.WebServices.Data.ExchangeService.FindItems(FolderId parentFolderId, String queryString, ViewBase view)

   at OutlookTools.OutlookEmail.GetItemsFromFolder(ExchangeService service, Object folder, Boolean isRoot)

   at OutlookTools.OutlookEmail.GetItems(Int64 recordLimit)

   at OutlookTools.OutlookInputToolEngine.PI_PushAllRecords(Int64 nRecordLimit)

   at SRC.Alteryx.GenericNetPluginInterface.PI_PushAllRecords(GenericNetPluginInterface* , Int64 nRecordLimit) Finished in 00:00:11.656 with 1 error

 

 

Would you please help and guide how I can rectify this issue?

Kind regards,

Vahid

rpaugh
11 - Bolide

@VahidGoli This could be due to a security change. Another user above had a similar issue. I do have a beta update for this here. Try installing that version and let me know if it resolve your issue. It upgrades the underlying tool framework and utilizes TLS 1.2, which is the accepted security standard right now. If I get confirmation that this update works I'll update the production version of the tool in the public gallery.

VahidGoli
8 - Asteroid

@rpaugh , thanks for your help. I did it last Wednesday, and it has been working with no issue so far. Thanks.

 

RMojsiak
8 - Asteroid

Can I download attachments from the Outlook365 tool? I can't seem to find a way. The other tool gives me an error so I can't connect.

Error: OutlookInputTool (1): The request failed. The remote server returned an error: (401) Unauthorized.
ServiceRequestException
at Microsoft.Exchange.WebServices.Data.ServiceRequestBase.GetEwsHttpWebResponse(IEwsHttpWebRequest request)
at Microsoft.Exchange.WebServices.Data.ServiceRequestBase.ValidateAndEmitRequest(IEwsHttpWebRequest& request)
at Microsoft.Exchange.WebServices.Data.MultiResponseServiceRequest`1.Execute()
at Microsoft.Exchange.WebServices.Data.ExchangeService.FindItems(FolderId parentFolderId, String queryString, ViewBase view)
at OutlookTools.OutlookEmail.GetItemsFromFolder(ExchangeService service, Object folder, Boolean isRoot)
at OutlookTools.OutlookEmail.GetItems(Int64 recordLimit)
at OutlookTools.OutlookInputToolEngine.PI_PushAllRecords(Int64 nRecordLimit)
at SRC.Alteryx.GenericNetPluginInterface.PI_PushAllRecords(GenericNetPluginInterface* , Int64 nRecordLimit)

ADT781
5 - Atom

Hi @rpaugh 

 

I've been using the on-premise tool for a while now, thanks very much!

 

My company have recently migrated to Office365, so I'm looking into switching over to the 365 version.

 

Is it possible to automate via the Gallery with the new 365 version of the tool?

 

Many thanks.

rpaugh
11 - Bolide

@RMojsiak Yes, you can download attachments, they just come into the output flow as byte strings. All you need to do is convert the ContentBytes field to a blob and use a blob output tool to save it as the desired file:

 

Alteryx Office365 Attachment Output Example.png

 

@ADT781 As far as I know you can schedule the Office365 version of the tool via gallery. I've not heard otherwise.

chrisrayner
8 - Asteroid

Hi @rpaugh I have been using the original tool for quite some time, but earlier this week my company moved the mailbox I use it on to a O365.

I have downloaded the O365 version of your tool, but it looks as though there are some data fields that I use heavily in my workflow that do not appear to be extracted in the O365 version.  Is it that I have an old version of the tool, and if not, is there any plan to include these fields in a future release?

The fields in question are:
DisplayTo

DisplayCC

ConversationTopic

As ever, above all else, thanks so much for this fantastic tool!

Regards

Chris

RMojsiak
8 - Asteroid

Thank you so much @rpaugh

It worked!

rpaugh
11 - Bolide

@chrisrayner ToRecipients in the new tool is a JSON field containing both Name and Email address. If you use the standard Alteryx JSON Parse tool you should be able to get the same information. Be aware however that if there are multiple "To" addresses then this will result in additional rows after the JSON Parse. Let me know if that works for you. As for the ConversationTopic, I'll have to look into that.

 

Update: it looks like Microsoft has moved ConversationTopic to its own object in their new API. The relationship to this object is via the ConversationId field available in the email message. I will have to research this to determine the best, most efficient way to incorporate this new conversation object information into the email result.