FQL:unified_thread_count

Please note: Facebook is in the process of making the new messages system available to all users. Facebook is providing early access to this API for registered developer accounts only until the new messaging system is broadly available. You should use the message table and thread table for production applications at the current time.

Access to this table requires the user to grant the read_mailbox extended permission.

Columns

Highlighted rows are indexable / searchable and one is usually required in the WHERE portion of the query.

Name	Type	Description
folder	string	Folder name ('inbox', 'other', 'spam' or 'sent').
unread_count	int	Number of unread threads in the folder.
unseen_count	int	Number of unseen threads in the folder.
last_seen_time	int	Last time the folder was accessed (Unix-type timestamp with millisecond resolution).
total_threads	int	Total number of non-archived threads.

Examples

Get thread counts for the inbox folder

SELECT ... FROM unified_thread_count WHERE folder='inbox'

Get thread counts for all folders

SELECT ... FROM unified_thread_count WHERE 1