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.
According to MS Graph specs, the InternetMessageId is gloablly unique, and it is used as such for this key. You are obviously free to remove the unique key constraint from the database.
Ok thanks for the information.
Could you assure us that when the node returns the error "java.sql.SQLIntegrityConstraintViolationException: (conn=102596) Duplicate entry '<!&!YYYYYYYYYY+...' for key 'UNIQUE_MESSAGE_ID'", it is because the message that the node is trying to insert in the database is identical (message body, subject, attachments etc...) to another one that already exists in the database?
Regards,
Belén.
Hi Belén,
The UNIQUE_MESSAGE_ID KEY refers to the MESSAGE_ID being unique. The MESSAGE_ID comes from the '
internetMessageId' part of the message. According the MSGraph specs, this is 'The message ID in the format specified by RFC2822'
Hello Raymond Braakhekke,
We updated MS Graph Email Poller to the latest version v4.0.0. On some occasions, the node returns the error "Error writing mail to database". Checking the logs, we can see the following:
"java.sql.SQLIntegrityConstraintViolationException: (conn=102596) Duplicate entry '<!&!YYYYYYY+...' for key 'UNIQUE_MESSAGE_ID'"
So, we assume that the plugin read an email that was previously inserted in DB.The question is, is the email that it tries to insert, really identical to the one that already exists in DB (body, subject, attachments, recipients, etc...)?
We have the doubt because we do not know how the 'UNIQUE_MESSAGE_ID' field is formed.
Thank you very much,
Belén
Patrick/Ambrishs - could you please provide Azure setup documentation if you have. Thank you so much
we are trying to poll emails, If anyone has documentation around how to setup mailbox permissions, Do we have to give full application level permissions to create keys, or is there a way to create keys for individual inbox. Security team was saying it gives permissions to all inboxes including user inboxes, if they give application level permission. any documentation or help would be appreciated.
thank you but also we need the structure of the project to compile/import at Eclipse, Raymond Braakhekke Mike Cichy
Per Raymond, the source code is in the jar (src folder). We do not distribute the project or build files.
thank you Raymond Braakhekke but our team needs the source code due to is very difficult to compile the code in the jar. could you help us with the source code?
The code is in the jar. Simply rename it to .zip and unpack it