Poll Email from Microsoft Exchange EWS API

The plugin only supports basic auth. Microsoft will be disabling this for Exchange Online, but customers with Exchange Online should be migrating to MS Graph (https://community.appian.com/b/appmarket/posts/msgraph-email-poller).

Hi, isn't this plugin affected by Microsoft disabling Basic Auth for EWS?
https://techcommunity.microsoft.com/t5/exchange-team-blog/basic-authentication-and-exchange-online-september-2021-update/ba-p/2772210

Kind regards

Hi, we are facing an issue when we use the plug-in with a proxy that doesnt have credentials its returning the error

      "required field proxyUsername does not exist in SCS(buzondesa)"

how can we solved this issue?

kind Regards

Hello, any guidance on the following issue we are facing ?

2022-01-05 11:15:40,236 [Appian Work Item - 232292 - execution02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.mail.EWSMailPollerToDBSmartService - Unexpected error polling for mail
microsoft.exchange.webservices.data.core.exception.service.remote.ServiceRequestException: The request failed. ParseError at [row,col]:[1,1421]
Message: Character reference "&#
	at microsoft.exchange.webservices.data.core.request.SimpleServiceRequestBase.internalExecute(SimpleServiceRequestBase.java:74)

The service has stopped in our QAS system and we urgently need to resume integration, any hep would be appreciated.

Kind regards,

Hello, we have been running the poller for some time now, but in our QAS system suddenly we are not able to process emails and always receive the following error:

2022-01-05 11:15:40,236 [Appian Work Item - 232292 - execution02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.mail.EWSMailPollerToDBSmartService - Unexpected error polling for mail
microsoft.exchange.webservices.data.core.exception.service.remote.ServiceRequestException: The request failed. ParseError at [row,col]:[1,1421]
Message: Character reference "&#
	at microsoft.exchange.webservices.data.core.request.SimpleServiceRequestBase.internalExecute(SimpleServiceRequestBase.java:74)

Does anyone have any view on this issue ? 

Kind regards,

• Adds support for inline images. Inline images can now be created as Appian documents. Additionally, the inline image metadata is added to the APP_MAIL_POLLER_DOC table and the updated HTML (with Appian docs ids substituted for the original content ids), is stored in a new column in the APP_MAIL_POLLER table. This allows for easy display of the email content with inline images in rich text component plugins.
• The updated plugin expects the following new columns
• BODY_SWAPPED_IMAGES in APP_MAIL_POLLER: data type should be the same as BODY_HTML column (longtext in MariaDB)
• INLINE_ID in APP_MAIL_POLLER_DOC: data type should be able to hold 255 text characters (varchar 255 in MariaDB)
• DISPOSITION in APP_MAIL_POLLER_DOC: data type should be able to hold 255 text characters (varchar 255 in MariaDB)

• Fixed issue with jar file

Hi,

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,

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)