Plug-in (Function & Smart Service)Free

Outlook Email Poller

by Vuram Technology

Description

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,MsSQL, Oracle, or MariaDB databases

Features

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

Release notes

Bug fix – Fixed the error of returning mailRecordIds as null when there is an error. Security Patch update

Version history (25)

3.0.6

Bug fix – Deletes attachments that are saved in the folder if there is any error in saving the email in database.

3.0.5

V 3.0.5

  1. Bug fixes.

3.0.4

V 3.0.4

  1. Bug fixes.
  2. Updated libraries.

3.0.3

V3.0.3 Fixed the issue in Saving Mail Record Id

3.0.2

  1. Bug fixes
  2. Changed the following column types from Varchar2(2000) to CLOB for Oracle database

-TO_EMAILS -TO_NAMES -CC_EMAILS -CC_NAMES -BCC_EMAILS -BCC_NAMES -IN_REPLY_TO

  1. Changed the column type of IN_REPLY_TO column from Varchar(2000) to TEXT for mysql, mariadb and MS-SQL

3.0.1

Included support for MS SQL Server Database

3.0.0

  1. Updated libraries.
  2. Added feature to ignore inline attachments using a boolean property.
  3. Changed the logging severity to info when there are no unread emails found.

2.0.1

Bug fixes.

2.0.0

  1. Included new output parameter in all smart services - Mail Record Id (List of Number Integer) which returns the primary key of the mail records inserted in the database.
  2. Changed the datatypes of the following database columns in all smart services from BLOB to TEXT types (changed only in mySQL and mariaDB – not for Oracle DB). SUBJECT – BLOB -> TEXT BODY_PREVIEW – BLOB -> TEXT BODY_HTML – LONGBLOB -> LONGTEXT BODY_TEXT – LONGBLOB -> LONGTEXT Note: Existing users kindly change the datatype of these columns in the database before using this new version.

1.5.2

Bug fixes.

1.5.1

Minor bug fixes.

1.5.0

  1. Performance improved.
  2. Minor bug fixes.
  3. Added logs for time consumption.

1.4.9

  1. Updated JSON jar file which caused exception.
  2. Fixed an issue where the generated file names were not matching the subject.
  3. Fixed an issue where file extensions are mismatched.

1.4.8

Changed the format of the name with which the EML file and the attached documents are created in Appian.

1.4.7

Bug Fix

v1.4.6

Security patch updated

v1.4.5

Smart service for delegated service account now supports shared mailboxes.

v1.4.4

-Smart service for delegated service account -Skip Messages that could not be processed -Improved Error Handling

1.4.2

-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

What’s new in v1.4.1:

  1. Added Smart Service For Oracle Support
  2. Synchronisation at emailId,Folder Name Level
  3. Custom Folders other than Inbox can be Polled
  4. Email Also created as an eml document in appian
  5. Added a new column to the existing table.

1.4.0

What’s new in v1.4.0: 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.

1.3.1

What’s new in v1.3.1:

Added MariaDB support

1.3.0

What’s new in v1.3.0:

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.

1.2.0

What’s new in v1.2.0:

Priority is captured in the “app_mail_poller” table, which gives the importance of the emails.

New smart service named “Poll Outlook Email To Dynamic Table” is added. Where table name can be given as input. If a table does not exist with the input, it will create the new tables. Document table name will be appended by ‘_doc’ with the table name input.

Added clean logic for BODY_HTML and BODY_TEXT columns on “Poll Outlook Email To Dynamic Table” smart service. To enable or disable this feature use ‘EnableClean’ boolean input. To ignore any cases to clean, use ‘IgnoreCleanCharacters’ string input. Provide all ignored characters as a single string.

Things to Do if the plugin 1.1.0 was already deployed:

If Email poller v1.1.0 tables were already created in DB. Please run the below statement in DB to avoid column invalid errors.

ALTER TABLE app_mail_poller
ADD COLUMN PRIORITY VARCHAR(50) NULL AFTER CONVERSATION_ID;

1.1.0

What’s new in v1.1.0:

Conversation_ID is captured in the “app_mail_poller” table, which helps to search the emails that are under the same thread.

The Content ID of the attachments are captured in the “app_mail_poller_doc” table, which helps us to track the order of the inline images attached in the email.

Things to Do if the plugin 1.0.0 was already deployed:

If Email poller v1.0.0 tables were already created in DB. Please run the below statement in DB to avoid column invalid errors.

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;

Resources

  • Outlook Email Poller Documentation.pdf

    User Guide

    Download