MailMessages
Returns metadata and status flags for mail threads, including sender and recipient parties, folder assignment, timestamps, and linked deal information.
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Unique identifier of the mail thread. | |
| PartiesTo | String | Recipients of the mail thread. | |
| PartiesFrom | String | Senders of the mail thread. | |
| DraftParties | String | Parties associated with draft messages in the thread. | |
| Folders | String | Mail folders to which the thread belongs, such as inbox or sent. | |
| AccountId | String | Identifier of the mail account associated with the thread. | |
| UserId | Integer | Identifier of the Pipedrive user who owns the mail thread. | |
| Version | Integer | Version number of the mail thread record, incremented on each update. | |
| Subject | String | Subject line of the mail thread. | |
| Snippet | String | Short preview text of the most recent message in the thread. | |
| SnippetDraft | String | Preview text of the most recent draft message in the thread. | |
| SnippetSent | String | Preview text of the most recent sent message in the thread. | |
| HasAttachmentsFlag | Integer | Indicates whether the thread contains any attachments. A value of 1 means attachments are present. | |
| HasInlineAttachmentsFlag | Integer | Indicates whether the thread contains inline attachments embedded in the message body. A value of 1 means inline attachments are present. | |
| HasRealAttachmentsFlag | Integer | Indicates whether the thread contains file attachments that are not inline. A value of 1 means real attachments are present. | |
| HasDraftFlag | Integer | Indicates whether the thread contains at least one draft message. A value of 1 means a draft exists. | |
| HasSentFlag | Integer | Indicates whether the thread contains at least one sent message. A value of 1 means a sent message exists. | |
| ArchivedFlag | Integer | Indicates whether the thread has been archived. A value of 1 means the thread is archived. | |
| DeletedFlag | Integer | Indicates whether the thread has been deleted. A value of 1 means the thread is marked as deleted. | |
| SyncedFlag | Integer | Indicates whether the thread has been synchronized with the external mail provider. A value of 1 means the thread is synced. | |
| ExternalDeletedFlag | Integer | Indicates whether the thread has been deleted in the external mail provider. A value of 1 means the thread is externally deleted. | |
| SmartBccFlag | Integer | Indicates whether the thread was captured via Pipedrive Smart BCC. A value of 1 means Smart BCC was used. | |
| FirstMessageToMeFlag | Integer | Indicates whether the first message in the thread was addressed to the authenticated user. A value of 1 means the thread started with a message to the user. | |
| MailLinkTrackingEnabledFlag | Integer | Indicates whether link tracking is enabled for messages in this thread. A value of 1 means link tracking is active. | |
| LastMessageTimestamp | String | Timestamp of the most recent message in the thread, whether sent or received. | |
| FirstMessageTimestamp | String | Timestamp of the first message in the thread. | |
| LastMessageSentTimestamp | String | Timestamp of the most recent outbound message sent within the thread. | |
| LastMessageReceivedTimestamp | String | Timestamp of the most recent inbound message received within the thread. | |
| AddTime | String | Date and time when the mail thread was added to Pipedrive. | |
| UpdateTime | String | Date and time when the mail thread was last updated. | |
| DealId | Integer | Identifier of the deal linked to this mail thread. | |
| DealStatus | Integer | Status of the deal linked to this mail thread, such as open, won, or lost. | |
| AllMessagesSentFlag | Integer | Indicates whether all messages in the thread have been sent. A value of 1 means no unsent or draft messages remain. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| Folder | String | The type of folder to fetch. |