Outlook Email Poller

The Outlook Email Poller smart service can be used to read and copy all the unread emails of your outlook account to MySQL database by creating a separate table in the provided datastore. The smart service also allows you to encrypt the email body that you copy to your database making it a secure way of storing all the emails that you receive.

Notes

  1. Requires an App to be registered with read and write permissions in Azure portal, to get the client credentials for the Microsoft account to be used. Please refer to the below link. https://docs.microsoft.com/en-us/graph/auth-register-app-v2
  2. Maximum time limit that can be set is 59 minutes (3,540,000 milliseconds)
  3. Separate folder has to be created for storing all the attachments that come along with the emails

 

Parameters

Inputs

  1. Attachment Folder (Folder) - Folder to which all the attachments in the received emails to be saved in.
  2. Client Id (Text) - Client/Application ID of the registered Email poller Application for the Outlook account.
  3. Client Secret (Text) - Client secret/Application password of the registered Email poller Application.
  4. Email ID (Text) - The outlook email ID to be used.
  5. Enable Encryption (Boolean) - Can be set to true if encryption is required for the email data stored in DB.
  6. Encrypt Secret Key (Text) - The secret key to be used for Encryption/Decryption of the data stored.
  7. Jndi Name (Text) - Name of the datastore in which the email data will be stored.
  8. Tenant Id (Text) - The Tenant/Directory ID of the registered Email poller Application for the Outlook account.
  9. Time Limit (Number Integer) - Maximum time limit in milliseconds for the smart service to run
  10. Is HTML Body: (Boolean) - Can be set to true if the email body is required as an HTML text. If set to false, the email body will be stored as a plain text. 

Outputs

  1. Error Message (Text) - Error message received.
  2. Error Occurred (Boolean) - Set to true on the occurrence of error.
  3. Mail count (Number Integer) - The number of mails that has been read and copied to the table.
  4. Timed Out (Boolean) - Set to true if smart service execution exceeds the given time limit.
Anonymous
  • 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`;