Tableau Connector for Facebook

Build 24.0.9060

Datamodel Permissions

See Data Model for how the connector exposes Facebook APIs as different relational tables and views. This page offers a summary of permissions that might be required depending on how you use the connector.

Overview

Access and permissions to Facebook APIs broadly depend on whether you are pulling information for:

  • a User or things owned by a User
  • a Page or things owned by a Page

For information associated with a User or scoped to a User, access and permission are dependent on the set of permissions (scopes) that the user has approved for the OAuth application that accesses the Facebook API. For information associated with a Page, access and permission are controlled not only by the approvals given by a user to the OAuth application, but also by:

  • the approvals given by a user to the accessing OAuth application
  • the tasks assigned to the user on the Page
  • various Features approved for the application regardless of user
  • Page status on the Facebook platform

To access information associated with a User, the OAuth application that is used with the connector must be able to obtain some or all of the following permissions:

  • user_birthday
  • user_photos
  • user_videos
  • user_likes
  • user_hometown
  • user_location
  • user_tagged_places
  • public_profile

The user must also approve the OAuth application for these permissions when the user signs into Facebook to approve the application's access to their account.

To access information associated with a Page, the OAuth application that is used with the connector must be able to obtain some or all of the following permissions:

  • read_insights
  • pages_read_engagement
  • pages_manage_engagement
  • pages_show_list

The user must also approve the OAuth application for these permissions when the user signs into Facebook to approve the application's access to their account.

Additionally, when accessing Page information, depending on what they are trying to access, users might find that they need one of the following Tasks for the Page:

  • ANALYZE
  • MODERATE
  • CREATE_CONTENT
  • MANAGE

Alternatively, you can use the following features, if approved for an application, to access certain public Page information when the user does not have the requisite Task on the page:

  • Page Public Content Access (PPCA)
  • Page Public Metadata Access (PPMA)

Finally, the status of a Page can also factor into determining what sort of information can be obtained for or from it:

  • For Unpublished Pages, there are usually no restrictions for the Page data
  • For Published, Unrestricted Pages, limited data is available through PPCA or PPMA. More data specific to the Page, or specific to the users, pages, or other Facebook entities that have interacted with the Page, is available to those who have requested requisite permissions for pages, and who also have been assigned the Tasks needed for the Page. Non-public Page data may be further limited by privacy choices of the user, page, or entity that generated the non-public data on the Page.
  • For Published, Restricted Pages, data availability is covered by same permissions as for Published, Unrestricted pages, and additional requirements that the user must pass the restrictions, e.g., age or region, enforced for the Page.

Specific Permissions

The following shows the permissions, Tasks, or Features potentially required for each table or view. Whether each column is strictly required depends on your use case. Note that whether Page Permissions, Page Task, and Page Features are required depends on the status of the Page on Facebook and on the ownership relationship of the application user to the Page.

Table or View Name User or Non-Page Permissions Page Permissions Page Task Page Feature
Comments permissions for parent entity permissions for parent entity, pages_read_engagement, or pages_read_user_content MODERATE PPCA
Events N/A pages_read_engagement, pages_read_user_content, or pages_manage_metadata N/A N/A
Groups conditionally group_access_member_info N/A N/A N/A
InsightsByConsumptionType N/A read_insights or pages_read_engagement ANALYZE N/A
InsightsByFeedbackType N/A read_insights or pages_read_engagement ANALYZE N/A
InsightsByLikeSourceType N/A read_insights or pages_read_engagement ANALYZE N/A
InsightsByReactionTotals N/A read_insights or pages_read_engagement ANALYZE N/A
InsightsByStoryType N/A read_insights or pages_read_engagement ANALYZE N/A
InsightsByTabType N/A read_insights or pages_read_engagement ANALYZE N/A
InsightsByUnlikeType N/A read_insights or pages_read_engagement ANALYZE N/A
InstagramAccountInsights instagram_basic and instagram_manage_insights N/A N/A N/A
Likes permissions for parent entity N/A N/A N/A
PageAndPostInsights N/A read_insights or pages_read_engagement ANALYZE N/A
Pages pages_show_list pages_read_engagement or pages_read_user_content, pages_show_list MODERATE PPCA,PPMA
Photos user_photos pages_read_engagement or pages_read_user_content MODERATE N/A
Places user_location N/A N/A N/A
Posts user_posts pages_read_engagement or pages_read_user_content MODERATE, CREATE_CONTENT, or MANAGE PPCA
Ratings N/A pages_read_user_content MODERATE, CREATE_CONTENT, or MANAGE N/A
SimpleVideoInsights N/A read_insights or pages_read_engagement ANALYZE N/A
StoryAttachments permissions for parent entity permissions for parent entity N/A N/A
TaggedBy N/A pages_read_user_content, pages_show_list MODERATE, CREATE_CONTENT, or MANAGE N/A
Users public_profile, user_location N/A N/A N/A
VideoInsightsByActionType N/A read_insights or pages_read_engagement ANALYZE N/A
VideoInsightsByDistributionType N/A read_insights or pages_read_engagement ANALYZE N/A
VideoInsightsByReactionType N/A read_insights or pages_read_engagement ANALYZE N/A
Videos user_videos or user_posts pages_read_engagement or pages_read_user_content MANAGE PPCA
Wall user_posts pages_read_engagement or pages_read_user_content MODERATE, CREATE_CONTENT, MANAGE PPCA

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060