CData Python Connector for Microsoft Exchange

Build 25.0.9454

Outbox

Temporarily stores outgoing email messages pending delivery. The items in this table can be created, reviewed, or deleted before transmission is completed.

Table Specific Information

Select Emails from Outbox Subfolders

When performing a SELECT operation on the Outbox table, the connector will not include the items in the subfolders under Outbox, but only the items contained within the Outbox folder. If you wish to retrieve the items under the Outbox subfolders, your will need to specify the ParentFolderId-s in the WHERE clause. You can get every Outbox subfolder Id by executing a filtered by ParentFolderName query to the Folders table. You can use the example query below, to retrieve the items within the Outbox subfolders:

SELECT * FROM Outbox WHERE ParentFolderId IN (SELECT FolderId FROM Folders WHERE ParentFolderName = 'Outbox' AND TotalCount > 0)

Update and Delete

The connector will need the ItemChangeKey to update or delete an item. However, if you are unsure of the ItemChangeKey, the connector is able to retrieve it from the Exchange server automatically. Note that this may increase the time it takes to perform a query.

Columns

Name Type ReadOnly Description
ItemId [KEY] String True

Stores the globally unique identifier assigned to an individual item within the Exchange store. This ID allows the item to be retrieved, modified, or referenced in programmatic operations.

MimeContent String True

Contains the original MIME content of the email item, including headers and body, encoded in Base64. This field preserves the raw message structure for transport or forensic analysis.

ItemChangeKey String True

Represents a version-specific key for the item that changes whenever the item is modified. It is used to detect and resolve concurrency conflicts in synchronization or update scenarios.

ParentFolderId String False

Identifies the folder that directly contains the item. This ID links the item to its hierarchical position in the mailbox folder structure.

ParentFolderChangeKey String True

Indicates the change key for the folder that contains the item. It is used to track folder-level updates for synchronization purposes.

ItemClass String False

Defines the message class of the item, such as IPM.Note for emails or IPM.Appointment for calendar entries. Determines how Exchange and Outlook interpret and render the item.

Subject String False

Specifies the subject line of the message or item. This is typically a short summary or title, limited to 255 characters, displayed prominently in email clients.

Sensitivity String True

Indicates the sensitivity level assigned to the item, such as Normal, Personal, Private, or Confidential. This helps clients determine how to display or restrict access to the item.

Body String False

Contains the main message body text of the item, including any formatting or markup. This can include HTML or plain text depending on how the message was composed.

DateTimeReceived Datetime True

Captures the exact timestamp of when the item was received by the Exchange server. Useful for sorting, filtering, or time-based analytics.

Size Integer True

Reflects the total size of the item in bytes, including headers, body, and attachments. This field is read-only and supports mailbox quota enforcement.

Categories String False

Lists one or more categories assigned to the item, represented as a collection of strings. Categories help users group and color-code items for organizational purposes.

Importance String False

Denotes the sender-assigned importance level of the item, typically Low, Normal, or High. Clients often use this to visually prioritize items in the UI.

InReplyTo String False

Holds the ID of the message to which this item is replying. This helps clients thread conversations by linking related messages.

IsSubmitted Boolean True

Indicates whether the item has been submitted to the Outbox folder for delivery. True if the item is in the process of being sent, false otherwise.

IsDraft Boolean True

Specifies whether the item is currently a draft. A value of true means the message has not been finalized or sent.

IsFromMe Boolean True

Indicates whether the item was sent by the mailbox owner to themselves. Helps distinguish internal copies or reminders.

IsResend Boolean True

Identifies whether the item is a re-sent version of a previously sent message. Useful for tracking resend scenarios or message retries.

IsUnmodified Boolean True

States whether the item remains unchanged from its original saved version. A value of true indicates no edits or updates have been made.

InternetMessageHeaders String True

Contains the full set of Internet message headers associated with the email item, including standard headers such as From, To, Subject, and custom headers that provide metadata about the message routing and transmission.

DateTimeSent Datetime True

Indicates the precise date and time when the email message was successfully sent from the sender's mailbox. This timestamp is typically recorded by the Exchange server.

DateTimeCreated Datetime True

Records the exact date and time when the email item was initially created in the mailbox, whether as a draft or during composition.

ReminderDueBy Datetime False

Specifies the exact time an associated reminder is due to trigger. This value is used in conjunction with the reminder lead time to calculate the notification schedule for calendar or task items.

ReminderIsSet Boolean False

Specifies whether a reminder has been explicitly enabled for the email or calendar item. A value of true means a reminder is configured to alert the user.

ReminderMinutesBeforeStart Integer False

Defines the number of minutes before the scheduled event or due time that a reminder alert is set to appear, helping users anticipate upcoming appointments or deadlines.

DisplayCc String True

Displays a comma-separated list of display names for recipients included in the Cc (carbon copy) field. This is a user-readable string shown in the email header.

DisplayTo String True

Displays a comma-separated list of display names for recipients included in the To field of the message. This field provides a readable summary of primary recipients.

HasAttachments Boolean True

Indicates whether the item includes one or more file attachments. This value is true if any type of attachment—such as documents, images, or embedded items—is present.

Culture String False

Specifies the culture setting (language and regional format) applied to the item. Common values include en-US for English (United States) or fr-FR for French (France), influencing date formats, time zones, and other locale-specific behaviors.

SenderName String False

Contains the display name of the individual or mailbox that sent the message. This name typically corresponds to the full name associated with the sender's account.

SenderEmailAddress String False

Stores the SMTP email address of the sender. This is the actual routing address used for message delivery, such as [email protected].

SenderRoutingType String False

Specifies the routing protocol used to identify the sender's mailbox. Common values include SMTP (Simple Mail Transfer Protocol) and X.400. This determines how the sender's address is interpreted and processed during message delivery.

ToRecipients_Name String False

Represents the display name of each primary recipient in the 'To' field of the outgoing message. This name is typically visible to all recipients and reflects the address book entry or manually entered name.

ToRecipients_EmailAddress String False

Provides the SMTP (Simple Mail Transfer Protocol) address associated with each recipient listed in the 'To' field of the message. This is the actual delivery address used for routing the email.

ToRecipients_ItemId String False

Contains the unique item identifier assigned to each 'To' recipient entry. This ID is used internally by the system to reference the recipient object within the Exchange store.

CcRecipients_Name String False

Indicates the display name of each recipient included in the 'Cc' (carbon copy) field of the message. These recipients receive a visible copy of the message without being the primary audience.

CcRecipients_EmailAddress String False

Stores the SMTP address for each recipient listed in the 'Cc' field of the email message. This is the address used to deliver the message copy to secondary recipients.

CcRecipients_ItemId String False

Identifies each 'Cc' recipient using a unique item ID within the Exchange system. This identifier facilitates recipient tracking and message linkage within the store.

BccRecipients_Name String False

Captures the display name of each recipient included in the 'Bcc' (blind carbon copy) field. Bcc recipients receive a copy of the message without being visible to other recipients.

BccRecipients_EmailAddress String False

Holds the SMTP address of each recipient in the 'Bcc' field of the email message. This address is used for hidden delivery, meaning other recipients are unaware of the Bcc addresses.

BccRecipients_ItemId String False

Holds the unique identifier for each recipient included in the Bcc (blind carbon copy) field of the message. This allows for tracking or querying of Bcc recipients associated with a specific item.

IsReadReceiptRequested Boolean False

Indicates whether the sender has requested a read receipt notification for the message. A read receipt alerts the sender when the recipient has opened the message.

IsDeliveryReceiptRequested Boolean False

Indicates whether the sender has requested a delivery receipt for the message. A delivery receipt confirms the message has been successfully delivered to the recipient's email server.

ConversationIndex String False

Stores a binary-formatted string that helps preserve the order and hierarchy of messages in a conversation thread. It is used by clients to visually group related messages.

ConversationTopic String False

Contains the subject or main topic used to group messages into a conversation thread. Typically derived from the original message subject and used for organizing related communications.

FromName String False

Specifies the display name of the sender as it appears in the From field of the message. This can differ from the sender's email address or user ID.

FromEmailAddress String False

Provides the sender's email address in Simple Mail Transfer Protocol (SMTP) format, as listed in the From field of the message.

FromRoutingType String False

Indicates the routing protocol used for the From mailbox, such as SMTP, EX, or X400. The default and most common value is SMTP.

InternetMessageId String False

Contains the globally unique Internet message identifier assigned to the email. This identifier is used to track and correlate messages across systems.

IsRead Boolean False

Specifies whether the message has been marked as read by the recipient. This status is typically managed by the mail client and reflects user interaction.

IsResponseRequested Boolean False

Specifies whether the sender of the message has requested a response from recipients. This flag is typically used to determine if the message is a meeting request, voting option, or other actionable item that expects feedback.

References String False

Contains the value of the 'References' Internet message header, which is used by messaging systems to group replies with the original message for conversation threading and context.

EffectiveRights_CreateAssociated Boolean True

Indicates whether the current user has the permission to create associated items within a folder. Associated items are typically hidden metadata used for custom forms or settings.

EffectiveRights_CreateContents Boolean True

Indicates whether the current user has the permission to create new items, such as messages or calendar entries, within the contents of a folder.

EffectiveRights_CreateHierarchy Boolean True

Indicates whether the current user has the permission to create subfolders under the current folder, thereby altering the folder hierarchy.

EffectiveRights_Delete Boolean True

Specifies whether the user has delete permissions on the folder or item. This includes both hard and soft deletions, depending on system configuration and user role.

EffectiveRights_Modify Boolean True

Denotes whether the user has permissions to modify the content or properties of the folder or item, including renaming or updating metadata.

EffectiveRights_Read Boolean True

Specifies whether the user has read access to the folder or item. This permission allows the user to view contents but not modify them.

EffectiveRights_ViewPrivateItems Boolean True

Indicates whether the user is allowed to view items marked as private within a folder. This is typically reserved for users with delegate or administrative access.

ReceivedByName String False

Represents the display name of the mailbox user on whose behalf the message was received. This is commonly used in delegated scenarios where a message is received by someone acting on behalf of another.

ReceivedByEmailAddress String False

Specifies the SMTP (Simple Mail Transfer Protocol) address of the mailbox user who ultimately received the message. This helps identify the final recipient in email routing scenarios.

ReceivedByRoutingType String False

Indicates the routing protocol used to deliver the message to the ReceivedBy mailbox. Common values include SMTP, which is the default method for email transmission.

ReceivedRepresentingName String False

Displays the full name of the user on whose behalf the message was received. This is used in delegated or shared mailbox scenarios where a user receives mail representing another.

ReceivedRepresentingEmailAddress String False

Provides the SMTP address of the user for whom the message was received. This is typically used in delegate access configurations.

ReceivedRepresentingRoutingType String False

Indicates the routing protocol (such as SMTP) used for the ReceivedRepresenting mailbox. This helps in correctly identifying the transport method used in delegated receipt cases.

LastModifiedName String True

Shows the display name of the last user who made a change to the item. Useful for auditing and change tracking.

LastModifiedTime Datetime True

Captures the timestamp of the most recent modification made to the item. This value is system-generated and read-only.

IsAssociated Boolean False

Specifies whether the item is an associated item, meaning it is linked to a folder but not visible in the standard folder item view. Associated items typically include hidden metadata or configuration elements.

WebClientReadFormQueryString String True

Provides a query string to append to the Outlook Web App endpoint URL to open the item in read-only mode. This enables direct linking to items for viewing in a browser.

WebClientEditFormQueryString String True

Provides a query string to append to the Outlook Web App endpoint URL to open the item in edit mode. This is used to launch the item for editing in a web browser session.

ConversationId String True

Uniquely identifies a conversation thread in the Exchange store, allowing grouping of related messages under a single conversation ID.

ConversationChangeKey String True

Stores the versioning change key for the conversation or item. This is used internally by Exchange to detect updates or conflicts when synchronizing data.

UniqueBody String True

Represents the portion of the email body that is unique to this message within the conversation thread. This is typically the content authored by the sender, excluding quoted replies or forwards from previous messages. It can be in either HTML or plain-text format.

UniqueBodyType String True

Specifies the format in which the unique body content is stored for this item. Accepted values are 'HTML' and 'TEXT', indicating whether the unique body is rendered as rich HTML content or as plain text.

ReminderMessageData_Text String False

Defines the custom text displayed in the reminder pop-up or notification associated with a calendar event, task, or flagged email. This field is often used to convey critical instructions or notes to the recipient.

ReminderMessageData_Location String False

Identifies the physical or virtual location linked to a calendar-based item such as a meeting or appointment. It can include room names, addresses, or conference call links, and is intended to guide participants to the correct venue.

ReminderMessageData_StartTime Datetime False

Indicates the scheduled start time of the item that triggered the reminder, typically associated with a meeting, appointment, or flagged message. The time is stored in datetime format to support precise scheduling.

ReminderMessageData_EndTime Datetime False

Indicates the scheduled end time of the item tied to the reminder. It is relevant for events and tasks that have a defined duration and is used for tracking and scheduling purposes.

ReminderMessageData_AssociatedCalendarId String True

Stores the unique identifier of the calendar event that the reminder message data refers to. This ID allows systems to locate and manage the corresponding calendar item across different Exchange entities.

Attachments String True

Contains a comma-separated list of the identifiers (IDs) for any files or objects attached to the message. Each ID references a specific attachment stored in the Exchange system. The format for the list is ID1, ID2, ID3, ...

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ImpersonationUser String

Indicates the identifier of the user account being impersonated when accessing mailbox items through delegated access. This allows administrative or service-level accounts to act on behalf of a specified user.

ImpersonationType String

Specifies the format used to identify the impersonated user. Supported values include PrincipalName, SID, PrimarySmtpAddress, and SmtpAddress, each representing a different identifier type within Exchange or Active Directory.

SharedMailboxEmail String

Specifies the email address of a shared mailbox whose outbox items are being accessed. This is useful when retrieving sent items that originate from a shared resource rather than an individual user account.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454