Drafts

Holds unsent email drafts. This enables operations to create new drafts, update draft content, delete drafts, or retrieve draft messages for review or sending.

Table Specific Information

Select Emails from Drafts Subfolders

When performing a SELECT operation on the Drafts table, the driver will not include the items in the subfolders under Drafts, but only the items contained within the Drafts folder. If you wish to retrieve the items under the Drafts subfolders, your will need to specify the ParentFolderId-s in the WHERE clause. You can get every Drafts 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 Drafts subfolders:

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

Update and Delete

The driver will need the ItemChangeKey to update or delete an item. However, if you are unsure of the ItemChangeKey, the driver 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 each item within the Exchange store. This value is essential for referencing or manipulating the item programmatically.
MimeContent	String	True	Contains the original MIME-encoded message content, represented in Base64 binary format. This stream includes headers and body content in its raw email format.
ItemChangeKey	String	True	Holds a unique version key that changes whenever the associated item is updated. This key supports synchronization and conflict resolution in Exchange.
ParentFolderId	String	False	References the unique identifier of the folder that contains the item, enabling hierarchical organization and navigation within the mailbox structure.
ParentFolderChangeKey	String	True	Captures the version key of the parent folder, used to track folder-level changes such as renaming or moving items within Exchange.
ItemClass	String	False	Defines the message class of the item, which determines its type and behavior (such as IPM.Note for email or IPM.Appointment for calendar events).
Subject	String	False	Specifies the subject line or title of the item. This value is prominently displayed in item previews and is restricted to a maximum of 255 characters.
Sensitivity	String	True	Indicates how confidential the item is, with possible values including Normal, Personal, Private, and Confidential. This property helps manage visibility and access.
Body	String	False	Contains the main content or body of the message in either plain text or HTML format, representing the actual message text authored by the sender.
DateTimeReceived	Datetime	True	Captures the precise date and time when the item was received by the mailbox. This timestamp is automatically generated and cannot be edited.
Size	Integer	True	Reflects the total size of the item in bytes, including attachments, body content, and metadata. This is a read-only value used for storage management.
Categories	String	False	Stores a comma-separated list of user-defined category labels that help classify or tag items for searching and filtering within the mailbox.
Importance	String	False	Specifies the level of importance assigned to the item, such as Low, Normal, or High, which can influence how the item is displayed or treated by clients.
InReplyTo	String	False	References the message identifier of the original item that this one replies to, enabling clients to maintain conversation threading.
IsSubmitted	Boolean	True	Indicates whether the item has been submitted to the Outbox and is ready to be sent. This flag helps determine message status within the send workflow.
IsDraft	Boolean	True	Identifies whether the item is still in draft status, meaning it has been created or edited but has not yet been sent or submitted.
IsFromMe	Boolean	True	Flags items that were sent by the mailbox owner to themselves, often used for reminders or self-referenced notes.
IsResend	Boolean	True	Indicates that the current item is a resend of a previously sent message, typically generated by choosing the 'Resend This Message' option.
IsUnmodified	Boolean	True	Shows whether the item has remained unchanged since it was last saved or submitted. This is useful for detecting edits or tampering.
InternetMessageHeaders	String	True	Contains all the Internet message headers for the item, including metadata such as Received, From, Subject, Date, MIME-Version, and Content-Type. Useful for tracing the route and processing of an email item through various mail servers.
DateTimeSent	Datetime	True	Specifies the exact date and time the draft message was sent from the sender's mailbox. This value is set once the item transitions from draft to sent status.
DateTimeCreated	Datetime	True	Indicates the date and time when the draft message was initially created in the mailbox, regardless of whether it has been sent or modified afterward.
ReminderDueBy	Datetime	False	Denotes the date and time at which a reminder for the draft item is scheduled to trigger. This timestamp works in conjunction with ReminderMinutesBeforeStart to alert users about the item in advance.
ReminderIsSet	Boolean	False	A Boolean flag indicating whether a reminder has been configured for the draft message. If true, the system will attempt to notify the user based on the associated reminder settings.
ReminderMinutesBeforeStart	Integer	False	Defines the number of minutes prior to the ReminderDueBy time that the system should trigger a notification. Helps users prepare in advance for time-sensitive messages.
DisplayCc	String	True	Displays a concatenated string of all recipients listed in the Cc (carbon copy) field, formatted for user interfaces. This value is primarily used for display purposes and does not reflect the internal recipient list structure.
DisplayTo	String	True	Displays a concatenated string of all recipients listed in the To field, typically shown in the email client UI. It combines the display names of recipients in a user-friendly format.
HasAttachments	Boolean	True	Indicates whether the draft message includes one or more file attachments. A value of true suggests that the item contains content beyond text or metadata.
Culture	String	False	Represents the culture or locale setting (such as en-US, fr-FR) associated with the item. This value influences formatting of dates, times, language, and possibly spell-check settings within the message.
SenderName	String	False	Specifies the display name of the user who composed or sent the draft message. This name appears in the From field of the draft and is typically the full name associated with the sender's mailbox account.
SenderEmailAddress	String	False	Provides the Simple Mail Transfer Protocol (SMTP) email address associated with the sender of the draft message. This is the actual email address used for message routing and delivery.
SenderRoutingType	String	False	Indicates the messaging protocol or routing type used for the sender's address. Common values include SMTP for standard email delivery or EX for Exchange-specific addresses. The default routing type is SMTP.
ToRecipients_Name	String	False	Captures the display name of each primary recipient listed in the 'To' field of the draft message. This name is typically derived from the recipient's user profile or contact information.
ToRecipients_EmailAddress	String	False	Contains the SMTP email address of each recipient listed in the 'To' field of the draft message. This address is used by Exchange to route the message to the correct mailbox.
ToRecipients_ItemId	String	False	Stores the internal Exchange identifier for each recipient listed in the 'To' field. This ID is used to reference recipient metadata or related message history within the Exchange system.
CcRecipients_Name	String	False	Stores the display name of each recipient listed in the 'Cc' (Carbon Copy) field of the draft message. These recipients are secondary recipients who are notified but not expected to respond.
CcRecipients_EmailAddress	String	False	Provides the SMTP email address of each recipient listed in the 'Cc' field. These addresses are included in the draft message for informational purposes.
CcRecipients_ItemId	String	False	Holds the Exchange-specific item identifier for each recipient in the 'Cc' field. This ID links the recipient to internal Exchange metadata or conversation threads.
BccRecipients_Name	String	False	Represents the display name of each recipient listed in the 'Bcc' (Blind Carbon Copy) field. These recipients receive the message without being visible to other recipients.
BccRecipients_EmailAddress	String	False	Specifies the email address of a recipient who is blind carbon copied (Bcc) on the message. This address uses the Simple Mail Transfer Protocol (SMTP) format and is not visible to other recipients.
BccRecipients_ItemId	String	False	Stores the unique identifier assigned to the Bcc recipient entry. This identifier is used to associate the recipient with the message within the Exchange store.
IsReadReceiptRequested	Boolean	False	Indicates whether the sender has requested a read receipt notification, which alerts the sender when the recipient opens or reads the message.
IsDeliveryReceiptRequested	Boolean	False	Indicates whether the sender has requested a delivery receipt, which confirms that the message was successfully delivered to the recipient's mailbox.
ConversationIndex	String	False	Contains a binary-encoded index that identifies the hierarchical relationship of this message within a conversation thread. It is used to group related messages together.
ConversationTopic	String	False	Stores the normalized subject or topic of the conversation thread to which this message belongs. Helps organize and group messages under the same topic.
FromName	String	False	Displays the display name of the sender, as shown in the 'From' field of the message. This is typically the name associated with the sender's mailbox account.
FromEmailAddress	String	False	Holds the SMTP email address of the user who sent the message. This is the address that appears in the 'From' field for email clients and servers.
FromRoutingType	String	False	Indicates the routing protocol used for the 'From' address. Common values include SMTP for internet mail or EX for Exchange-based addresses. The default routing type is SMTP.
InternetMessageId	String	False	Contains the globally unique identifier assigned to the message by the sending email system. This identifier is typically used for message tracking and threading across systems.
IsRead	Boolean	False	Indicates whether the recipient has marked the message as read. This property is updated based on user actions in their email client.
IsResponseRequested	Boolean	False	Specifies whether a response is explicitly requested from the recipient. This flag is typically used for meeting requests or messages that require user acknowledgment or action.
References	String	False	Contains the value of the 'References' header in a message, used to link related messages in a conversation or thread, commonly seen in email clients and Usenet discussions.
EffectiveRights_CreateAssociated	Boolean	True	Indicates whether the current user or client application has permission to create associated items within the folder, such as hidden items used for storing metadata or settings.
EffectiveRights_CreateContents	Boolean	True	Indicates whether the user or application is authorized to create regular content items—such as emails or calendar events—within the folder.
EffectiveRights_CreateHierarchy	Boolean	True	Indicates whether the client has the right to create subfolders or child folders under the current folder, which contributes to building a folder hierarchy structure.
EffectiveRights_Delete	Boolean	True	Specifies whether the user or client is permitted to delete items or folders, depending on the current permissions and the type of item being accessed.
EffectiveRights_Modify	Boolean	True	Specifies whether the client has permission to change properties or content of a folder or item, such as modifying a message body or updating folder attributes.
EffectiveRights_Read	Boolean	True	Indicates whether the current client or user has read access to the folder or item, allowing viewing of its content and metadata.
EffectiveRights_ViewPrivateItems	Boolean	True	Determines whether the user or client is allowed to view items marked as private, such as confidential calendar appointments or messages that have restricted visibility.
ReceivedByName	String	False	Captures the display name of the user who received the message, typically as part of message delivery metadata in Exchange mail flow.
ReceivedByEmailAddress	String	False	Specifies the Simple Mail Transfer Protocol (SMTP) email address of the mailbox user who physically received the item. This field is useful for identifying the actual recipient when messages are sent on behalf of another user or redirected.
ReceivedByRoutingType	String	False	Indicates the routing protocol used for message delivery to the ReceivedBy user. Typical values include SMTP for internet-based email, but other routing types can apply in hybrid or legacy configurations.
ReceivedRepresentingName	String	False	Displays the full display name of the user on whose behalf the message was received. This is typically used when one user receives a message on behalf of another, such as in delegated access scenarios.
ReceivedRepresentingEmailAddress	String	False	Specifies the SMTP email address of the user represented by the ReceivedRepresentingName field. This identifies the mailbox that was logically the intended recipient in cases of delegation or representation.
ReceivedRepresentingRoutingType	String	False	Identifies the routing protocol used for the ReceivedRepresenting user. While the default is SMTP, this field accommodates other routing systems in Exchange hybrid deployments or legacy systems.
LastModifiedName	String	True	Contains the display name of the user who last modified the item, such as a draft or message. This is helpful for tracking changes in collaborative mailbox environments.
LastModifiedTime	Datetime	True	Records the timestamp of the last modification made to the item. This read-only field is useful for auditing, synchronization, and understanding the edit history of a message or draft.
IsAssociated	Boolean	False	Indicates whether the item is associated with a folder as a non-standard message class, such as hidden messages used for folder configuration or rules metadata. A value of true denotes a system or folder-level association.
WebClientReadFormQueryString	String	True	Provides a query string segment that, when appended to the Outlook Web App (OWA) base URL, constructs a complete link to open and read the item directly in a browser-based email client.
WebClientEditFormQueryString	String	True	Provides a query string segment that, when appended to the Outlook Web App (OWA) base URL, enables users to open and edit the item through the web interface, facilitating quick message updates.
ConversationId	String	True	Represents the unique identifier assigned to a conversation thread within the Exchange store. This ID groups related messages across folders and users, allowing coherent tracking of multi-message discussions.
ConversationChangeKey	String	True	Stores the unique change key for the conversation or item, which is used to track the version of the object within Exchange and to ensure concurrency control when updating it.
UniqueBody	String	True	Represents the portion of the message body that is unique to this item, excluding content quoted from previous messages. This content can be formatted as HTML or plain text depending on the UniqueBodyType.
UniqueBodyType	String	True	Indicates the format used to store the unique body content. Possible values include HTML and TEXT, which determine how the UniqueBody field is interpreted.
ReminderMessageData_Text	String	False	Holds the custom reminder text that is shown to users when a reminder alert is triggered for an associated calendar item or meeting.
ReminderMessageData_Location	String	False	Specifies the physical or virtual location where the calendar event, meeting, or associated item will occur, as displayed in the user's calendar view.
ReminderMessageData_StartTime	Datetime	False	Defines the scheduled start time for the calendar item, meeting, or event associated with the reminder message, using the datetime format.
ReminderMessageData_EndTime	Datetime	False	Defines the scheduled end time for the calendar item, meeting, or event associated with the reminder message, using the datetime format.
ReminderMessageData_AssociatedCalendarId	String	True	Contains the unique identifier of the calendar item that the reminder message refers to. This helps in correlating the reminder with the original calendar event.
Attachments	String	True	Lists the identifiers of files attached to the item, separated by commas. Each ID corresponds to a file stored with the item in Exchange, such as, 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.