Description
Information about messages in a thread as represented in FQL. To access this table you need an access token with extended read_mailbox permissions.
Columns
| Name | Description |
|---|
attachment struct | An array of information about the attachment to the message. This is the attachment that Facebook returns.
|
media array | Rich media that provides visual content for the post
| name string | The title of the post
| href string | The URL of the attachment
| caption string | A subtitle for the post
| description string | Descriptive text about the story
| properties array | A dictionary of key/value pairs that provide more information about the post
| icon string | The icon for the attachment
| fb_object_type string | Object type of the attachment
| fb_object_id string | Object ID of the attachmenet
| fb_checkin struct | A checkin object | checkin_id id | The ID of the checkin
| author_uid id | The ID of the user making the checkin
| page_id id | The ID of the Page representing the place
| target_id id | The ID of Event or Page the user is checking into
| target_href string | The URL of the Event or Page the user is checking into
| coords struct | The latitude and longitude of the location
| 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
|
| tagged_uids array | The IDs of users tagged in the checkin
| timestamp timestamp | A UNIX timestamp of the checkin
| message string | The message the author posted with the checkin
| target_type string | The type of the target for the checkin. For example,event and page
|
| sticker_id numeric string | The ID of the sticker within the attachment
| tagged_ids array | Tagged user IDs
|
|
author_id id | The ID of the user who wrote this message.
|
body string | The content of the message.
|
created_time timestamp | The time the message was sent (represented as a UNIX timestamp)
|
message_id string | A unique ID for the message being queried.
|
source unsigned int32 | The source of the message.
|
thread_id numeric string | The ID of the thread the message belongs to.
|
viewer_id numeric string | The ID of the user whose Inbox you are querying. Defaults to session user.
|
Examples
- SELECT ... FROM message WHERE message_id = A
- SELECT ... FROM message WHERE thread_id = A
Note: Additional filters on other columns can be specified but they may make the query less efficient.
To access the message table you need
