thread
Description
Information about message threads in a user's inbox as represented in FQL. To access this table you need an access token with extended read_mailbox permissions.
Columns
| Name | Description |
|---|---|
folder_id | The ID of the folder that belongs to the thread you are querying. The ID can be one of: 0 (for Inbox), 1 (for Outbox), or 4 (for Updates). |
has_attachment number (min: 0) (max: 1) | Whether the thread has attachments. |
message_count unsigned int32 | The number of messages in this thread. |
object_id id | The object that sent this message, or 0 if it was not sent by an object. You can get more information about this object in the profile table. |
originator id | The id of the author who sent the thread. |
parent_message_id id | The ID of the message from which this thread was branched, or 0 if this thread is not a branch. The parent_message_id is a concatenation of the thread ID and the message ID, joined by an underscore. |
parent_thread_id id | The ID of the thread from which this thread was branched, or 0 if this thread is not a branch. |
recent_authors array | An array of recent authors' ids. |
recipients array | The user IDs of the recipients of the thread. |
snippet string | A short bit of text from the most recent message. |
snippet_author id | The user ID of the author of the snippet. |
subject string | The subject of the thread. |
thread_id | The ID of the thread being queried. |
unread unsigned int32 | The number of unread messages in the thread. |
unseen number (min: 0) (max: 1) | Whether the thread is unseen. A thread is unseen if it has been updated since the last time a user viewed it. |
updated_time timestamp | The created_time of the most recent message in the thread. |
viewer_id numeric string | The ID of the user whose Inbox you are querying. |
Examples
- SELECT ... FROM thread WHERE thread_id = A
- SELECT ... FROM thread WHERE folder_id = A
Note: Additional filters on other columns can be specified but they may make the query less efficient.
Permissions
To access the thread table you need
- an access token with extended read_mailbox permissions