Inbox

Contains received email messages directed to the user's inbox. It allows access to individual messages with full Create, Read, Update, and Delete (CRUD) capabilities for inbox content management.

Table Specific Information

Select Emails from Inbox Subfolders

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

SELECT * FROM Inbox WHERE ParentFolderId IN (SELECT FolderId FROM Folders WHERE ParentFolderName = 'Inbox' 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	Provides the globally unique identifier for an item stored in the Exchange mailbox. This ID is used to retrieve or reference the item in API calls and operations.
MimeContent	String	True	Contains the original MIME content of the item, including headers and body, encoded in Base64. This property is essential for interoperability with systems that consume raw email formats.
ItemChangeKey	String	True	Identifies the current state or version of the item. Every time the item is updated, this key changes, enabling concurrency control and synchronization processes.
ParentFolderId	String	False	Holds the unique identifier of the folder that contains this item. This is used to establish the item's location within the mailbox folder hierarchy.
ParentFolderChangeKey	String	True	Represents the change key of the parent folder, used to detect updates to the folder's state or metadata over time.
ItemClass	String	False	Defines the class or type of item, such as IPM.Note for email messages. This value helps applications distinguish between different kinds of Exchange items.
Subject	String	False	Stores the subject line of the message or item. This string is displayed as the title or heading in the user interface and is limited to 255 characters in length.
Sensitivity	String	True	Specifies the sensitivity level assigned to the item, such as Normal, Personal, Private, or Confidential. This influences how the item is displayed or shared with others.
Body	String	False	Contains the main content of the item, typically the message body. This can be plain text or formatted HTML, depending on the message structure.
DateTimeReceived	Datetime	True	Indicates the timestamp when the item was received by the mailbox server. Useful for sorting, filtering, and auditing mailbox content.
Size	Integer	True	Represents the total size of the item, measured in bytes. This includes all headers, body content, and attachments. This field is read-only and reflects the stored size on the server.
Categories	String	False	Lists one or more user-defined categories assigned to the item, separated by commas. These categories help organize or color-code messages within a mailbox.
Importance	String	False	Describes the priority level assigned to the item, such as Low, Normal, or High. This field is typically used by email clients to visually distinguish urgent messages.
InReplyTo	String	False	Holds the identifier of the original message to which this item is a response. Useful for threading messages in a conversation view.
IsSubmitted	Boolean	True	Indicates whether the item has been sent by the sender and submitted to the Outbox folder for delivery processing.
IsDraft	Boolean	True	Identifies whether the item is a draft, meaning it has been composed but not yet sent. Used by email clients to save work-in-progress messages.
IsFromMe	Boolean	True	Specifies whether the current mailbox owner is also the sender of the item. Common in scenarios where users email themselves for reminders or notes.
IsResend	Boolean	True	Indicates that the item has previously been sent and is now being resent. Useful for tracking message resubmissions or forwarding with minimal changes.
IsUnmodified	Boolean	True	Shows whether the item has remained unchanged since it was received or last saved. This is useful for detecting untouched messages.
InternetMessageHeaders	String	True	Contains all Internet message headers associated with the email item, including metadata such as MIME version, content type, encoding, and user agent information. These headers are useful for diagnostics, filtering, and compliance audits.
DateTimeSent	Datetime	True	Specifies the exact date and time the email was sent from the sender's mailbox. This timestamp is critical for chronological sorting, archiving, and determining message latency.
DateTimeCreated	Datetime	True	Captures the timestamp when the item was first created in the Exchange mailbox, which can differ from the send or received time. It is often used for tracking draft creation or initial saves.
ReminderDueBy	Datetime	False	Indicates the scheduled date and time at which a reminder should be triggered for a calendar item, task, or flagged message. It works in conjunction with the ReminderMinutesBeforeStart field to manage notification timing.
ReminderIsSet	Boolean	False	Specifies whether a reminder is configured for the current item. A value of true indicates that the user or system has explicitly set a reminder to alert at a specific time.
ReminderMinutesBeforeStart	Integer	False	Defines how many minutes before the event's start time the reminder will be shown. This setting allows customization of notification lead time for appointments, tasks, or flagged messages.
DisplayCc	String	True	Stores the combined display names of all recipients listed in the Cc (carbon copy) field. This user-facing string is used in the message header for visual representation.
DisplayTo	String	True	Stores the combined display names of all recipients listed in the To field. This string is displayed in the message header to reflect primary recipients.
HasAttachments	Boolean	True	Indicates whether the email item includes one or more file attachments. This field is typically used to filter or flag messages that can contain additional content or documents.
Culture	String	False	Represents the culture or locale associated with the email item, such as 'en-US' for English (United States). This affects formatting of dates, numbers, and localized content.
SenderName	String	False	Contains the full display name of the sender as presented in the email client. This value is often resolved from the directory or contact card and used for UI presentation.
SenderEmailAddress	String	False	Stores the email address of the sender in Simple Mail Transfer Protocol (SMTP) format. This is the primary identifier for the originating mailbox.
SenderRoutingType	String	False	Defines the protocol used to route the sender's address. Common values include SMTP, EX (for Exchange), or X400. This is useful in hybrid or legacy messaging environments.
ToRecipients_Names	String	False	Contains the display names of all recipients listed in the To field. These names are derived from contact records or directory services and used in the email client's UI.
ToRecipients_EmailAddresses	String	False	Lists the SMTP addresses of all To recipients, separated by commas. This is used for routing the message to each intended recipient.
ToRecipients_ItemIds	String	False	Stores the unique Exchange item identifiers associated with each To recipient entry, allowing for referencing and relationship tracking within the mailbox store.
CcRecipients_Names	String	False	Contains the display names of all recipients listed in the Cc (carbon copy) field. These are typically shown in the message header for informational delivery.
CcRecipients_EmailAddresses	String	False	Lists the SMTP addresses of all Cc recipients, separated by commas. These addresses are used to deliver informational copies of the message.
CcRecipients_ItemIds	String	False	Stores the unique item identifiers corresponding to each Cc recipient entry. These identifiers link the recipient metadata with internal Exchange objects.
BccRecipients_Name	String	False	Represents the display name of a recipient in the Bcc (blind carbon copy) field. Bcc recipients are hidden from other message recipients.
BccRecipients_EmailAddress	String	False	Contains the SMTP address of the Bcc recipient. This field is not visible to other recipients of the message, maintaining confidentiality.
BccRecipients_ItemId	String	False	Identifies the unique Exchange store identifier for each recipient listed in the blind carbon copy (Bcc) field of the message. This value enables traceability and programmatic referencing of individual recipients.
IsReadReceiptRequested	Boolean	False	Indicates whether the sender explicitly requested a read receipt notification, which informs the sender when the recipient opens the message.
IsDeliveryReceiptRequested	Boolean	False	Specifies whether the sender requested a delivery receipt to confirm that the message was successfully delivered to the recipient's mailbox.
ConversationIndex	String	False	Stores a binary value used by Exchange to preserve the hierarchical relationship of messages in a conversation thread, enabling accurate threading and sorting of related messages.
ConversationTopic	String	False	Contains the normalized subject line that identifies the topic of a conversation thread. This value is used for grouping related messages within the same thread.
FromName	String	False	Displays the display name of the user or entity that sent the message. This is typically shown in email clients as the sender's name.
FromEmailAddress	String	False	Contains the SMTP address of the message sender, which uniquely identifies the sender's mailbox on the email server.
FromRoutingType	String	False	Specifies the routing protocol used to deliver the message from the sender. Typically set to 'SMTP', but can support other routing types like 'EX' for Exchange.
InternetMessageId	String	False	Stores the globally unique identifier assigned to the email message by the originating mail server, used for message tracking and threading across systems.
IsRead	Boolean	False	Indicates whether the recipient has opened or viewed the message. A value of true means the message has been marked as read.
IsResponseRequested	Boolean	False	Specifies whether the sender is requesting a response from the recipient. This is often used in meeting requests or action-required messages.
References	String	False	Contains one or more Internet message identifiers used to reference previous messages in a thread. This supports message threading and reply association.
EffectiveRights_CreateAssociated	Boolean	True	Indicates whether the current user or client has permission to create associated items within a folder, typically used for hidden metadata like rules or views.
EffectiveRights_CreateContents	Boolean	True	Specifies whether the client has rights to create new items (such as messages or tasks) in the current folder.
EffectiveRights_CreateHierarchy	Boolean	True	Denotes whether the user or client has permission to create subfolders within the current folder structure.
EffectiveRights_Delete	Boolean	True	Indicates whether the client has permission to delete items or folders. A true value means the delete operation is permitted.
EffectiveRights_Modify	Boolean	True	Reflects whether the user has permission to modify the contents or properties of the folder or item.
EffectiveRights_Read	Boolean	True	Indicates whether the user has permission to read the contents of a folder or item. A true value allows access to view the item.
EffectiveRights_ViewPrivateItems	Boolean	True	Specifies whether the user is authorized to view items marked as private. This typically applies to shared mailboxes or calendars.
ReceivedByName	String	False	Displays the display name of the final recipient to whom the message was delivered. This can differ from the intended recipient in the case of forwarding or delegation.
ReceivedByEmailAddress	String	False	Contains the SMTP address of the mailbox that ultimately received the message, used for delivery verification and auditing.
ReceivedByRoutingType	String	False	Specifies the transport protocol used for message delivery to the ReceivedBy mailbox. Typically set to SMTP, indicating the message was received via standard email routing.
ReceivedRepresentingName	String	False	Displays the full name of the user who is being represented as the recipient of the message, allowing for delegation or impersonation tracking.
ReceivedRepresentingEmailAddress	String	False	Specifies the email address of the user represented as the recipient. This is typically used in scenarios where one user sends or receives messages on behalf of another.
ReceivedRepresentingRoutingType	String	False	Indicates the routing protocol used for the ReceivedRepresenting mailbox, such as SMTP, X500, or others. Defaults to SMTP for standard email addresses.
LastModifiedName	String	True	Provides the display name of the last user who modified the item, useful for auditing changes or determining recent activity.
LastModifiedTime	Datetime	True	Captures the date and time of the last modification made to the item. This field is automatically updated by the system and is read-only.
IsAssociated	Boolean	False	Indicates whether the item is linked to a folder as a hidden or system-level item, such as rules, views, or forms.
WebClientReadFormQueryString	String	True	Contains a query string to append to the Outlook Web App (OWA) endpoint for rendering the item in read-only mode in a web browser.
WebClientEditFormQueryString	String	True	Contains a query string to append to the Outlook Web App (OWA) endpoint for launching the item in edit mode through the web interface.
ConversationId	String	True	Uniquely identifies a conversation thread, allowing grouping of related messages or calendar items across folders and time.
ConversationChangeKey	String	True	Represents the version key for the conversation, used to track changes and ensure data consistency across updates.
UniqueBody	String	True	Provides the message body content that is unique to this item within a conversation, excluding quoted or repeated content from earlier messages.
UniqueBodyType	String	True	Specifies the format of the unique body content, either HTML or plain text, determining how it should be rendered in clients.
ReminderMessageData_Text	String	False	Contains the message text associated with a calendar reminder, typically shown in pop-up notifications or alerts.
ReminderMessageData_Location	String	False	Defines the physical or virtual location associated with a calendar item such as a meeting or event, used for reminders.
ReminderMessageData_StartTime	Datetime	False	Indicates the scheduled start time of the calendar item tied to the reminder, aiding in timely notifications.
ReminderMessageData_EndTime	Datetime	False	Specifies the scheduled end time of the associated calendar event, useful for calculating event duration or availability.
ReminderMessageData_AssociatedCalendarId	String	True	References the calendar item linked to the reminder message, allowing correlation between reminders and their parent events.
Attachments	String	True	Lists the identifiers of files attached to the item, formatted as a comma-separated list. Each Id corresponds to an individual attachment.

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.