Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Requesting two fields to be included in facebook pages schemas

Answered
Saumya Raj User

I am not able to find views and permalink_url in any table whereas i am getting it for videos post only for those records which are in table page_video_history.

All videos data are not there in this table. Videos which are updated once that only have gone to this table. Also i am not getting views for videos as well.
there is a column as views in page_video_history table so i got views data for those, but from where will i get views and Permalink data for photos, story and videos

there is no such column in any other table apart from page_video_history.
If post_history table will contain these two fields then it will be easy for us to fetch

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Saumya, 

    Luke from the Product team here. Thanks for submitting this request. 

    You can get views data for videos associated to posts using the DAILY_POST_METRICS_BY_TOTAL table. That table contains the metric post_video_views. 

    We use this endpoint to populate PAGE_VIDEO_HISTORY: https://developers.facebook.com/docs/graph-api/reference/video. If a video is not available in that table, I assume it is related to one of the restrictions Facebook has for that endpoint:

    • A Page access token can read all videos posted to or posted by that Page.
    • A User access token can read any video your application created on behalf of that User.
    • A User's videos can be read if the owner has granted the user_videos or user_posts permission.
    • A User access token may read a video that User is tagged in if the User granted the user_videos or user_posts permission. However, in some cases the video owner's privacy settings may not allow your application to access it.
    • The source field will not be returned for Page-owned videos unless the User making the request is an admin of the owning Page.

    Our support team can confirm whether this GraphQL endpoint is returning data for the missing video_ids.

    Facebook's APIs also have unexpected behavior when assets/videos are used across Ads and Pages. If the missing videos were used in Ads, you could try setting up our Facebook Ads connector and check for them in the AD_VIDEO_HISTORY. 

    Hope that helps. 

    Cheers,
    Luke