MailThreads

Returns mail threads from the connected mail account, ordered by the most recent message, and supports updating read status and deleting threads.

Table-Specific Information

SELECT

The provider uses the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.


Column	Supported Operators
Id	=
Folder	=

For example, the following query is processed server-side:

SELECT * FROM MailThreads WHERE Folder = 'inbox'

UPDATE

Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated. For example:

UPDATE MailThreads SET Subject = 'test' WHERE Id = 145

DELETE

Execute DELETE by specifying the Id in the WHERE clause. For example:

DELETE FROM MailThreads WHERE Id = 145

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the mail thread.
PartiesTo	String	True		The list of recipient email addresses in the To field of the thread.
PartiesFrom	String	True		The list of sender email addresses in the From field of the thread.
DraftParties	String	True		The list of email addresses involved in draft messages within the thread.
Folders	String	True		The mail folders this thread appears in, such as inbox or sent.
AccountId	String	True		The ID of the connected mail account this thread belongs to.
UserId	Integer	True		The ID of the Pipedrive user who owns this mail thread.
Version	Integer	True		The version number of the mail thread, incremented on each update.
Subject	String	True		The subject line of the mail thread.
Snippet	String	True		A short preview of the most recent message in the thread.
SnippetDraft	String	True		A short preview of the most recent draft message in the thread.
SnippetSent	String	True		A short preview of the most recent sent message in the thread.
HasAttachmentsFlag	Integer	True		Indicates whether any message in the thread contains attachments.
HasInlineAttachmentsFlag	Integer	True		Indicates whether any message in the thread contains inline attachments.
HasRealAttachmentsFlag	Integer	True		Indicates whether any message in the thread contains non-inline file attachments.
HasDraftFlag	Integer	True		Indicates whether the thread contains one or more draft messages.
HasSentFlag	Integer	True		Indicates whether the thread contains one or more sent messages.
ArchivedFlag	Integer	False		Indicates whether the thread has been archived.
DeletedFlag	Integer	True		Indicates whether the thread has been deleted.
SyncedFlag	Integer	True		Indicates whether the thread has been successfully synchronized with the external mail provider.
ExternalDeletedFlag	Integer	True		Indicates whether the thread has been deleted in the external mail provider.
SmartBccFlag	Integer	True		Indicates whether the thread was captured via the Pipedrive Smart BCC feature.
FirstMessageToMeFlag	Integer	True		Indicates whether the first message in the thread was addressed to the current user.
MailLinkTrackingEnabledFlag	Integer	True		Indicates whether link tracking is enabled for messages in this thread.
LastMessageTimestamp	String	True		The date and time of the most recent message in the thread.
FirstMessageTimestamp	String	True		The date and time of the first message in the thread.
LastMessageSentTimestamp	String	True		The date and time of the most recent sent message in the thread.
LastMessageReceivedTimestamp	String	True		The date and time of the most recent received message in the thread.
AddTime	String	True		The date and time when the thread was first added to Pipedrive.
UpdateTime	String	True		The date and time when the thread was last updated.
DealId	Integer	False		The ID of the deal this mail thread is linked to.
DealStatus	Integer	True		The current status of the deal linked to this mail thread.
AllMessagesSentFlag	Integer	True		Indicates whether all messages in the thread were sent by the current user.

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.