How to extract facebook data from Qliksense
How to extract facebook data from Qliksense,the approach of facebook data pull from Qliksense is different from other BI tools.It uses the REST API Connector.
Install the Rest API Connector in Qliksense
Open Qliksense ,Create New App and click “Add Data”
Step 3 :
To connect to facebook,its important to create APP in -developer.Please refer the following video to create app in Facebook
Once,you have valid Facebook App ID,in Facebook click the App ID and get the Access Token
Select the data fields required from facebook Graph API
Copy the complete link from Graph API link as follows.
Paste the URL in data wizard of Rest API in Qliksense
In the Rest API wizard, keep pagination as none and keep the Sequence ID as follows to keep the primary and foreign key relationships intact.
Add a query parameter with the value set.value should be same as access token.hence,copy and paste the access token
Step 9: Create the name for the new connection and extract tables from facebook
Create a new sheet and add the data & pull required fields in the report.