Newsfeed
Retrieves posts from the currently logged in user's NewsFeed. This table requires authentication.
Table Specific Information
The NewsFeed represents what you see on your home page. This contains any number of posts and status updates from the users and pages you are following. Only the currently authenticated user's NewsFeed may be accessed. Accessing another user's NewsFeed is prohibited.
Select
When querying the newsfeed, elements may be retrieved by specifying either the CreatedTime or the UpdatedTime. For example:
SELECT * FROM NewsFeed WHERE CreatedTime >= '1/1/2012' AND CreatedTime <= '2/1/2012'
Columns
| Name | Type | Description |
| ID [KEY] | String | The id of the post. Requires an access token. |
| Type | String | The type of post. |
| FromId | String | Id of the user who made the post. Requires an access token. |
| FromName | String | Name of the user who made the post. Requires an access token. |
| FromCategory | String | Category of the user who made the post. Requires an access token. |
| ToData | String | An aggregate of users the post was made to. Requires an access token. |
| Message | String | The message of the post. Requires an access token. |
| MessageTags | String | An aggregate of objects tagged in the message such as Users, Pages, etc. Requires an access token. |
| Link | String | The link attached to the post. Requires an access token. |
| Name | String | The name of the link. Requires an access token. |
| Caption | String | The caption of the link, which appears beneath the link name. Requires an access token. |
| Description | String | A description of the link (appears beneath the link caption). Requires an access token. |
| Picture | String | A link to the picture included in the post. Requires an access token. |
| Source | String | A url to a flash movie or video file embedded within the post. Requires an access token. |
| Icon | String | Link to an icon representing the type of post. Requires an access token. |
| Actions | String | An aggregate of available actions on the post (such as commenting or liking). Requires an access token. |
| CommentsCount | Integer | The number of comments for the post. Requires an access token or the read_stream permission depending on the privacy settings of the entity. |
| LikesCount | Integer | The number of times the post has been liked. Requires an access token or the read_stream permission depending on the privacy settings of the entity. |
| SharesCount | Integer | The number of times the post has been shared. Requires an access token or the read_stream permission depending on the privacy settings of the entity. |
| PlaceId | String | The id of the location associated with the post, if any. Requires the read_stream permission. |
| PlaceName | String | The name of the location associated with the post, if any. Requires the read_stream permission. |
| ObjectId | String | The facebook object id for an uploaded photo or video. Requires the read_stream permission. |
| ApplicationId | String | Id of the application this post came from. Requires the read_stream permission. |
| ApplicationName | String | Name of the application this post came from. Requires the read_stream permission. |
| ApplicationCanvasName | String | Information about the application used to create the entity. Requires an access_token or the read_stream permission depending on the privacy settings of the entity. |
| ApplicationNamespace | String | Information about the application used to create the entity. Requires an access_token or the read_stream permission depending on the privacy settings of 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. Requires the read_stream permission. |
| StoryTags | String | An aggregate of objects (users, pages, etc) associated with the story. Requires the read_stream permission. |
| LikesData | String | An aggregate of like data. Requires an access token. |
| CommentsData | String | An aggregate of comments for this post. Requires the read_stream permission. |
| WithTagsData | String | Objects (users, pages, etc) tagged as being with the publisher of the post. Requires the read_stream permission. |
| TagsData | String | An aggregate of users tagged in the video, if any. Requires the read_stream permission. |
| CreatedTime | Datetime | When the post was created. Requires the read_stream permission. |
| UpdatedTime | Datetime | When the post was last updated. Requires the read_stream permission. |
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 section.
| Name | Type | Description |
| rows@next | String | This is used to page through multiple pages of results and should not be set manually. |