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. |
| Attachments | String | An aggregate for the attachments of the post. |
| 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. |