CData Python Connector for Office 365 2019 - Online Help
Questions / Feedback?

Messages

CData Python Connector for Office 365 2019 - Build 19.0.7416

The Office365 table Messages.

Table Specific Information

Select

You can retrieve all from Messages, specify a Message (Id), UserId, or ParentFolderId, or you can filter results by a certain column:

SELECT * FROM Messages
SELECT * FROM Messages WHERE Id = 'MyMessageId'

SELECT * FROM Messages WHERE UserId = 'MyUserId'

SELECT * FROM Messages WHERE ParentFolderId = 'MyParentfolderId' 
SELECT * FROM Messages WHERE ParentFolderId = 'Drafts'
SELECT DisplayName, Id FROM Users WHERE DisplayName LIKE 'John%'

Insert

After the insert a new Message will be created in the User's Drafts folder.

INSERT INTO Messages (Subject, Body_Content, UserId) VALUES ('New test Email', 'Test Email created.', 'User Id goes here')

Note: To send the mail, see SendMail.

Columns

Name Type ReadOnly References Description
id [KEY] String True

The id column of the Messages table.

categories String False

The categories column of the Messages table.

changeKey String False

The changeKey column of the Messages table.

createdDateTime Datetime False

The createdDateTime column of the Messages table.

lastModifiedDateTime Datetime False

The lastModifiedDateTime column of the Messages table.

bccRecipients String False

The bccRecipients column of the Messages table.

body_contentType String False

The body_contentType column of the Messages table.

body_content String False

The body_content column of the Messages table.

bodyPreview String False

The bodyPreview column of the Messages table.

ccRecipients String False

The ccRecipients column of the Messages table.

conversationId String False

The conversationId column of the Messages table.

flag_completedDateTime_dateTime String False

The flag_completedDateTime_dateTime column of the Messages table.

flag_completedDateTime_timeZone String False

The flag_completedDateTime_timeZone column of the Messages table.

flag_flagStatus String False

The flag_flagStatus column of the Messages table.

from_emailAddress_name String False

The from_emailAddress_name column of the Messages table.

from_emailAddress_address String False

The from_emailAddress_address column of the Messages table.

hasAttachments Bool False

The hasAttachments column of the Messages table.

importance String False

The importance column of the Messages table.

inferenceClassification String False

The inferenceClassification column of the Messages table.

internetMessageHeaders String False

The internetMessageHeaders column of the Messages table.

internetMessageId String False

The internetMessageId column of the Messages table.

isDeliveryReceiptRequested Bool False

The isDeliveryReceiptRequested column of the Messages table.

isDraft Bool False

The isDraft column of the Messages table.

isRead Bool False

The isRead column of the Messages table.

isReadReceiptRequested Bool False

The isReadReceiptRequested column of the Messages table.

parentFolderId String False

The parentFolderId column of the Messages table.

receivedDateTime Datetime False

The receivedDateTime column of the Messages table.

replyTo String False

The replyTo column of the Messages table.

sender_emailAddress_name String False

The sender_emailAddress_name column of the Messages table.

sender_emailAddress_address String False

The sender_emailAddress_address column of the Messages table.

sentDateTime Datetime False

The sentDateTime column of the Messages table.

subject String False

The subject column of the Messages table.

toRecipients String False

The toRecipients column of the Messages table.

uniqueBody_contentType String False

The uniqueBody_contentType column of the Messages table.

uniqueBody_content String False

The uniqueBody_content column of the Messages table.

webLink String False

The webLink column of the Messages table.

UserId String False

The UserId column of the Messages table.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7416.0