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