Facebook Fan Pages

The Qlik Facebook Fan Pages Connector loads data from the Facebook Graph API into your Qlik apps, allowing you to extract data from Facebook Pages.

Note:

This connector uses version v2.11 of the Facebook API.

Tip:

The Qlik Web Connectors help you connect to different data sources and fetch data in the same way. Learn how to authenticate a data source connection and how to use tables to fetch data.

Connecting to data sources

Ways to access your data

To use the Qlik Facebook Fan Pages Connector, you must have a Facebook account with which to authenticate the connector.

To obtain an authentication token, use the CanAuthenicate table. first select the Facebook Fan Pages Connector and then click Authenticate. You will be redirected to a Facebook login page where you will receive an authentication token that you can paste into the connector.

Name your connection and then click Test Connection to verify that the connection will work with the authentication token you entered.

Warning: The authentication token that is created is only valid for 60 days, after which you will need to authenticate again. The exact date is displayed above the authentication token and it is recommended that you set a calendar alert for this.

Tables

After authenticating the connector, the following tables are available.

Table Description
Page Returns a single page.
UserOrPage Attempts to look up details for the object ID passed. If no type is specified it will first assume it is a user and fall back on a page.
Feed Returns the feed of posts (including status updates) and links published by this page, or by others on the page.
LikesForItem Returns the user objects representing each of the people who liked the object.
CommentsForItem Returns the comments objects for the object ID.
CommentsAndRepliesForItem Returns the comments objects for the object ID, including the comment replies.
UserInfo Returns a single user.
Feed Returns the feed of posts (including status updates) and links published by this page, or by others on the page.
Page Returns a single page.
UserInfo Returns a single user.

Information on each of the parameters used in the tables can be found by hovering the mouse pointer over the ] icon

Obtaining the Fan Page ID

To obtain the Facebook Fan Page object ID of a page that you administer, which you will need to enter into this connector, browse to the page in Facebook.

If the Facebook page has a vanity URL, like www.facebook.com/chuckie, then enter the value chuckie into the Page ID text box. If the Facebook page URL has a numeric identifier then enter the number into the Page ID text box.

You should be able to find the ID of other Facebook object types using this technique or when viewing the built in Facebook Insights dashboard for the object.

Obtaining an Object ID

This ID represents objects that you may find on a Facebook page, such as a feed item or comment. To find these, you have to run a table that returns items on a page. For example, the Feed table takes the Page ID and returns all the Feeditems, and there you can find the ID of a Feeditem.

In turn the Feeditem ID can be used in the LikesForItem table to return the number of Feeditem Likes.

Troubleshooting

Getting a list of all users who liked a page

This is not possible as it is not supported by the Facebook API. According to Facebook, this is by design.

Accessing closed or private groups

Due to updates in the Facebook API and their access policy, this connector no longer supports closed or private groups.

Did this information help you?

Can you tell us why it did not help you and how we can improve it?