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
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.
Please check stdOut log for a more detailed error message.
I am getting the error message, I was working before, can anyone help me here.ErrorMessage - Error executing the request
Check your stdOut log but likely your DB structure is old and you need to update the structure to match the latest scripts.
Hello. We just upgraded the plugin to v4.4.0 and we also upgraded to Appian 25.4. When running the poller, it cannot write to the database. I did not update the node in the process. It still points to jdbc/Appian just as it did before the latest version. Any ideas?
Thanks for flagging this, the improvement suggestion also seems reasonable.
Empty Document Names for Email Attachments Without Subject
Problem Description:
When processing emails with attachments that have no name or subject (e.g., draft emails without a subject line attached to another email), the MS Graph Mail Poller plugin would import in appian the attachment documents with empty names. This is incoherent with out of the box Smart Service Edit Document Properties that does not allow to edit a document with an empty name.
Scenario to Reproduce:
Suggestion of improvement:
Dear Team, we have a requirement to read only specific emails from mailbox, currently we couldn't find any option to configure target folder to read emails from. It'll be very helpful if we could do that in future versions.