MSGraph Mail Poller

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:

Reads the mailbox(including digitally signed emails) using the MS Graph API
Convert the email to an EML file stored as an Appian document, with attachments removed from it
Store all email attachments as separate Appian documents
Store all email metadata (subject, author, recipients, etc...) into a set of tables in the database

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.
This plugin currently supports only MySQL and Oracle databases.

Parents

syncop8shun 7 days ago

Thanks Mike for the suggestions. I checked the log. It contains the following:

ERROR com.appiancs.msgraphmail.MSGraphDBHandler - Error writing mail to database
java.sql.SQLSyntaxErrorException: (conn=58270) Unknown column 'CONVERSATION_ID' in 'INSERT INTO'

My table did not contain that field.  
I looked at the unzipped file and saw that there is a Version 4.3.0 Add-on Database Scripts folder that I previously ignored.
I did not see anything in the Deployment instructions about the new columns, plus we skipped a few versions. 
I ran the sql in that folder and re-ran the process without any errors.

Comment

syncop8shun 7 days ago

Thanks Mike for the suggestions. I checked the log. It contains the following:

ERROR com.appiancs.msgraphmail.MSGraphDBHandler - Error writing mail to database
java.sql.SQLSyntaxErrorException: (conn=58270) Unknown column 'CONVERSATION_ID' in 'INSERT INTO'

My table did not contain that field.  
I looked at the unzipped file and saw that there is a Version 4.3.0 Add-on Database Scripts folder that I previously ignored.
I did not see anything in the Deployment instructions about the new columns, plus we skipped a few versions. 
I ran the sql in that folder and re-ran the process without any errors.

Children

No Data