Poll Email from Microsoft Exchange EWS API

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,

DISPOSITION nvarchar(2000);

2. Create Secure Credential Store: ewsmailpollerscs with fields username and password and include plugin EWS Mail Poller. Username should contain complete email address including @xxx.com
3. Update Properties in APP Poll Mail From Mailbox Process Model

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.

Log details:

2021-08-06 17:04:20,460 [Appian Work Item - 142 - execution02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.mail.MessageHandler - Error during email processing
com.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)

• This new version fix the issue with the mail primary not being stored in the mail doc table when using MariaDB

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?

Hi Sylvain.

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?

HI Sylvain,

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.

Hi Team,

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.

• Resolved issues with exception handling

• Resolved issues with invalid domains

I apologize but I do not understand your issue. This plugin is made so that Appian can read emails from Exchange. 

Could you please provide more details on your issue?