JDBC Driver for Facebook

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462