TDV Adapter for Facebook

Build 22.0.8462

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 in Facebook represent the users that like a particular target. The target may be a post, page, picture, or other type of valid entity that may have likes associated with it.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462