unified_message

Description

Access information about messages in a thread.

Columns

Name

Description

action_id

string

Version ID that increases in the same order as messages are received by Facebook. If messages arrive out of order, this ordering can theoretically be different from the timestamp-based ordering, since timestamps for email-originated messages are based on the timestamp of the sender's email client

attachment_map

array

Map from attachment IDs to objects containing information about the attachment (file size, type, etc.)

attachments

array

List of attachment IDs. Attachments correspond to any attached file

body

string

Body of the message

containing_message_id

string

ID of the parent message

coordinates

struct

Coordinates of the location associated with this message

latitude float (min: -90) (max: 90)	A float, in decimal degrees, describing the latitude. Minumum is -90.0, maximum is 90.0.
longitude float (min: -180) (max: 180)	A float, in decimal, describing the longitude. Minumum is -180.0, maximum is 180.0.
altitude float	A float, in meters, describing the altitude.
accuracy float	A float, in meters, describing the accuracy.
altitudeAccuracy float	A float describing the accuracy of the altitude.
heading float	A double or null, in degrees, describing the heading direction calculated based on previous position.
speed float	A double or null, in meters/second, describing the speed calculated based on previous position.
timestamp timestamp	A UNIX timestamp for the time of the request

forwarded_message_id

string

ID of the forwarded message

forwarded_messages

array

Forwarded messages

html_body

string

HTML representation of the message body

is_forwarded

bool

Whether the message is forwarded

is_user_generated

bool

Whether the log message has a user-generated body

log_message

struct

The log message associated with this message

videoCallLog

struct

Log information for the video call

answered bool	Whether the video call was answered
startTime timestamp	Start time of the video call (UNIX timestamp)
endTime timestamp	End time of the video call (UNIX timestamp)

callLog

struct

Log information for the call

type string	Type of the call message (video call, SMS, etc.)
callEndPoint string	Endpoint of the call
duration unsigned int32	Duration of the call
message string	The message content

smsLog

struct

Log information for the SMS

type string	Type of the call message. E.g. video call, SMS
callEndPoint string	Endpoint of the call
message string	The message content

voiceMailLog

struct

Log information for the voice mail

type

string

Type of the call message. E.g. video call, SMS

callEndPoint

string

Endpoint of the voice mail

duration

unsigned int32

Duration of the voice mail

message

string

Message content of the voice mail

audio

struct

Audio of the voice mail

string

ID of the attachment

type

int32

Type of the attachment

mime_type

string

Mime type of the attachment

filename

string

Filename of the attachment

file_size

unsigned int32

File size of the attachment

image_data

struct

Image data of the attachment

width int32	Width of the image attachment
height int32	Height of the image attachment

voicemailUid

User ID of the voicemail recipient

threadName

string

Name of the thread

threadPic

struct

Picture of the thread

deleted bool	Whether the thread picture has been deleted
mimeType string	Mime type of the thread picture
fileSize unsigned int32	File size of the thread picture
hash string	Hashed data of the thread picture

message_id

string

ID of the message

object_sender

struct

Sender of the message in the case that it is a Facebook page, group or event

object_address_type number	Type of the object address
id string	ID of the object address

offline_threading_id

string

Client provided message ID that clients like Facebook Messenger can use to associated a unique ID with the message being sent

recipients

array

List of message recipients

sender

(null) or (struct with keys: name, email, user_id)

Sender of the message

share_map

array

Map from share IDs to objects containing information about the shared objects

array

List of share IDs. Shared items include links, videos, and photos as were supported in the old messaging system

subject

string

Subject of the message

Examples

SELECT ... FROM unified_message WHERE message_id = A
SELECT ... FROM unified_message 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.

Tables

unified_message

Description

Columns

Examples

Permissions