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
  • Hi Team,

     

    Thank you for developing this plugin. We have been using this plugin to extract email data from an outlook inbox and create requests for each email. The plugin is quite stable and works fine except for a couple of scenarios which we have observed and I would need your help on this. 

    When the inbox receives a very long email either very long content in the body or many attachments with total size exceeding 25 MB, the mail poler keeps timing out. This also causes any new emails, that come after the large email , to not create requests and keep them unread. As a manual workaround, what we currently do is , mark that large email as manually read and create a manual request for it so that the mail poler can continue creating requests for the other emails. 

     

    We don't often get very large emails, most of time we receive smaller emails but once in a while we do get a very large email and we can't prevent our users from sending them.

     

    We currently run the Mail poler process at a 3 min frequency (so every 3 mins the mailpoler checks the inbox in loop) and we have set the TimeLimit parameter to 250000 (250 seconds or 4 minutes).

     

    Can you please investigate this scenario and see if the plugin code can be further tuned so it doesn't time out or suggest us how we can better error handle this situation. 

  • v3.0.6 Release Notes
    • Bug fix – Deletes attachments that are saved in the folder if there is any error in saving the email in database.
  • v3.0.4 Release Notes
    • Bug fixes
    • Updated libraries
  • v3.0.3 Release Notes
    • Fixed the issue in Saving Mail Record Id
  • Hi,

    I am trying implement this plugin using my personal outlook account, but I am getting the error: 

    "{"errorMessage":"Authentication failed. Received empty access token."}".

    Can someone explain this issue?

  • v3.0.2 Release Notes
    1. Bug fixes
    2. Changed the following column types from Varchar2(2000) to CLOB for Oracle database
    3. TO_EMAILS
    4. TO_NAMES
    5. CC_EMAILS
    6. CC_NAMES
    7. BCC_EMAILS
    8. BCC_NAMES
    9. IN_REPLY_TO
    10. Changed the column type of IN_REPLY_TO column from Varchar(2000) to TEXT for mysql, mariadb and MS-SQL

  • V. 3.0.1 Release Notes
    Included support for MS SQL Server Database

  • v3.0.0 Release Notes
    • Updated libraries.
    • Added feature to ignore inline attachments using a boolean property.
    • Changed the logging severity to info when there are no unread emails found.