Outlook Email Poller

Overview

The Outlook Email Poller is a smart service plugin designed to seamlessly connect with Microsoft Outlook, read unread emails, and store them securely in MySQL, Oracle, or MariaDB databases


Key Features & Functionality

  • Read Unread Mails From Outlook Mailbox and write mail information to Database
  • Store Mail Content and Attachments In Appian Document Folders
  • Support For Oracle Mysql And MariaDb Databases to write the mail content
  • Support For Application Mailbox Read and Delegated Mailbox Read
  • Implements robust encryption mechanisms for securing sensitive email body content during storage in the database.

Anonymous
  • v1.4.4 Release Notes
    • Smart service for delegated service account
    • Skip Messages that could not be processed
    • Improved Error Handling
  • v1.4.2 Release Notes
    • Automatic Sequence Creation For Oracle
    • Table Names and Sequences created in oracle naming conventions similar to CDT for easier reference
    • Performance Improvements
  • v1.4.1 Release Notes
    • Added Smart Service For Oracle Support
    • Synchronisation at emailId,Folder Name Level
    • Custom Folders other than Inbox can be Polled
    • Email Also created as an eml document in Appian
    • Added a new column to the existing table.
  • v1.4.0 Release Notes
    • Added two new smart services to support Secure Credential
    • Storage for email credentials. Use clientid,tenantid and clientsecret as field keys to the SCS/Third party Credentials.
  • I would like to use this plug-in and I have some questions ...
    Does this work with Appian Cloud?
    Is there an SQL script to create the table (the download contains only a jar)?

    My comments...
    The parameters documented here do not match those of the smart service.
    * "Is HTML Body" is not present in the service. Can I just add it manually?
    * The service (dynamic version) contains "Enable Clean", "Ignore Clean Characters" and "Table Name"

  • v1.3.1 Release Notes
    • Added MariaDB support
  • v1.3.0 Release Notes
    • Fixed applied for ATP file scanning issue
    • Before v1.3.0 : When the ATP file scanning is in progress for the email attachments received in the mailbox (delayed because of some reason) & when the Graph API tries to poll those emails, it polls with only an Empty file.
    • After v1.3.0: The smart service will wait for the ATP file scanning to complete before fetching the attachments.

  • v1.1.0 Release Notes
    • Conversation_ID captured in the “app_mail_poller” table which helps to search the emails that are under the same thread
    • Content ID of the attachments are captured in the “app_mail_poller_doc” table which helps track the order of the inline image attachments
    • Run the following SQL in database to avoid column invalid errors if v1.0.0 is already deployed and v1.0.0 tables were already created
    ALTER TABLE `app_mail_poller`
    ADD COLUMN `CONVERSATION_ID` VARCHAR(500) NULL AFTER `MESSAGE_ID`;

    ALTER TABLE `app_mail_poller_doc`
    ADD COLUMN `MS_CONTENT_ID` TEXT NULL AFTER `DOC_IDX`;