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 EWS web services API.
Alternatively, the credentials store required by the plug-in can be created manually. It requires the following attributes:
Smart service "EWS Mail Poller To DB":
To use this plug-in:
By default, the emails successfully processed are moved to the folder Deleted Items and the emails that cannot be processed are moved to the folder Junk E-mails.
We are facing an issue when we attach a file with a file name that contains (×) this character For Eg. Sample_300×300.jpg, EWS Poller move it to the Exception folder and Email Notification is sent to Alert Receivers. Any leads would be helpful.
I was able to figure it out. This version of plugin 1.0.23 expects a DB columns which isn't provided by the Application which is provided with plugin, but it's easy to add by running below script.
ALTER TABLE [dbo].[APP_MAIL_POLLER_DOC]ADD INLINE_ID int,DISPOSITION nvarchar(2000);
For those who are looking to figure out configurations. these are the steps to follow after the sample application is installed:
Update the table APP_MAIL_POLLER_DOC
ALTER TABLE [dbo].[APP_MAIL_POLLER_DOC]
ADD INLINE_ID int,
Service URL: https://outlook.xxxx.com/EWS/Exchange.asmx
Domain: provide your domain like xxx.com
Jndi Name: change with your DB Jndi available in Data Store
Exception Folder Name: Junk Email
Processed Folder Name: Deleted Items
Installed this plugin and configured it successfully to poll and read emails without attachment. But when there is an attachment in the email the sample process returns error - Invalid column name 'INLINE_ID'.
I have used the MS SQL version of application. Any help is appreciated.
2021-08-06 17:04:20,460 [Appian Work Item - 142 - execution02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.mail.MessageHandler - Error during email processingcom.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'INLINE_ID'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:254) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1608) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:578) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:508) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7240) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2869) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:243) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:218) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:461) at sun.reflect.GeneratedMethodAccessor819.invoke(Unknown Source)
HI - We are trying to use this plugin but we get could not resolve host error for EWS outlook URL when we try without proxy . We have to keep proxy flag as yes but looks like proxyusername and proxypassword is the required parameters for this plugin to work. We do not have these credentials as the server proxies do not authenticate . We tried to change the code so that it does ask for proxyusername and password but it seems like the proxy credentials are mandatory for working with proxy flag yes . Is that true ? Can we someone bypass the proxy credential requirements to make this plugin work?
we have experienced after upgrading to Appian 21 the message "Unsupported database for processing email: mariadb" in logs.
You will provide an update to version 21?
Please suggest me what all configurations are required in admin console, and what is proxy username and password?
Note: I am working in Cloud environment.
Does anyone know the admin console settings to be done in order to use this plugin. The download doesn't have any properties file as described in the description. or is there something i am missing. Any leads would be helpful.
© 2021 Appian. All rights reserved.