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.
If you are upgrading to a newer version, you should check if the 2 statement below should be applied to your tables.
In an earlier version, these were not present, and in one version it was not part of the database scripts.
If you get an error on either BODY_SWAPPED_IMAGES or IS_INLINE, please run these 2 statements against the database:
ALTER TABLE app_mail_poller ADD BODY_SWAPPED_IMAGES BLOB NULL;ALTER TABLE app_mail_poller_doc ADD IS_INLINE BIT NULL;
Hello. I am trying to implement this plugin and we are receiving the following message when the poller runs:(conn=7686054) Unknown column 'BODY_SWAPPED_IMAGES' in 'field list'
Any info around the cause and resolution of this error ?
Hi syncop8shun, we are receiving the same error, can you help if you were able to resolve this ?
Hi ambrishs. We have the same problem and think it is the tenant url, I used your suggestion but does not seems to works. Can you share the Azure setup we need to have, it would be very helpfull? Thanks
Hello. We upgraded to the v2.2.2 version and are receiving the following message when the poller runs: There was an error when processing email(s) in monitored email inbox with following error message in [name of app] :(conn=7686054) Unknown column 'BODY_SWAPPED_IMAGES' in 'field list'
I could not find any reference to 'BODY_SWAPPED_IMAGES'. Is this field part of the MS Graph Poller?
We have MS Poller configured for one of our application. We noticed that MS Poller smart service is not able to ingest .MSG files as an attachment, however associated mail is ingested. (Email attachment inside another email).
Kindly assist.
... is XXX.onmicrosoft.com