Mail Server to Database

Overview

This version is for Appian 25.1 and above. Cloud customers on a lower version of Appian that want to install this plugin should open a support case. Self-managed customers can download the latest JAR for Appian 25.1 and later from the AppMarket.

Enhancement to the plug-in to enable the selection of whether or not to include the email attachments as part of the EML document. Previously, the plug-in would create an EML document with the attachments stripped out. Our client needs to preserve the original e-mail as it was sent (for auditing purposes), so the EML must include the attachments as part of it. This update extends the functionality to allow the user to select whether they want an EML with the attachments removed (original functionality), an EML with attachments included, or both (2 EMLS of original email - one without the attachments included and one with the attachments included). Any e-mail attachments will continue to be saved separately.

Key Features & Functionality

Takes all unread email from a mailbox and adds entries directly to a database table.The original email is saved as an EML based on three attachment type options

  1. EML with attachments removed
  2. EML with attachments included
  3. Both (2 EMLs of original email) - EML with attachments removed and EML with attachments included

Each email attachment is saved as its own document. The database tables store the Appian document ids, email recipients, subject and body (text and HTML)

Anonymous
  • You need to use the preconfigured values only - these are the activities programmed into the node's code.

  • , We observe that when passed to the smart-service parameters OnSuccess and OnFailure are from a constant or process variable, they are not received by the plug-in code. Only pre-configured values (Delete/ mark as read) visible in the value dropfown seem to be accepted. Can you please advise if there is a way to change this behaviour to accept other values from constants or are we required to use the pre-configured values only?   

  • Was IMAP disabled for the account? Microsoft has been announcing and delaying disabling basic auth for a few years, and I think it may have actually happened.

    Or IMAP was disabled at the org level and nobody told you.

    Either way, I would recommend switching to the MSGraph Poller to work with office 365. It's faster and provides the same functionality, with the the same data structure.

  • Hi Mike,

    Yes we have verified the credentials and they are working fine and we are able to login to outlook mailbox.

    Both Version - Version 1.1.6 and New verion with support to Jakarta library (Got installed via ticket on 22.2 version).

    We are getting below error -

    528 : UnattendedJavaActivityRequest] ERROR com.appiancs.mail.MailPollerSmartService - Error during mail polling

    javax.mail.AuthenticationFailedException: LOGIN failed.

    at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:661)

  • Do you have the stack trace or any additional detail? Not much to go on otherwise.

    What do you mean by "both versions"?

    How have you verified the credentials?

  • Hi Mike,

    We are seeing one strange behavior where Plugin has started giving us LOGIN Failed error even when mailbox credentials are correct and working perfectly fine.

    We are on 22.2 and tried for both the version of plugins 1.1.6 and by deploying the Plugin as mentioned in release notes but getting same error in all the env

  • Yes, it is a clean break. 1.1.7 works with 22.2 and below, 2.0 works with 22.3 and above.

  • Hi Mike, does the above mean the version 2.0.0 is not backward compatible (Appian v21.4, on-premise, in our case) and must have Appian v22.2+ to work ? Will current version (1.1.7) stop working once Appian version is upgraded to 22.2/ 22.3? 

  • Release Notes - v2.0.0
    • Updated to support the jakarta mail library introduced in Appian 22.3. This version is for Appian 22.3 and above. Cloud customers on a lower version of Appian that want to install this plugin should open a support case. Self-managed customers can find the latest jar for Appian 22.2 and lower version by downloading from the app market.