Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Facebook Views
| Name | Description |
| Comments | Create, update, delete, and query the Comments for a Target. Comments may also be inserted based on a Target or deleted based on Id. |
| Events | Query the Events for a Target such as a page id. |
| Groups | Query the Pages based on the supplied Id. |
| InsightsByConsumptionType | Allows retrieval of insights by consumption type. |
| InsightsByFeedbackType | Allows retrieval of insights by feedback type. |
| InsightsByLikeSourceType | Allows retrieval of insights by like source type. |
| InsightsByReactionTotals | Allows retrieval of insights by like source type. |
| InsightsByStoryType | Allows retrieval of insights by like story type. |
| InsightsByTabType | Allows retrieval of insights by tab type.. |
| InsightsByUnLikeSourceType | Allows retrieval of insights by like source type. |
| InstagramAccountInsights | Allows you to get insights for an Instagram Business Account. Requires the instagram_basic and instagram_manage_insights scopes. |
| Pages | Query the Pages based on the supplied Id. |
| Permissions | Query the Permissions the User has granted the current application. |
| Photos | Query Photos associated with a Target. Accessing Photo information typically requires the user_photos permission. |
| Places | Query the Places based on the supplied Id. Places are stored as Pages in Facebook. |
| Ratings | List of ratings for a Facebook Page. This view requires authentication. |
| SimpleInsights | Allows the retrieval of simple insights with a single value in the response. |
| SimpleVideoInsights | Allows the retrieval of simple video insights with a single value in the response. |
| StoryAttachments | Query attachments from a post or comment. |
| TaggedBy | Query information about Posts, Statuses, Photos, and other entities that have tagged the User or Page. This view is a derivative of the Wall connection where only entries that have tagged the Target User or Page will be returned. In general it is only available for Pages. |
| Users | Returns basic information about the authenticated user. |
| VideoInsightsByActionType | Allows the retrieval of video insights by story action type. |
| VideoInsightsByDistributionType | Allows the retrieval of video insights by distribution type. |
| VideoInsightsByReactionType | Allows the retrieval of video insights by reaction type. |
| Videos | Query Videos from a Target. Normally requires the user_videos permission. |
| Wall | Query Posts from the Wall of a Target. |