Likes
Create, delete, and query the Likes for a Target. Alternatively, lists Pages that the specified User or Page Likes. Authentication is required to use this table.
Table Specific Information
Likes is an advanced table and require you to set the Target column in the SQL query.
Likes in Facebook represent the users that like a particular target. The target may be a post, picture, or other type of valid entity that may have likes associated with it.
Note: At this time, the Likes table cannot retrieve likes or other reactions for pages. To retrieve simple insights for pages under the new Page experience from Facebook, see PageAndPostInsights.
Select
When selecting likes, specify a target. The target represents the username or Id of the entity that likes are being retrieved for. For example:
SELECT Id, Name, Picture FROM Likes WHERE Target = '15526475270_410830705612736'
If a user or page is specified as the target for likes, then the pages that the user or page likes will be returned. For example:
SELECT Id, Name, Username, Category FROM Likes WHERE Target = 'facebook'
If no target is specified, the currently authenticated user will be used as the target. In this case, the pages that the authenticated user likes will be returned.
Insert
To insert a like or to like something, simply issue an INSERT statement and specify the target you are liking. The target must be an album, checkin, comment, photo, post, status update, or other object that can be liked. For example:
INSERT INTO Likes (Target) VALUES ('123456789_123456789')
Update
Facebook does not allow likes to be updated.
Delete
Facebook does not allow likes to be deleted.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
The Id of a user who likes the target, which may or may not be combined with the target Id. The user Id will be after the final '_'. |
| Target [KEY] | String | False |
The Id or username of the target being liked. This may be a post, page, picture, or other valid id with likes. |
| Name | String | True |
The name of the user who likes the target. May alternatively be the name of a page. |
| Username | String | True |
The username of a page when retrieving pages a page has liked. |
| Picture | String | True |
Picture of the user who likes the target. May alternatively be the picture of a page. |
| Category | String | True |
The category of the user or page. |
| CreatedTime | Datetime | True |
The time the like was created, if available. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.
| Name | Type | Description |
| offset | String |
Which result to begin returning results from. Used for manual paging of results. |