DeletedItems

Represents items moved to the Deleted Items folder, including messages, calendar events, and tasks. It allows recovery, permanent deletion, or inspection of deleted content.

Table Specific Information

Select Emails from DeletedItems Subfolders

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

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

Update and Delete

The component will need the ItemChangeKey to update or delete an item. However, if you are unsure of the ItemChangeKey, the component 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	Provides a unique identifier assigned to each item stored in the Exchange mailbox database. This identifier is used to retrieve or reference the specific item in operations such as queries, updates, or deletes.
MimeContent	String	True	Stores the full MIME content of an email or item, including headers and body, encoded in Base64 format. This representation is commonly used for message transport and interoperability with email systems.
ItemChangeKey	String	True	Tracks the version of an item in the Exchange store. This change key is used to detect modifications and helps ensure that concurrent updates do not conflict.
ParentFolderId	String	False	Holds the unique identifier of the folder that directly contains the current item. This enables hierarchy tracking and folder-based item organization in the mailbox.
ParentFolderChangeKey	String	True	Tracks the version of the parent folder that contains the current item. Useful for detecting folder-level changes that can impact its contents.
ItemClass	String	False	Specifies the message class of the item, which determines its behavior and format. Common classes include IPM.Note for email, IPM.Appointment for calendar events, and others.
Subject	String	False	Captures the subject line or title of the item, visible in message listings and conversation views. The subject text is limited to a maximum of 255 characters.
Sensitivity	String	True	Indicates the sensitivity level assigned to the item, which can include values such as Normal, Personal, Private, or Confidential. This setting can restrict how the item is handled or viewed.
Body	String	False	Contains the main message content of the item, which can be formatted as plain text, HTML, or Rich Text Format (RTF), depending on how the message was composed or received.
DateTimeReceived	Datetime	True	Represents the exact date and time the item was received into the mailbox, based on the server's time zone and configuration. This timestamp is often used for sorting and filtering.
Size	Integer	True	Reflects the total storage size of the item, in bytes, including the message body, attachments, and metadata. This is a read-only value used for quota management and reporting.
Categories	String	False	Lists one or more user-defined category labels associated with the item. These labels, such as Red Category, Project A, or Follow-Up, help users organize and search their mailbox.
Importance	String	False	Denotes the relative urgency or priority of the item. Common values include Low, Normal, and High, influencing how the message appears in the user interface or triggers alerts.
InReplyTo	String	False	Stores the identifier of the item that this message replies to, enabling the reconstruction of message threads and conversations in email clients.
IsSubmitted	Boolean	True	Indicates whether the item has been submitted for delivery and moved to the Outbox. Once submitted, the message enters the transport pipeline for delivery.
IsDraft	Boolean	True	True if the item is in draft status, meaning it is composed but has not yet been sent or submitted. Drafts can be reopened and edited before final delivery.
IsFromMe	Boolean	True	True if the sender of the item is the same as the currently logged-in user, indicating the item was self-addressed or intentionally sent to oneself.
IsResend	Boolean	True	Indicates that the item is a resend of a previously sent message, often used when correcting or updating prior communications.
IsUnmodified	Boolean	True	True if the item remains unchanged since it was created or received. This can be used to detect whether a user or process has edited the item.
InternetMessageHeaders	String	True	Provides a full list of all Internet message headers associated with the item, including technical metadata such as message routing, MIME types, and authentication results. Useful for diagnostics, compliance, and message tracing.
DateTimeSent	Datetime	True	Captures the exact timestamp when the item was sent from the sender's mailbox. This is critical for chronological tracking, delivery auditing, and reporting workflows.
DateTimeCreated	Datetime	True	Represents the date and time when the item was originally generated or saved in the Exchange mailbox, regardless of when it was sent or received. Important for tracking lifecycle events of items.
ReminderDueBy	Datetime	False	Defines the scheduled date and time when a reminder is expected to alert the user. This value is used in conjunction with ReminderMinutesBeforeStart to determine alert timing.
ReminderIsSet	Boolean	False	Indicates whether a reminder is currently enabled for the item. A value of true means a reminder will trigger based on the specified time settings; false means no reminder is set.
ReminderMinutesBeforeStart	Integer	False	Specifies how many minutes prior to the scheduled time of an event the reminder should appear. This value is used to compute the ReminderDueBy time.
DisplayCc	String	True	Contains the concatenated display names of all recipients in the Cc (carbon copy) field. This value is used for rendering recipient information in user interfaces.
DisplayTo	String	True	Contains the concatenated display names of all recipients in the To field. Used for rendering main recipient information in email views or message previews.
HasAttachments	Boolean	True	Indicates whether the item includes one or more file or item attachments. A value of true means at least one attachment is associated with the item.
Culture	String	False	Identifies the locale setting, such as en-US or fr-FR, that influences how the item's date formats, language, and regional settings are displayed or interpreted.
SenderName	String	False	Specifies the display name associated with the sender of the email message. This value typically reflects the full name configured in the sender's mailbox profile.
SenderEmailAddress	String	False	Specifies the sender's primary email address, using the Simple Mail Transfer Protocol (SMTP) format. This address is used to route messages and identify the sender.
SenderRoutingType	String	False	Indicates the protocol or addressing method used to deliver the message from the sender. Common routing types include SMTP, EX (Exchange), and others depending on the mail system.
ToRecipients_Name	String	False	Stores the display name of each recipient listed in the 'To' field of the email message. Multiple entries can be present for messages sent to multiple recipients.
ToRecipients_EmailAddress	String	False	Contains the SMTP email address of each recipient in the 'To' field. This value is used to deliver the message to intended recipients.
ToRecipients_ItemId	String	False	Stores the unique identifier for each 'To' recipient entry. This identifier links to recipient-specific metadata or associated mailbox items.
CcRecipients_Name	String	False	Stores the display name of each recipient included in the 'Cc' (carbon copy) field. These recipients receive a visible copy of the message.
CcRecipients_EmailAddress	String	False	Contains the SMTP email address of each carbon copy recipient. These addresses are used to send copies of the message alongside the main recipients.
CcRecipients_ItemId	String	False	Stores the unique item identifier associated with each carbon copy recipient entry. This can be used to track or reference related metadata.
BccRecipients_Name	String	False	Stores the display name of each recipient listed in the 'Bcc' (blind carbon copy) field. These recipients receive a copy of the message without visibility to others.
BccRecipients_EmailAddress	String	False	Contains the SMTP email address of each blind carbon copy recipient. These addresses remain hidden from other recipients of the message.
BccRecipients_ItemId	String	False	Stores the unique item identifier for each blind carbon copy recipient entry. This can be used to manage or audit invisible recipient delivery.
IsReadReceiptRequested	Boolean	False	Indicates whether the sender has requested a read receipt notification when the recipient opens the message. A value of true prompts the system to send such a notification.
IsDeliveryReceiptRequested	Boolean	False	Indicates whether the sender has requested a delivery receipt notification when the message is successfully delivered to the recipient's server. A value of true enables this feature.
ConversationIndex	String	False	Contains a binary-encoded value that represents the hierarchical position of the message within an email conversation thread. This helps group related messages for conversation views.
ConversationTopic	String	False	Captures the subject or main theme of the conversation thread to which the message belongs, helping to group related messages for easier tracking and categorization.
FromName	String	False	Specifies the display name of the sender whose mailbox initiated the message. This is typically the name shown in the email's From field.
FromEmailAddress	String	False	Contains the SMTP (Simple Mail Transfer Protocol) email address of the sender. This value is used to identify the origin of the message at the protocol level.
FromRoutingType	String	False	Specifies the routing type used for the sender's mailbox. Common values include SMTP for internet email and EX for Exchange routing.
InternetMessageId	String	False	Provides a unique identifier for the message generated by the sending server, used to distinguish the message across servers and trace message threads.
IsRead	Boolean	False	Indicates whether the message has been opened or marked as read by the recipient. This is useful for tracking user engagement with the message.
IsResponseRequested	Boolean	False	Specifies whether a reply is expected or required for the message. This property can influence user prompts or automated workflows.
References	String	False	Holds the Usenet 'References' header, which includes a list of message IDs from previous related messages, allowing threaded message views and response tracking.
EffectiveRights_CreateAssociated	Boolean	True	Determines whether the current user or application has permission to create associated items, which are typically hidden metadata items linked to folders.
EffectiveRights_CreateContents	Boolean	True	Indicates whether the user has the right to create new messages or items within the specified folder.
EffectiveRights_CreateHierarchy	Boolean	True	Specifies whether the user has permission to create subfolders under the current folder, enabling hierarchical organization.
EffectiveRights_Delete	Boolean	True	Defines whether the user can delete the item or folder, reflecting part of the security and access control model.
EffectiveRights_Modify	Boolean	True	Shows whether modifications to the contents or properties of an item or folder are allowed based on current user permissions.
EffectiveRights_Read	Boolean	True	Indicates whether the user has read access to the item or folder. If false, the item or folder contents are restricted.
EffectiveRights_ViewPrivateItems	Boolean	True	Specifies whether private items, such as those marked as confidential or restricted, can be viewed by the current user.
ReceivedByName	String	False	Contains the display name of the user who received the message on behalf of another recipient or mailbox rule, often used in delegate scenarios.
ReceivedByEmailAddress	String	False	Specifies the SMTP email address of the mailbox user who ultimately received the item. This is typically used in scenarios involving delegation or mail forwarding.
ReceivedByRoutingType	String	False	Indicates the routing protocol used for delivering the item to the ReceivedBy user. The default and most common value is SMTP, which stands for Simple Mail Transfer Protocol.
ReceivedRepresentingName	String	False	Contains the display name of the mailbox user on whose behalf the item was received. This is used in delegate or shared mailbox scenarios.
ReceivedRepresentingEmailAddress	String	False	Provides the SMTP email address of the user on whose behalf the message was received. This is commonly seen in delegated access or shared mailbox contexts.
ReceivedRepresentingRoutingType	String	False	Specifies the routing type for the ReceivedRepresenting user. The default value is SMTP, indicating the message was routed via Simple Mail Transfer Protocol.
LastModifiedName	String	True	Contains the display name of the user who last modified the item in the Exchange store. Useful for auditing and change tracking.
LastModifiedTime	Datetime	True	Indicates the exact timestamp when the item was last updated. This is a read-only field commonly used in synchronization or data freshness logic.
IsAssociated	Boolean	False	Indicates whether the item is a special hidden item that is associated with a folder, such as rules or views metadata, rather than a standard visible item like a message or event.
WebClientReadFormQueryString	String	True	Contains a query string fragment to be appended to the Outlook Web App (OWA) URL for rendering the item in read-only mode via a web browser.
WebClientEditFormQueryString	String	True	Contains a query string fragment to be appended to the Outlook Web App (OWA) URL for rendering the item in edit mode, allowing modifications in a browser session.
ConversationId	String	True	Uniquely identifies a conversation thread within the Exchange store. This value can be used to group related messages and items into a single conversation view.
ConversationChangeKey	String	True	Stores the change key associated with the conversation, which is used to detect updates and maintain consistency during synchronization or updates.
UniqueBody	String	True	Represents the portion of the message body that is unique to the current item, excluding content from earlier items in the conversation. It can be in HTML or plain-text format.
UniqueBodyType	String	True	Specifies the format in which the unique body content is stored. Supported values include HTML and TEXT, indicating rich or plain formatting respectively.
ReminderMessageData_Text	String	False	Specifies the notification text for a reminder message. This can include event or task descriptions shown in popup reminders.
ReminderMessageData_Location	String	False	Indicates the physical or virtual location associated with the event, meeting, or appointment tied to the reminder message.
ReminderMessageData_StartTime	Datetime	False	Defines the start time of the calendar item or appointment that triggered the reminder. This is used to align the reminder with the event's beginning.
ReminderMessageData_EndTime	Datetime	False	Defines the end time of the calendar item or appointment associated with the reminder, marking when the event is expected to conclude.
ReminderMessageData_AssociatedCalendarId	String	True	Stores the identifier of the calendar entry associated with the reminder. This ID can be used to look up the full calendar item details.
Attachments	String	True	Contains a comma-separated list of attachment identifiers (Ids) related to the item (for example, 'att001, att002, att003').

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.