FQL:connection

From Facebook Developer Wiki (FbDevWiki.com)
Jump to: navigation, search

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.
Personal tools
Namespaces
Variants
Actions
Navigation
Graph API
FQL
Toolbox