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 using the MS Graph API
  • Convert the email to an EML file stored as an Appian document; Item attachments (calendar invites, messages) are kept in the eml file, File attachments removed from it and stored separately in the document management system.
  • Store all email file 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.

Anonymous
Parents
  • Hello, 

    This is a great plugin, just a quick update on my experience while setting up this plugin on-prem setup to avoid confusion and to guide upcoming plugin users.

    1. Setting up a tenant with the Tenant name as “pr**********er.com.au.onmicrosoft.com
    2. Do not rely on the Test connection button when setting up a third-party credential.
    3. Sample application is developed with an old version of the Smart service, so it will not work as it is, you need to create your own process model Or replace the old smart service with a new smart service with your values.
    4. Database scripts are also old, 3 columns are missing [DOC_ID_NO_ATT], [BODY_SWAPPED_IMAGES], [MESSAGE_GRAPH_ID]. Just add while creating a table and it will work smoothly.

    Thanks and appreciate the Appian team’s hard work on this plugin.

    Regards,

    Bhushan

  • Hi Bhushan,

    We are getting the same error "This version of the mailpoller cannot work with the latest MS Graph APIs, use the latest smartservice" We have done all the changes below, please let us know if there is anything else we need to do.

    1. Setting up a tenant with the Tenant name as “xxx.onmicrosoft.com
    2. Do not rely on the Test connection button when setting up a third-party credential.
    3. Database scripts are also old, 3 columns are missing [DOC_ID_NO_ATT], [BODY_SWAPPED_IMAGES], [MESSAGE_GRAPH_ID]. Just add while creating a table and it will work smoothly.

    Regards

    Naveen

Comment
  • Hi Bhushan,

    We are getting the same error "This version of the mailpoller cannot work with the latest MS Graph APIs, use the latest smartservice" We have done all the changes below, please let us know if there is anything else we need to do.

    1. Setting up a tenant with the Tenant name as “xxx.onmicrosoft.com
    2. Do not rely on the Test connection button when setting up a third-party credential.
    3. Database scripts are also old, 3 columns are missing [DOC_ID_NO_ATT], [BODY_SWAPPED_IMAGES], [MESSAGE_GRAPH_ID]. Just add while creating a table and it will work smoothly.

    Regards

    Naveen

Children