unified_thread
Description
Access information about threads in the new Facebook messaging system.
Columns
| Name | Description | ||||||
|---|---|---|---|---|---|---|---|
action_id string | Unique numeric version identifier for the thread. Guaranteed to increase as the thread is modified | ||||||
admin_snippet string | Fragment of the thread for admins to use in thread lists | ||||||
archived bool | Flag indicating whether the thread is archived | ||||||
auto_mute array | Auto mute settings for the thread | ||||||
can_reply bool | Whether the user can reply to the thread | ||||||
folder | Folder name ('inbox', 'other' or 'spam') | ||||||
former_participants array | List of former participants who have unsubscribed from the thread | ||||||
has_attachments bool | Whether the thread contains a message that has an attachment | ||||||
is_group_conversation bool | Whether the thread is a group conversation | ||||||
is_named_conversation bool | Whether the thread is a named conversation | ||||||
is_subscribed bool | Whether the user is subscribed to the thread. Only applicable to threads with multiple participants where the user can leave the conversation | ||||||
last_visible_add_action_id string | Version identifier corresponding to one of the following actions: new message in thread, new thread participant, participant left the thread | ||||||
link string | URL to the thread | ||||||
mute array | Mute settings for the thread | ||||||
name string | Name of the thread. Only applicable to threads with more than two participants | ||||||
num_messages unsigned int32 | Total number of messages in the thread | ||||||
num_unread unsigned int32 | Number of unread messages | ||||||
object_participants array | List of participants which represent a Facebook page, group or event | ||||||
participants array | List of user participants who are currently subscribed to the thread | ||||||
pic_hash string | Profile picture hash data for the thread participants | ||||||
read_receipts array | Read receipts for the thread | ||||||
senders array | List of participants who have sent a message in the thread | ||||||
single_recipient | User ID of the other thread participant for threads representing a two-person conversation | ||||||
snippet | Fragment of the thread for use in thread lists | ||||||
snippet_message_has_attachment bool | Whether the snippet contains a message that has an attachment | ||||||
snippet_message_id string | ID of the thread snippet | ||||||
snippet_sender struct | An object with properties of the sender | ||||||
| |||||||
subject string | Subject of the thread | ||||||
tags | List of tags in the thread | ||||||
thread_and_participants_name | Thread name, and names of of the user participants | ||||||
thread_fbid | FBID of the thread | ||||||
thread_id | ID of the thread | ||||||
thread_participants array | List of participants who are currently subscribed to the thread | ||||||
timestamp string | Last update time of the thread (UNIX timestamp, in milliseconds) | ||||||
title string | The thread name, if it is defined, or the list of participants in the thread | ||||||
unread bool | Whether the thread contains unread messages | ||||||
unseen bool | Whether the thread contains unseen messages | ||||||
Examples
- SELECT ... FROM unified_thread WHERE thread_id = A
- SELECT ... FROM unified_thread WHERE thread_fbid = A
- SELECT ... FROM unified_thread WHERE single_recipient = A
- SELECT ... FROM unified_thread WHERE tags = A
- SELECT ... FROM unified_thread WHERE thread_and_participants_name = A
- SELECT ... FROM unified_thread WHERE snippet = A
- SELECT ... FROM unified_thread WHERE folder = A
Note: Additional filters on other columns can be specified but they may make the query less efficient.
Permissions
Access to this table requires the read_mailbox extended permission.