unified_thread_action
Description
This table should be used to access information about Add People and Leave Conversation actions performed on a thread in the new Facebook messaging system and is only applicable to group threads with three or more participants.
Columns
| Name | Description | ||||||
|---|---|---|---|---|---|---|---|
action_id string | A unique version ID that is increasing in the same order as the actions that have been performed | ||||||
actor struct | The user who performed the action | ||||||
| |||||||
body string | Body of the thread action | ||||||
internal_message_id string | Internal ID for the message | ||||||
thread_id | ID of the thread | ||||||
timestamp string | Time at which the action was performed (UNIX timestamp) | ||||||
type int32 | Flag to indicate whether the action is a subscribe (1) or unsubscribe (2) | ||||||
users array | List of users on whom the action was performed | ||||||
Examples
- SELECT ... FROM unified_thread_action WHERE thread_id = 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.