Overview
This version is for Appian 22.3 and above. Cloud customers on a lower version of Appian that want to install this plugin should open a support case. Self-managed customers can find the latest jar for Appian 22.2 and lower version by downloading from the app market.
Enhancement to the plug-in to enable the selection of whether or not to include the email attachments as part of the EML document. Previously, the plug-in would create an EML document with the attachments stripped out. Our client needs to preserve the original e-mail as it was sent (for auditing purposes), so the EML must include the attachments as part of it. This update extends the functionality to allow the user to select whether they want an EML with the attachments removed (original functionality), an EML with attachments included, or both (2 EMLS of original email - one without the attachments included and one with the attachments included). Any e-mail attachments will continue to be saved separately.
Key Features & Functionality
Takes all unread email from a mailbox and adds entries directly to a database table.The original email is saved as an EML based on three attachment type options
Each email attachment is saved as its own document. The database tables store the Appian document ids, email recipients, subject and body (text and HTML)
Hi Mike,
When I am using your component, I am getting error,"Incorrect syntax near '`'."
This question is for a different component, can you post it here please: https://community.appian.com/b/appmarket/posts/poll-email-from-microsoft-exchange-ews-api
I assume you have to specify the correct inbox and correct credentials. The second error would indicate that your credentials are incorrect.
Hi,
I am trying to read from my outlook account. When I am adding service url as "outlook.office365.com", I am getting error as "com.appiancorp.ps.mail.EWSMailPollerToDBSmartService - Unexpected error polling for mailmicrosoft.exchange.webservices.data.core.exception.service.remote.ServiceRequestException: The request failed. null".
If I am adding service url as "">outlook.office365.com/.../inbox", error changes to
" microsoft.exchange.webservices.data.core.exception.service.remote.ServiceRequestException: The request failed. The remote server returned an error: (401)Unauthorized"
Can anyone guide where I am getting it wrong?
Ahh, yes. I missed that test case. I will get the updated jar sometime today.
Thanks Mike for the reply. We are using latest plugin only. I observed date in header for EML with no attachments and not for the EML with attachments. EML attachment type property set to "Both". Do we have to change this property. Thanks
Yes, we noticed that too. The latest version updated on 2020-03-06 captures that in the eml header.
Hi Mike, we are able to read email with this plugin but when opening the eml attachment date and time is missing(Original email sent date and time). Our requirement is to show date and time of the email when user open it. PFA screenshot. Thanks in advance for your help.
Hi Neil, We are getting below error when we use the Oracle DB. Please advice on this.
ProcessExec01 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.mail.MailPollerSmartService - Error during database processing 2020-02-11 14:27:18,879 INFO [stdout] (Appian Work Item - 5133 - ProcessExec01 : UnattendedJavaActivityRequest) java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
Thanks Niel for the details information. I am still struggling to make connection with email.
We are connecting to email box on behalf of service account i.g: domain/service account/emailbox(email name before @) hence i have created third party credential like test_domain/MVSS-CMS/test_email and password of the given email account.
I hope i am doing correct things.
Got the latest document. Thank you!!