CData Python Connector for Microsoft Exchange

Build 25.0.9454

JunkEmail

Tracks email items flagged as spam or junk. It facilitates review, removal, or retrieval of misclassified messages.

Columns

Name Type ReadOnly Description
ItemId [KEY] String True

Uniquely identifies the item within the Exchange store. This value can be used to retrieve, update, or delete the item from the store.

MimeContent String True

Contains the raw email content in Multipurpose Internet Mail Extensions (MIME) format, encoded in Base64. This stream includes headers, body, and attachments as they were originally received.

ItemChangeKey String True

Provides a unique token that changes whenever the item is modified. Used for concurrency control and to ensure consistency in item synchronization.

ParentFolderId String False

Holds the unique identifier of the folder that contains the current item. This allows hierarchical organization of mailbox items.

ParentFolderChangeKey String True

Contains a unique value that changes whenever the parent folder is modified. It helps in detecting changes at the folder level during synchronization.

ItemClass String False

Specifies the message class of the item, such as IPM.Note for standard email messages or IPM.Appointment for calendar items. Helps determine item behavior in the client.

Subject String False

Contains the subject line of the item, limited to 255 characters. Used as the main title or summary for the item in user interfaces.

Sensitivity String True

Indicates the sensitivity setting of the item, such as Normal, Personal, Private, or Confidential. This guides how the item should be handled and displayed by clients.

Body String False

Holds the main text content of the message body. May include HTML or plain text formatting depending on the message composition format.

DateTimeReceived Datetime True

Captures the exact date and time when the item was delivered to the mailbox. Used for sorting, filtering, and display in message lists.

Size Integer True

Reports the total size of the item in bytes, including its body, attachments, and metadata. This property is read-only and useful for storage management.

Categories String False

Lists the categories associated with the item, represented as a collection of strings. Categories help organize and visually tag items in client applications.

Importance String False

Indicates the priority level of the item, typically Low, Normal, or High. This influences how the item is presented and handled by clients.

InReplyTo String False

Contains the identifier of the original message that this item is replying to, facilitating message threading and conversation tracking.

IsSubmitted Boolean True

Indicates whether the message has already been submitted to the Outbox folder for delivery. This flag is typically set when an item transitions from draft or compose mode to a state ready for sending.

IsDraft Boolean True

Specifies whether the item is still in draft status, meaning it has been composed but not yet sent or submitted. Useful for distinguishing incomplete messages from finalized ones.

IsFromMe Boolean True

Determines whether the sender and recipient of the item are the same user. This is commonly used to identify messages a user sends to themselves, either for reminders or testing.

IsResend Boolean True

Indicates whether the message is a resend of a previously sent item. This can be used to track repeated attempts to deliver or forward the same content.

IsUnmodified Boolean True

Represents whether the item remains unchanged from its original state since creation or receipt. Useful for filtering out items that have been edited or altered.

InternetMessageHeaders String True

Contains the full set of Internet-standard headers for the message, such as From, To, Subject, Date, and custom headers. These headers provide transport and metadata information used in message routing and processing.

DateTimeSent Datetime True

Captures the exact date and time when the message was sent from the client or mail server. This timestamp reflects when the message left the sender's outbox.

DateTimeCreated Datetime True

Indicates when the item was originally created in the mailbox. This is typically set when the message is first composed or received.

ReminderDueBy Datetime False

Specifies the date and time when a reminder is scheduled to be triggered for the item. This is used in conjunction with the ReminderMinutesBeforeStart value to alert users before an event or deadline.

ReminderIsSet Boolean False

Identifies whether a reminder has been configured for this item. A true value means a user has requested a visual or audible alert prior to a specified time.

ReminderMinutesBeforeStart Integer False

Specifies the number of minutes before the start time of a calendar event when a reminder notification should be triggered for the user.

DisplayCc String True

Stores the concatenated display names of all recipients listed in the Cc (carbon copy) field, formatted as a single string suitable for display purposes in user interfaces.

DisplayTo String True

Stores the concatenated display names of all recipients listed in the To field. This value is typically displayed in the message header and is used to identify primary recipients.

HasAttachments Boolean True

Indicates whether the message or calendar item contains any file attachments. A value of true means one or more attachments are present.

Culture String False

Specifies the culture or locale information (such as language and regional settings) associated with the item, which can affect formatting and localization of content.

SenderName String False

Contains the display name of the sender who initiated the message or calendar event. This is typically a human-readable name presented in email headers.

SenderEmailAddress String False

Specifies the full email address of the sender, formatted using the Simple Mail Transfer Protocol (SMTP), which is the standard format for email routing.

SenderRoutingType String False

Identifies the protocol or routing method used to deliver the message from the sender. The default and most common value is SMTP, but other routing types can also be supported.

ToRecipients_Name String False

Contains the individual display names of users listed as primary recipients (To) of the item. This is typically the name shown in the email client for each recipient.

ToRecipients_EmailAddress String False

Stores the SMTP email addresses corresponding to the To recipients of the item, ensuring that each recipient can be routed correctly via email systems.

ToRecipients_ItemId String False

Provides a unique identifier associated with each To recipient in the Exchange store. This is used for internal tracking and relationship mapping.

CcRecipients_Name String False

Contains the display names of users who are copied on the message via the Cc (carbon copy) field, as typically displayed in the message header.

CcRecipients_EmailAddress String False

Holds the SMTP email addresses of the recipients listed in the Cc field. These addresses are used for routing copies of the item to additional stakeholders.

CcRecipients_ItemId String False

Stores the unique identifier for each recipient listed in the Cc (carbon copy) field, enabling linkage to recipient metadata or further recipient details.

BccRecipients_Name String False

Specifies the display name of each recipient listed in the Bcc (blind carbon copy) field, typically shown in mail clients for administrative or logging purposes.

BccRecipients_EmailAddress String False

Holds the email address (in SMTP format) of each Bcc recipient, which remains hidden from other message recipients to ensure privacy.

BccRecipients_ItemId String False

Contains a unique identifier corresponding to each Bcc recipient, used internally to track recipient details and link to message metadata.

IsReadReceiptRequested Boolean False

Indicates whether the sender has requested a read receipt for the item, which prompts the recipient's client to notify the sender when the message is opened.

IsDeliveryReceiptRequested Boolean False

Specifies whether the sender has requested a delivery receipt, which confirms that the message was successfully delivered to the recipient's mailbox.

ConversationIndex String False

Stores a binary string that maintains the threading hierarchy of the conversation, allowing clients to reconstruct the sequence and nesting of related messages.

ConversationTopic String False

Represents the subject or topic line used to group related messages into a conversation thread within the mailbox interface.

FromName String False

Displays the name associated with the sender's mailbox, typically derived from the display name field in the sender's contact or directory profile.

FromEmailAddress String False

Contains the sender's email address in SMTP format, used to route replies and identify the sender in both headers and user interfaces.

FromRoutingType String False

Indicates the protocol or routing method used to send the message. Common values include SMTP for standard email routing and EX for Exchange-based routing.

InternetMessageId String False

Stores the globally unique identifier for the message, used for tracking across servers and clients and included in the message's Internet headers.

IsRead Boolean False

Marks whether the message has been opened or viewed by the recipient. Useful for user interface indicators and automated workflows that rely on message status.

IsResponseRequested Boolean False

Specifies whether the sender of the item has requested a response from the recipient. This is often used for meeting requests, tasks, or emails where a reply or confirmation is expected.

References String False

Contains the Usenet 'References' header field, which is used to maintain the thread hierarchy by identifying message IDs of previous related messages. This helps email clients organize message threads in conversation view.

EffectiveRights_CreateAssociated Boolean True

Indicates whether the client application has permission to create associated items, which are non-visible metadata objects stored within a folder, such as rules, views, or forms.

EffectiveRights_CreateContents Boolean True

Indicates whether the client has the right to create content items such as emails or calendar events within the folder. This is typically controlled by folder-level access rights.

EffectiveRights_CreateHierarchy Boolean True

Specifies whether the client has permission to create subfolders within the current folder. This is applicable to folders like the mailbox root or custom folders.

EffectiveRights_Delete Boolean True

Determines if the client has the necessary permissions to delete the folder or its contained items. This includes both soft delete (move to Deleted Items) and hard delete actions.

EffectiveRights_Modify Boolean True

Indicates whether the client is authorized to make changes to the folder or item, such as updating its properties or modifying content like message body or attachments.

EffectiveRights_Read Boolean True

Specifies whether the client is permitted to read the folder or item contents. This includes access to message headers, body text, and item metadata.

EffectiveRights_ViewPrivateItems Boolean True

Indicates whether the client has permission to view items marked as private, such as calendar entries or tasks that are hidden from general view by default.

ReceivedByName String False

Captures the display name of the user or mailbox that received the item. This value is derived from the mailbox or directory profile associated with the recipient.

ReceivedByEmailAddress String False

Stores the full SMTP address of the mailbox that received the item. This address is used for routing the message through the email infrastructure.

ReceivedByRoutingType String False

Indicates the routing type used for delivering the message to the ReceivedBy recipient. Common values include SMTP (Simple Mail Transfer Protocol), EX (Exchange), or X400.

ReceivedRepresentingName String False

Defines the display name of the user or mailbox that the message was received on behalf of. This is often used when messages are sent to shared or delegated mailboxes.

ReceivedRepresentingEmailAddress String False

Specifies the SMTP (Simple Mail Transfer Protocol) email address of the mailbox user on whose behalf the message was received. This is typically used in delegated mailbox scenarios.

ReceivedRepresentingRoutingType String False

Indicates the type of routing used for the ReceivedRepresenting mailbox user, such as SMTP or EX. The default is SMTP, which refers to standard email routing over the internet.

LastModifiedName String True

Contains the display name of the user who most recently modified the item. This helps track authorship or recent activity related to the item content or metadata.

LastModifiedTime Datetime True

Stores the timestamp of the most recent modification made to the item, including updates to properties or content. This field is read-only and system-generated.

IsAssociated Boolean False

Indicates whether the item is an associated item within a folder. Associated items are not visible in standard folder views and are used for storing folder-level data such as rules or forms.

WebClientReadFormQueryString String True

Provides a relative URL query string that should be appended to the base Outlook Web App (OWA) endpoint to open the item in read-only mode via the web interface.

WebClientEditFormQueryString String True

Provides a relative URL query string to append to the Outlook Web App endpoint to open the item in edit mode, allowing web-based updates to item contents.

ConversationId String True

Represents the unique identifier for a conversation thread in the Exchange store. This allows grouping of messages and items that belong to the same discussion.

ConversationChangeKey String True

Contains the current change key for the conversation, which is used to identify the version of the conversation object and detect modifications.

UniqueBody String True

Holds a segment of the message body that is unique to this message, excluding quoted replies or forwarded content. It can be formatted in either HTML or plain text.

UniqueBodyType String True

Specifies the format used to store the unique body content of the item. Valid values typically include HTML and TEXT, depending on the message format.

ReminderMessageData_Text String False

Provides the custom text message shown in a reminder for the associated calendar event or appointment. This message typically appears in reminder notifications.

ReminderMessageData_Location String False

Indicates the physical or virtual location where the associated meeting or appointment is scheduled to occur, as stored in the reminder message data.

ReminderMessageData_StartTime Datetime False

Captures the scheduled start time of the event or appointment that triggered the reminder, enabling accurate display and tracking of upcoming calendar items.

ReminderMessageData_EndTime Datetime False

Captures the scheduled end time of the event or appointment that the reminder references. This helps define the full duration of the calendar item.

ReminderMessageData_AssociatedCalendarId String True

Stores the unique identifier of the calendar item (meeting, appointment, etc.) that the reminder is associated with, linking the reminder data back to the main calendar entry.

Attachments String True

Contains a comma-separated list of the identifiers (Ids) for all files attached to the email item (for example, 'att123, att456, att789').

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

Specifies the identifier of the user account being impersonated in the current session. This enables delegated access to retrieve mailbox or item data on behalf of another user.

ImpersonationType String

Indicates the identifier type used to define the impersonation target. Valid values include PrincipalName, SID, PrimarySmtpAddress, and SmtpAddress.

SharedMailboxEmail String

Specifies the email address of a shared mailbox. When set, this allows retrieval of Junk Email items from the specified shared mailbox rather than the default user mailbox.

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