MailThreads

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

Select

The connector 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 connector.

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	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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。