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.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`;