TDV Adapter for Facebook

Build 21.0.8137

Wall

Query Posts from the Wall of a Target.

Table Specific Information

Walls in Facebook are a collection of the various posts and updates made to a user's profile or wall.

Select

When selecting from a wall, specify a target. The target represents the user, page, group, application, or other valid entity that may have a wall associated with it. If no target is specified, the currently authenticated user will be used as the target. For example:

SELECT * FROM Wall WHERE Target = 'facebook'

When querying the wall, elements may be retrieved by specifying either the CreatedTime or the UpdatedTime. For example:

SELECT * FROM Wall WHERE Target='facebook' AND CreatedTime >= '1/1/2012' AND CreatedTime <= '2/1/2012'

Insert

While the wall may not be directly inserted to, you may post to a wall by issuing an insert with the correct target using the Posts table.

Columns

Name Type Description
ID [KEY] String The Id of the post.
Target String The Id or username of the target you are retrieving the wall for.
FromId String Id of the user who made the post.
FromName String Name of the user who made the post.
FromPicture String Picture of the user who made the comment.
FromCategory String Category of the user who made the post. FromCategory may only be retrieved if the other From* fields are not selected.
ToData String An aggregate of users the post was made to.
Message String The message of the post.
MessageTags String An aggregate of objects tagged in the message such as Users, Pages, etc.
Picture String A link to the picture included in the post.
Icon String Link to an icon representing the type of post.
Actions String An aggregate of available actions on the post (such as commenting or liking).
CommentsCount Integer The number of comments for the post.
LikesCount Integer The number of times the post has been liked.
SharesCount Integer The number of times the post has been shared.
PlaceId String The Id of the location associated with the post, if any.
PlaceName String The name of the location associated with the post, if any.
Type String The type of post.
Link String The link attached to the post.
Name String The name of the link.
Caption String The caption of the link, which appears beneath the link name.
Description String A description of the link, appears beneath the link caption.
Source String A URL to a flash movie or video file embedded within the post.
ObjectId String The Facebook object Id for an uploaded photo or video.
ApplicationId String Id of the application this post came from.
ApplicationNamespace String Information about the application used to create the entity.
Story String Text of stories not intentionally generated by users, such as those generated when two users become friends; you must have the 'Include recent activity stories' migration enabled in your app to retrieve these stories.
StoryTags String An aggregate of objects (users, pages, etc.) associated with the story.
LikesData String An aggregate of like data.
CommentsData String An aggregate of comments for this post.
CreatedTime Datetime When the post was created.
UpdatedTime Datetime When the post was last updated.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137