MailThreads

Get, Update and Delete mail threads in a specified folder ordered by the most recent message within.

Select

The add-in will use 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 add-in.

Id supports the '=' operator.
Folder supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM MailThreads WHERE Folder = 'inbox'

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

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

DELETE

Delete can be executed 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		ID of the Mail Threads.
PartiesTo	String	True		To.
PartiesFrom	String	True		From.
DraftParties	String	True		Draft Parties.
Folders	String	True		Folders.
AccountId	String	True		Account Id.
UserId	Integer	True		User Id.
Version	Integer	True		Version.
Subject	String	True		Subject.
Snippet	String	True		Snippet.
SnippetDraft	String	True		SnippetDraft.
SnippetSent	String	True		SnippetSent.
HasAttachmentsFlag	Integer	True		HasAttachmentsFlag.
HasInlineAttachmentsFlag	Integer	True		HasInlineAttachmentsFlag.
HasRealAttachmentsFlag	Integer	True		HasRealAttachmentsFlag.
HasDraftFlag	Integer	True		HasDraftFlag.
HasSentFlag	Integer	True		HasSentFlag.
ArchivedFlag	Integer	True		ArchivedFlag.
DeletedFlag	Integer	True		DeletedFlag.
SyncedFlag	Integer	True		SyncedFlag.
ExternalDeletedFlag	Integer	True		ExternalDeletedFlag.
SmartBccFlag	Integer	True		SmartBccFlag.
FirstMessageToMeFlag	Integer	True		FirstMessageToMeFlag.
MailLinkTrackingEnabledFlag	Integer	True		MailLinkTrackingEnabledFlag.
LastMessageTimestamp	String	True		LastMessageTimestamp.
FirstMessageTimestamp	String	True		FirstMessageTimestamp.
LastMessageSentTimestamp	String	True		LastMessageSentTimestamp.
LastMessageReceivedTimestamp	String	True		LastMessageReceivedTimestamp.
AddTime	String	True		AddTime.
UpdateTime	String	True		UpdateTime.
DealId	Integer	True		DealId.
DealStatus	Integer	True		DealStatus.
AllMessagesSentFlag	Integer	True		AllMessagesSentFlag.

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.