Reference: |
This section describes the metadata and sample reports for the Facebook Adapter.
The following table lists and describes the available metadata for the Facebook Adapter.
A metadata name with a "_o" suffix is used to retrieve an object of information from Facebook. This type of metadata should only be used as a secondary file in a JOIN.
A metadata name without a "_o" suffix is used to retrieve specific columns of information from Facebook.
Metadata |
Description |
---|---|
application_o |
Used to retrieve information about a Facebook application. |
comment |
Describes the Comment table. Used to retrieve specific information about a Facebook comment. |
comment_o |
Used to retrieve information about a Facebook comment. |
fb_search |
Used to search for a Facebook ID for an application, page, or user. |
friend |
Describes friend table. Used to retrieve the IDs for friends of a user. |
like |
Describes the Like table. Used to retrieve the IDs of users who like a given video, post, comment, link, photo, or album. |
likes_o |
Used to retrieve the IDs and names of users who like a given video, post, comment, link, photo, or album. |
page |
Describes the Page table. Used to retrieve information about a Facebook page. |
profile |
Describes the Profile table. Used to retrieve the name, user name/page alias, and type for a Facebook object. For example, user, group, page, event, application. |
statuses_o |
Used to retrieve posts, comments, and likes for a Facebook application or page. |
stream |
Describes the Stream table. Used to retrieve Post information. |
user |
Describes the User table. Used to retrieve information about a user. |
fbsampl/app_statuses |
Cluster Join used for reporting application posts and comments. Joins: from application_o to statuses_o |
fbsampl/full_model |
Cluster Join used for reporting page posts, comments, post and comment likes, and post and comment user information. Joins:
|
fbsampl/page_posts_comments |
Cluster Join used for reporting page posts and comments. Joins:
|
fbsampl/posts_comments |
Cluster Join used for reporting user posts and comments. Joins: stream to comment_o |
The following table lists and describes the sample reports for the Facebook Adapter.
Sample Report |
Description |
---|---|
fbsampl/app_comments |
Reports on posts and comments for a Facebook application. Uses: fbsampl/app_statuses |
fbsampl/app_likes |
Reports on likes for a Facebook application. Uses: fbsampl/app_statuses |
fbsampl/fb_search |
Search for the ID and name for a page, application, or user. Uses fb_search. |
fbsampl/fb_search_posts |
Search for all public posts containing a specified query string. Uses: fb_search_posts |
fbsampl/page_posts_comments |
Reports Facebook page posts and related comments. Uses: fbsampl/page_posts_comments |
fbsampl/posts_comments |
Reports Facebook user posts and related comments. Uses: fbsampl/posts_comments |
WebFOCUS |