ADO.NET Provider for Streak

Build 23.0.8839

Threads

Retrieve threads from Streak.

Table Specific Information

Select

Streak allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available columns for Threads are BoxKey and ThreadKey. For example:

SELECT * FROM Threads WHERE BoxKey = 'agxzfm1haWxmb29nYWVyLAsSDE9ab2FuaXphdGlvbiIJY2RhdGEuY29tDAsSBENhc2UYgICs7-O4mwsM'

SELECT * FROM Threads WHERE ThreadKey = 'agxzfm1haWxab29nYWVyMwsSDE9yZ2FuaXphdGlvbiIJY2RhdGEuY29tDAsSC0dtYWlsVGhyZWFkGICAnP6JrfsJDA'

Columns

Name Type References Description
ThreadKey [KEY] String Key of the thread.
BoxKey String

Boxes.BoxKey

Key of the box the thread is in.
CreatorKey String

Users.UserKey

Creator of the thread.
PipelineKey String

Pipelines.PipelineKey

Pipeline the thread is in.
CreationTimestamp Timestamp When the thread was created.
LastUpdatedTimestamp Timestamp When the thread was updated.
LastEmailTimestamp Timestamp Datetime of the last email in the thread.
LastEmailFrom String Email address of last email.
NumberOfEmails Integer List of number of emails.
SenderEmailSendTimestampPairs String Whether the sender email can send timestamp pairs or not.
MessageSentTimestamps String When the message was sent.
Subject String The subject of the first email in the thread.
Names String The senders and recipients on the gmail thread.
EmailAddresses String The senders and recipients on the gmail thread.
ThreadGmailId String Gmail's key for the thread.
FileKeys String List of file keys, such as attachments in the thread.
GmailThreadKey String Key of Gmail thread.
LastSavedTimestamp Timestamp When the thread was saved last.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839