Outlook Mail (Office 365) Connector

The high-performance Outlook Mail (Office 365) Connector provides read/write capabilities within your application, allowing you to perform numerous Outlook Mail (Office 365) operations with minimal coding or even no-coding at all. Integrate Outlook Mail (Office 365) data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download for SSIS Download for SQL Server and ODBC Documentation

Integrate Outlook Mail (Office 365) with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

Actions supported by Outlook Mail (Office 365) Connector

Outlook Mail (Office 365) Connector supports following actions for REST API integration:

Delete Message by Id (Single)

Description

Delete message by Id for a specific mailbox and folder.

Parameters

You can provide the following parameters to this action:

  • MessageId
  • User ID or Email
  • MailFolderId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Status
  • StatusCode
  • MessageId
  • UserId
  • MailFolderId
  • ErrorCode
  • ErrorMessage

Visit documentation for more information.

Delete Messages - Using Search Condition (Bulk Delete)

Description

Delete multiple messages for a specified search condition / mailbox / folder (Bulk delete outlook messages).

Parameters

You can provide the following parameters to this action:

  • User ID or Email
  • Email Body Format
  • MailFolderId
  • Search Criteria
  • Order By
  • Page Size

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • MessageId
  • Status
  • ErrorCode
  • ErrorMessage

Visit documentation for more information.

Download Message Attachment (Single File)

Description

Download a specific attachment linked to the specified message Id.

Parameters

You can provide the following parameters to this action:

  • User ID or Email
  • Message ID
  • Attachment ID

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Data
  • Status
  • StatusCode

Visit documentation for more information.

Download Message Attachments (Multiple Files) - Using Search Condition

Description

Downloads multiple attachments for a specified search condition / mailbox / folder.

Parameters

You can provide the following parameters to this action:

  • User ID or Email
  • SaveFolder
  • Email Body Format
  • MailFolderId
  • OverwriteFile
  • Search Criteria
  • Order By
  • Page Size

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • MessageId
  • Name
  • ContentId
  • ContentType
  • ContentLocation
  • IsInLine
  • LastModifiedDateTime
  • Size
  • SavedPath
  • SavedSize

Visit documentation for more information.

Download Message by Id (Single *.EML File RFC 822 / MIME)

Description

Downloads a single message as *.EML File type (RFC 822 / MIME) for a specified Message Id / mailbox / folder.

Parameters

You can provide the following parameters to this action:

  • MessageId
  • User ID or Email
  • SaveFolder
  • MailFolderId
  • OverwriteFile

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • StatusCode
  • ErrorMessage
  • MessageId
  • UserId
  • MailFolderId
  • SavedFileSize

Visit documentation for more information.

Download Messages by Search Condition (Multiple *.EML Files RFC 822 / MIME)

Description

Downloads multiple messages as *.EML File type (RFC 822 / MIME) for a specified search condition / mailbox / folder.

Parameters

You can provide the following parameters to this action:

  • User ID or Email
  • SaveFolder
  • Email Body Format
  • MailFolderId
  • OverwriteFile
  • Search Criteria
  • Order By
  • Page Size
  • Selected Columns

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • MessageId
  • SavedFileSize
  • StatusCode
  • ErrorMessage
  • UserId
  • MailFolderId
  • ODataETag
  • Categories
  • ParentFolderId
  • ConversationId
  • ConversationIndex
  • IsDeliveryReceiptRequested
  • IsReadReceiptRequested
  • IsRead
  • IsDraft
  • WebLink
  • InferenceClassification
  • InternetMessageHeaders
  • BodyContentType
  • BccRecipient5
  • FromEmailAddressName
  • FromEmailAddress
  • ReplyTo
  • UniqueBodyContentType
  • UniqueBodyContent
  • FlagFlagStatus
  • InternetMessageId
  • BodyContent
  • BccRecipient4
  • BccRecipient2
  • HasAttachments
  • Subject
  • BodyPreview
  • SenderEmailAddressName
  • SenderEmailAddress
  • Importance
  • SentDateTime
  • CreatedDateTime
  • LastModifiedDateTime
  • ChangeKey
  • ToRecipients
  • BccRecipient3
  • CcRecipients
  • ToRecipient1
  • ToRecipient2
  • ToRecipient3
  • ToRecipient4
  • ToRecipient5
  • CcRecipient1
  • CcRecipient2
  • CcRecipient3
  • CcRecipient4
  • CcRecipient5
  • BccRecipient1
  • BccRecipients
  • ReceivedDateTime

Visit documentation for more information.

Get Group by Id

Description

Get a specific group.

Parameters

You can provide the following parameters to this action:

  • Group ID or Email

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • DisplayName
  • DeletedDateTime
  • Classification
  • CreatedDateTime
  • CreationOptions
  • Description
  • ExpirationDateTime
  • GroupTypes
  • IsAssignableToRole
  • Mail
  • MailEnabled
  • MailNickname
  • MembershipRule
  • MembershipRuleProcessingState
  • OnPremisesDomainName
  • OnPremisesLastSyncDateTime
  • OnPremisesNetBiosName
  • OnPremisesSamAccountName
  • OnPremisesSecurityIdentifier
  • OnPremisesSyncEnabled
  • PreferredDataLocation
  • PreferredLanguage
  • ProxyAddresses
  • RenewedDateTime
  • ResourceBehaviorOptions
  • ResourceProvisioningOptions
  • SecurityEnabled
  • SecurityIdentifier
  • Theme
  • UniqueName
  • Visibility
  • OnPremisesProvisioningErrors
  • ServiceProvisioningErrors

Visit documentation for more information.

Get Groups

Description

Get the list of groups.

Parameters

You can provide the following parameters to this action:

  • Order By
  • Search Criteria
  • Page Size

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • DisplayName
  • DeletedDateTime
  • Classification
  • CreatedDateTime
  • CreationOptions
  • Description
  • ExpirationDateTime
  • GroupTypes
  • IsAssignableToRole
  • Mail
  • MailEnabled
  • MailNickname
  • MembershipRule
  • MembershipRuleProcessingState
  • OnPremisesDomainName
  • OnPremisesLastSyncDateTime
  • OnPremisesNetBiosName
  • OnPremisesSamAccountName
  • OnPremisesSecurityIdentifier
  • OnPremisesSyncEnabled
  • PreferredDataLocation
  • PreferredLanguage
  • ProxyAddresses
  • RenewedDateTime
  • ResourceBehaviorOptions
  • ResourceProvisioningOptions
  • SecurityEnabled
  • SecurityIdentifier
  • Theme
  • UniqueName
  • Visibility
  • OnPremisesProvisioningErrors
  • ServiceProvisioningErrors

Visit documentation for more information.

Get Mail Folder by Id [only works with User Credentials]

Description

Get the mail folder specified by the mail folder Id.

Parameters

You can provide the following parameters to this action:

  • Mail Folder Id
  • Selected Columns

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • DisplayName
  • ParentFolderId
  • ChildFolderCount
  • UnreadItemCount
  • TotalItemCount
  • SizeInBytes
  • IsHidden

Visit documentation for more information.

Get Mail Folders

Description

Get the list of mail folders for the specified user Id.

Parameters

You can provide the following parameters to this action:

  • User ID or Email
  • Order By
  • Search Criteria
  • Page Size
  • Selected Columns

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • DisplayName
  • ParentFolderId
  • ChildFolderCount
  • UnreadItemCount
  • TotalItemCount
  • SizeInBytes
  • IsHidden

Visit documentation for more information.

Get Message Attachment

Description

Get a specific attachment linked to the specified message Id.

Parameters

You can provide the following parameters to this action:

  • User ID or Email
  • Message ID
  • Attachment ID

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • ContentType
  • IsInline
  • LastModifiedDateTime
  • Size
  • ContentId
  • ContentBytes
  • ODataType
  • ODataMediaContentType

Visit documentation for more information.

Get Message Attachments

Description

Get the list of attachments linked to the specified message Id.

Parameters

You can provide the following parameters to this action:

  • User ID or Email
  • Message ID
  • Order By
  • Search Criteria
  • Page Size

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • ContentType
  • IsInline
  • LastModifiedDateTime
  • Size
  • ContentId
  • ContentBytes
  • ODataType
  • ODataMediaContentType

Visit documentation for more information.

Get Message by Id (Single) - Output binary data (EML RFC 822 / MIME)

Description

Gets a single message binary data as *.EML File Content (RFC 822 / MIME) for a specified Message Id / mailbox / folder.

Parameters

You can provide the following parameters to this action:

  • MessageId
  • User ID or Email
  • MailFolderId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • MessageId
  • StatusCode
  • Data
  • ErrorMessage
  • UserId
  • MailFolderId

Visit documentation for more information.

Get Messages

Description

Get the mail messages for the specified user ID or email address.

Parameters

You can provide the following parameters to this action:

  • User ID or Email
  • Email Body Format
  • Search Criteria
  • MailFolderId
  • Order By
  • Page Size
  • Selected Columns

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • ReceivedDateTime
  • HasAttachments
  • Subject
  • BodyPreview
  • SenderEmailAddressName
  • SenderEmailAddress
  • Importance
  • SentDateTime
  • CreatedDateTime
  • LastModifiedDateTime
  • ChangeKey
  • ToRecipients
  • CcRecipients
  • BccRecipients
  • ToRecipient1
  • ToRecipient2
  • ToRecipient3
  • ToRecipient4
  • ToRecipient5
  • CcRecipient1
  • CcRecipient2
  • CcRecipient3
  • CcRecipient4
  • CcRecipient5
  • BccRecipient1
  • BccRecipient2
  • BccRecipient3
  • BccRecipient4
  • BccRecipient5
  • Categories
  • ParentFolderId
  • ConversationId
  • ConversationIndex
  • IsDeliveryReceiptRequested
  • IsReadReceiptRequested
  • IsRead
  • IsDraft
  • WebLink
  • InferenceClassification
  • InternetMessageHeaders
  • BodyContentType
  • BodyContent
  • FromEmailAddressName
  • FromEmailAddress
  • ReplyTo
  • UniqueBodyContentType
  • UniqueBodyContent
  • FlagFlagStatus
  • ODataETag
  • InternetMessageId

Visit documentation for more information.

Get Messages by Search Filters - Output binary data (EML RFC 822 / MIME)

Description

Gets multiple messages as *.EML Binary Content (RFC 822 / MIME) for a specified search condition / mailbox / folder.

Parameters

You can provide the following parameters to this action:

  • User ID or Email
  • Email Body Format
  • MailFolderId
  • Search Criteria
  • Order By
  • Page Size
  • Selected Columns

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • MessageId
  • Data
  • StatusCode
  • ErrorMessage
  • UserId
  • MailFolderId
  • ODataETag
  • Categories
  • ParentFolderId
  • ConversationId
  • ConversationIndex
  • IsDeliveryReceiptRequested
  • IsReadReceiptRequested
  • IsRead
  • IsDraft
  • WebLink
  • InferenceClassification
  • InternetMessageHeaders
  • BodyContentType
  • BccRecipient5
  • FromEmailAddressName
  • FromEmailAddress
  • ReplyTo
  • UniqueBodyContentType
  • UniqueBodyContent
  • FlagFlagStatus
  • InternetMessageId
  • BodyContent
  • BccRecipient4
  • BccRecipient2
  • HasAttachments
  • Subject
  • BodyPreview
  • SenderEmailAddressName
  • SenderEmailAddress
  • Importance
  • SentDateTime
  • CreatedDateTime
  • LastModifiedDateTime
  • ChangeKey
  • ToRecipients
  • BccRecipient3
  • CcRecipients
  • ToRecipient1
  • ToRecipient2
  • ToRecipient3
  • ToRecipient4
  • ToRecipient5
  • CcRecipient1
  • CcRecipient2
  • CcRecipient3
  • CcRecipient4
  • CcRecipient5
  • BccRecipient1
  • BccRecipients
  • ReceivedDateTime

Visit documentation for more information.

Get My Information

Description

Get general information about the current user.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • DisplayName
  • GivenName
  • SurName
  • JobTitle
  • Mail
  • UserPrincipalName
  • BusinessPhones
  • MobilePhone
  • OfficeLocation
  • PreferredLanguage
  • @OdataContext

Visit documentation for more information.

Get My Mail Folders [only works with User Credentials]

Description

Get the list of mail folders for the current user.

Parameters

You can provide the following parameters to this action:

  • Order By
  • Search Criteria
  • Page Size
  • Selected Columns

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • DisplayName
  • ParentFolderId
  • ChildFolderCount
  • UnreadItemCount
  • TotalItemCount
  • SizeInBytes
  • IsHidden

Visit documentation for more information.

Get My Message by Id [only works with User Credentials]

Description

Get the mail message by message Id for the specified user ID or email address.

Parameters

You can provide the following parameters to this action:

  • Message Id
  • Email Body Format
  • Selected Columns

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • ReceivedDateTime
  • HasAttachments
  • Subject
  • BodyPreview
  • SenderEmailAddressName
  • SenderEmailAddress
  • Importance
  • SentDateTime
  • CreatedDateTime
  • LastModifiedDateTime
  • ChangeKey
  • ToRecipients
  • CcRecipients
  • BccRecipients
  • ToRecipient1
  • ToRecipient2
  • ToRecipient3
  • ToRecipient4
  • ToRecipient5
  • CcRecipient1
  • CcRecipient2
  • CcRecipient3
  • CcRecipient4
  • CcRecipient5
  • BccRecipient1
  • BccRecipient2
  • BccRecipient3
  • BccRecipient4
  • BccRecipient5
  • Categories
  • ParentFolderId
  • ConversationId
  • ConversationIndex
  • IsDeliveryReceiptRequested
  • IsReadReceiptRequested
  • IsRead
  • IsDraft
  • WebLink
  • InferenceClassification
  • InternetMessageHeaders
  • BodyContentType
  • BodyContent
  • FromEmailAddressName
  • FromEmailAddress
  • ReplyTo
  • UniqueBodyContentType
  • UniqueBodyContent
  • FlagFlagStatus
  • ODataETag
  • InternetMessageId

Visit documentation for more information.

Get My Messages [only works with User Credentials]

Description

Get the mail messages for the current user.

Parameters

You can provide the following parameters to this action:

  • Email Body Format
  • Search Criteria
  • MailFolderId
  • Order By
  • Page Size
  • Selected Columns

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • ReceivedDateTime
  • HasAttachments
  • Subject
  • BodyPreview
  • SenderEmailAddressName
  • SenderEmailAddress
  • Importance
  • SentDateTime
  • CreatedDateTime
  • LastModifiedDateTime
  • ChangeKey
  • ToRecipients
  • CcRecipients
  • BccRecipients
  • ToRecipient1
  • ToRecipient2
  • ToRecipient3
  • ToRecipient4
  • ToRecipient5
  • CcRecipient1
  • CcRecipient2
  • CcRecipient3
  • CcRecipient4
  • CcRecipient5
  • BccRecipient1
  • BccRecipient2
  • BccRecipient3
  • BccRecipient4
  • BccRecipient5
  • Categories
  • ParentFolderId
  • ConversationId
  • ConversationIndex
  • IsDeliveryReceiptRequested
  • IsReadReceiptRequested
  • IsRead
  • IsDraft
  • WebLink
  • InferenceClassification
  • InternetMessageHeaders
  • BodyContentType
  • BodyContent
  • FromEmailAddressName
  • FromEmailAddress
  • ReplyTo
  • UniqueBodyContentType
  • UniqueBodyContent
  • FlagFlagStatus
  • ODataETag
  • InternetMessageId

Visit documentation for more information.

Get Table Columns

Description

Get table list and its properties for Graph API.

Parameters

You can provide the following parameters to this action:

  • Table Name

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • EntityName
  • BaseType
  • Name
  • Type
  • Nullable

Visit documentation for more information.

Get Tables

Description

Get table list and its properties for Graph API.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • BaseType

Visit documentation for more information.

Get User by Id

Description

Get a specific user.

Parameters

You can provide the following parameters to this action:

  • User ID or Email
  • Selected Columns

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • BusinessPhones
  • DisplayName
  • GivenName
  • JobTitle
  • Mail
  • MobilePhone
  • OfficeLocation
  • PreferredLanguage
  • SurName
  • UserPrincipalName
  • Id

Visit documentation for more information.

Get Users

Description

Get the list of users.

Parameters

You can provide the following parameters to this action:

  • Order By
  • Search Criteria
  • Page Size
  • Selected Columns

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • BusinessPhones
  • DisplayName
  • GivenName
  • JobTitle
  • Mail
  • MobilePhone
  • OfficeLocation
  • PreferredLanguage
  • SurName
  • UserPrincipalName
  • Id

Visit documentation for more information.

Send Mail

Description

Sends an email message.

Parameters

You can provide the following parameters to this action:

  • User ID or Email

Input Fields

You can provide the following fields to this action:

  • Subject
  • BodyContentType
  • BodyContent
  • ToRecipients
  • CcRecipients
  • BccRecipients
  • InternetMessageHeaders
  • Attachments
  • Importance
  • IsDeliveryReceiptRequested
  • IsReadReceiptRequested
  • SaveToSentItems

Output Fields

The following fields are returned after calling this action:

  • Id
  • Response

Visit documentation for more information.

Make Generic API Request

Description

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • HTTP - Url or File Path
  • HTTP - Request Body
  • HTTP - Is MultiPart Body (Pass File data/Mixed Key/value)
  • HTTP - Headers (e.g. hdr1:aaa || hdr2:bbb)
  • Parser - Filter (e.g. $.rows[*] )
  • Download - Enable reading binary data
  • Download - File overwrite mode
  • Download - Save file path
  • Download - Enable raw output mode as single row
  • Download - Raw output data RowTemplate
  • Download - Request Timeout (Milliseconds)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic API Request (Bulk Write)

Description

This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Download for SSIS Download for SQL Server and ODBC