Overview
Need to poll emails from your Exchange server? This smart service can be used in a poller process and extract the data from the Microsoft Exchange server. Messages are stored in the Appian Document System, as well as the attachments. Meta data is stored in a database table for further processing.
This plug-in provides an alternative to sending emails to an Appian process model when inbound email integration is requested. Instead of the email being forwarded to Appian, this plug-in reads the emails directly from the Exchange mailbox using the MS Graph API as described below:
Key Features & Functionality
All information how to deploy, configure and use the smart service is in the 'MS Graph Mail Poller.pdf' document in the downloaded zip. Extract the files in the ZIP and follow the instructions in the document.
Eventually, yes. We don't have immediate plans to do so.
If you would like to contribute back to the community, the source code is included in the jar and it should not be too difficult to make the changes.
Hi,
We are replacing the IMAP Mail Poller with MS Graph Poller by following the documentation: (Using existing tables)
But we are getting error -
96861 - WorkID 239 - execution00 - process 27739 - model 5608 : UnattendedJavaActivityRequest] ERROR com.appiancs.msgraphmail.MSGraphDBHandler - Error writing mail to database com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY constraint 'UNIQUE_MESSAGE_ID'. Cannot insert duplicate key in object 'dbo.APP_MAIL_POLLER'. The duplicate key value is (<PH0PR08MB75564179B8074406FAF02B2C8C8B9@PH0PR08MB7556.namprd08.prod.outlook.com>).Please let us know how to resolve this one? (We already have data in the existing table from IMAP Poller)Also we have couple of questions:1. Do this plugin picks only Unread emails OR all emails from Inbox?2. Is there any batch / count in which it picks the email, we have seen a behavior where while running this sometimes it picks 13 sometimes 20 sometimes 9 messages3. Is there any possibility to read only Unread Emails?4. If No to Ques 3 then we need to clear our inbox first and then proceed with the implementation, Right?Thanks
Hello there!We are very interested by this plugin. By downloading it, we saw that you had database scripts for multiple but PostgreSQL. Is there a way to have the scripts for that database?
Thank you
The poller already uses OAuth client credentials flow.
With this plugin, Can We connect to mailbox in Exchange Online using OAuth 2.0, or only is possible use Basic Authentication?
Kind Regards,
I thought that would be the case. Thanks for the prompt response.
At this point, you will still need to configure the data source in the admin console and reference it using a string in the plugin input. DB Connected Systems are supported in plugins since 22.3 but we have not had the chance yet to do the conversion.
We are utilising a MariaDB Connected System to define our data source, which is in a separate schema on the Appian Cloud DB (i.e - not the default "Appian" schema).Is there any way to supply the Connected System data source as an input to this plugin's smart service, instead of a JNDI reference? Or will we still be required to add our data source in the Admin Console for this to work?Thanks!
This is because the OAuth client credential grant needs this to work. You can limit the mailboxes the poller will have access to though. More information: learn.microsoft.com/.../auth-limit-mailbox-access