FQL:connection

Query this table to return a user's friends and the Facebook Pages to which the user is connected (that is, whether the source is friends with another user or likes a Facebook Page). These are all the entities whose streams the specified user can consume.

Columns

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

Name	Type	Description
source_id	int	The ID of the user, the source of the connection.
target_id	int	The target(s) of the connection. The ID of the friend or Facebook Page with whom the specified user is either a friend or fan/supporter.
target_type	string	Indicates whether the target is a user or a page.
is_following	bool	Indicates whether the source is connected to the target Page (for example, if the source is a supporter or fan). is_following returns 0 if the source has hidden the target from their news feed
updated_time	time	The most recent time the connection was updated. seems to be broken and always returns a blank
is_deleted	bool	Indicates whether the source severed the connection. seems to be broken and always returns a blank

Notes/Bugs/Gotchas

• is_following, updated_time, and is_deleted seem to be static values regardless of the query:

updated_time = ''; // not a "time"
is_deleted = '';   // not a "bool"

• if a person is not "following" it will not return any result instead of returning a result with is_following being false. is_following returns 0 if the source has hidden the target from their news feed but is usually 1.