MSGraph Email Poller

Overview

Need to poll emails from your Exchange server? This smart service can be used in a poller process and extract the data from the Microsoft Exchange server. Messages are stored in the Appian Document System, as well as the attachments. Meta data is stored in a database table for further processing.

This plug-in provides an alternative to sending emails to an Appian process model when inbound email integration is requested. Instead of the email being forwarded to Appian, this plug-in reads the emails directly from the Exchange mailbox using the MS Graph API as described below:

  • Reads the mailbox(including digitally signed emails) using the MS Graph API
  • Convert the email to an EML file stored as an Appian document, with attachments removed from it
  • Store all email attachments as separate Appian documents
  • Store all email metadata (subject, author, recipients, etc...) into a set of tables in the database

Key Features & Functionality

  • All information how to deploy, configure and use the smart service is in the 'MS Graph Mail Poller.pdf' document in the downloaded zip.
  • Extract the files in the ZIP and follow the instructions in the document.
  • This plugin currently supports only MySQL and Oracle databases
Anonymous
  • We setup the MSGraph Email Poller to point to the Inbox of a shared group folder. Before the Poller process ran, a secure email was received into the Inbox and one of the people in the email group opened the email and sent a response to the sender.

    The response generated an automated system email from the System Administrator into the Inbox with the message: "Your message did not reach some or all of the intended recipients. This message could not be sent. You do not have the permission to send the message on behalf of the specified user."

    When the Email Poller ran every 5 minutes after the system-generated email appeared in the Inbox, it continued to fail because it was unsuccessful when trying to process this system-generated message. The system-generated message was not moved to the Exception Folder identified in the MS Graph Mail Poller smart service. Once the system-generated message was manually removed from the Inbox, there were no more Email Poller errors and other emails in the Inbox were able to be processed.

    Can the MSGraph Email Poller be updated to handle this type of message by sending the system-generated email to the Exception Folder and to not cause an error that keeps other emails from being processed?

  • Release Notes - v2.3.0
    • Maintains original email aliases in to/cc/bcc fields instead of replacing with mailbox primary email
    • Stores additional field - immutable (within mailbox) Graph message id - in database

  • If you are upgrading to a newer version, you should check if the 2 statement below should be applied to your tables.

    In an earlier version, these were not present, and in one version it was not part of the database scripts.

    If you get an error on either BODY_SWAPPED_IMAGES or IS_INLINE, please run these 2 statements against the database:

    ALTER TABLE app_mail_poller ADD BODY_SWAPPED_IMAGES BLOB NULL;
    ALTER TABLE app_mail_poller_doc ADD IS_INLINE BIT NULL;

  • Hello.  I am trying to implement this plugin and we are receiving the following message when the poller runs:
    (conn=7686054) Unknown column 'BODY_SWAPPED_IMAGES' in 'field list'

    Any info around the cause and resolution of this error ? 

  • Hi , we are receiving the same error, can you help if you were able to resolve this ?

  • Hi ambrishs.  We have the same problem and think it is the tenant url, I used your suggestion but does not seems to works. Can you share the Azure setup we need to have, it would be very helpfull?  Thanks

  • v2.2.3 Release Notes
    • Updated version of jsoup library to prevent StackOverflorError when parsing densely nested HTML
    • Updated database scripts
    • Please note that if you're upgrading from pre 2.2.1, there are two new fields included in those scripts that must be added to your DB tables
  • Hello.  We upgraded to the v2.2.2 version and are receiving the following message when the poller runs: There was an error when processing email(s) in monitored email inbox with following error message in [name of app] :(conn=7686054) Unknown column 'BODY_SWAPPED_IMAGES' in 'field list'

    I could not find any reference to 'BODY_SWAPPED_IMAGES'.  Is this field part of the MS Graph Poller?

     

  • v2.2.2 Release Notes
    • Fixed a bug in parsing .json attachments
    • Updated DB script to include the new column
  • v2.2.1 Release Notes
    • Added new smart service with various new input parameters
    • Ability to toggle whether fileAttachments are included in generated EML file
    • Ability to toggle parsing of itemAttachments; Saves them as an Appian doc if set to true, previously these attachments were not included
    • Ability to toggle parsing of inlineImages; Detects any img tags with cid-based src's, replaces the src with the link to the Appian document