Microsoft Exchange Reader
[ | version 3.0]
Connector
The connector is permitted for use of the platform background agent.
Connector processing type: Row by row!
This connector allows to download email messages from Microsoft Exchange account by GraphAPI. It is used when given mailbox is supporting REST API i.e. Azure Office365 installations.
Required Microsoft Graph API Application permissions
- Mail.Read
Using placeholders
For string properties in configuration you can use single cell placeholder which can be wrapped by other text.
Typically it can be used to read messages for different users. So each input row can contain username and password to be used in configuration.
Example
- ${input.UserName}
- ${input.Password}
Storage data
This connector saves last read email for each username or mailbox.
{
"LastReadEmail": {
"test.user@intelstudios.com": {
"LastRead": {
"IDs": [
"ZAAAfWGVlAAA="
],
"Received": "2020-03-17T07:50:07Z"
},
"FoldersMap": {}
},
"test.user2@intelstudios.com": {
"LastRead": {
"IDs": [
"ZADJSpsadIIDAAA="
],
"Received": "2020-04-17T03:50:07Z"
},
"FoldersMap": {}
}
}
}
Configuration
Input & Output Schema
Input
Input schema is opional
Output
Result of Exchange reader connector are email messages from given mailbox. Attachments are encoded to Base64 and saved to Attachment of output schema.
E-Mail (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | string | No | ID of message |
| string | No | Actual email address from Username field in configuration | |
| Subject | string | Yes | Subject |
| From | E-Mail Person 1.0.0 |
No | Sender of email data |
| To | E-Mail Person 1.0.0 |
No | The recipient/s of the email data object |
| Cc | E-Mail Person 1.0.0 |
Yes | Recipients that are copied on the email data object |
| Bcc | E-Mail Person 1.0.0 |
Yes | Recipients that are blind-copied on the email data object |
| DateSent | DateTime | No | Date when email was sent |
| DateReceived | DateTime | No | Date when email was received |
| ReplyTo | E-Mail Person 1.0.0 |
Yes | Serialized content of HTTP response |
| BodyText | String | Yes | Serialized content of HTTP response |
| Body | String | Yes | Body |
| Importance | String | No | Importance of email (low, normal, high) |
| Attachment | E-Mail Attachment 1.0.0 |
Yes | Email attachments |
E-Mail Person (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Name | string | Yes | Name of person |
| Address | string | No | Email address |
E-Mail Attachment (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Name | string | No | File name with extension |
| Content | Base64 | No | Encoded file content |
Release notes
3.0.7
- Plugin binaries update as a result of included connector change.
3.0.4
- Fixed finding folder for configuration custom folder property.
3.0.3
- Fixed shared nuget package versions.
3.0.2
- Fixed right processing of nullable properties.