Skip to main content Skip to complementary content

Facebook Pages 

Facebook Pages allows businesses to interact with customer on the Facebook social media platform. You can use Facebook Pages as a data source when landing or replicating data.

Supported update methods

For more information, see An overview of target update methods.

  • Change data capture (CDC)

  • Reload and compare

  • Change data capture (CDC) using Change Tables

  • Full load

  • Change data capture (CDC)

  • Reload

Preparing for authentication

To access your Facebook Pages data, you need to authenticate the connection with your account credentials.

Create an app

  1. Go to https://developers.facebook.com/apps/.

  2. Click Create an app, select app type Business, and click Continue.

  3. Set App Display Name to Qlik.

  4. Set the app purpose appropriately for your use case.

  5. Set Do you have a Business Manager account to the business manager account that you want to use.

  6. Click Create App.

Generate an access token:

  1. Go to https://developers.facebook.com/tools/explorer.

  2. Set Facebook App to Qlik.

  3. Click Generate Access Token.

  4. Click Add a Permission, and select the following:

    pages_read_engagement

    pages_show_list

    read_insights

  5. Click Generate Access Token and follow the instructions to authorize the app.

Get App ID and App Secret

  1. Go to https://developers.facebook.com/apps/

  2. On the top left of the screen under Dashboard, click Settings.

  3. Click Basic.

Creating the connection

For more information, see Connecting to SaaS applications.

  1. Fill in the required connection properties.
  2. Provide a name for the connection in Connection name.

  3. Select Open connection metadata to define metadata for the connection when it has been created.

  4. Click Create.

Connection settings
Setting Description
Data gateway

Select a Data Movement gateway if required by your use case.

Information note

This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.

For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement.

Access Token

The access token you have generated for your app.

App ID

The ID of your Qlik app on Facebook.

App Secret The secret associated with your Qlik app on Facebook.
Page Fields

Comma separated list of the required fields for the Pages dataset.

You can use up to a maximum of 47 fields from the following list:

about, ad_campaign, affiliation, app_id, artists_we_like, attire, awards, band_interests, band_members, best_page, bio, birthday, booking_agent, built, business, can_checkin, can_post, category, category_list, checkins, company_overview, connected_instagram_account, connected_page_backed_instagram_account, contact_address, copyright_attribution_insights, copyright_whitelisted_ig_partners, country_page_likes, cover, culinary_team, current_location, delivery_and_pickup_option_info, description, description_html, differently_open_offerings, directed_by, display_subtext, displayed_message_response_time, emails, engagement, fan_count, featured_video, features, followers_count, food_styles, founded, general_info, general_manager, genre, global_brand_page_name, global_brand_root_id, has_added_app, has_transitioned_to_new_page_experience, has_whatsapp_business_number, has_whatsapp_enterprise_number_using_cloud_api, has_whatsapp_number, hometown, hours, impressum, influences, instagram_business_account, is_always_open, is_chain, is_community_page, is_eligible_for_branded_content, is_messenger_bot_get_started_enabled, is_messenger_platform_bot, is_owned, is_permanently_closed, is_published, is_unclaimed, leadgen_tos_accepted, leadgen_tos_accepting_user, link, location, members, merchant_review_status, messaging_feature_status, messenger_ads_default_icebreakers, messenger_ads_default_page_welcome_message, messenger_ads_default_quick_replies, messenger_ads_quick_replies_type, mission, mpg, name, name_with_location_descriptor, network, new_like_count, offer_eligible, overall_star_rating, page_token, parking, payment_options, personal_info, personal_interests, pharma_safety_info, phone, pickup_options, place_type, plot_outline, preferred_audience, press_contact, price_range, privacy_info_url, produced_by, products, promotion_eligible, promotion_ineligible_reason, public_transit, rating_count, recipient, record_label, release_date, restaurant_services, restaurant_specialties, schedule, screenplay_by, season, single_line_address, starring, start_info, store_code, store_location_descriptor, store_number, studio, supports_donate_button_in_live_video, talking_about_count, temporary_status, differently_open, unread_message_count, unread_notif_count, unseen_message_count, username, verification_status, voip_info, website, were_here_count, whatsapp_number, written_by

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!