Welcome Guest, you are in: Login

QVSource: The QlikView & Qlik Sense API Connector (Docs)

This page describes how to upgrade your load scripts from using V1 of the Facebook Fan Pages And Groups Connector to use the newer V2.


We would recommend you take a copy of your existing production QlikView applications which use this connector, apply the following changes and then run in parallel for a number of days until you are satisfied that it is working correctly before replacing your production applications with the upgraded versions.

Step 1 - Update the Connector Version

You current load scripts will contain a line something like:
FROM
[http://localhost:5555/QVSource/FacebookFanPagesConnector/?table=....]

You simply need to change this to:
FROM
[http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=....]

(Notice the addition of V2).

Step 2 - Ensure you are using the correct response format

By default, v1 of this connector generated load script which returned data as a html table. So, for example, a typical v1 request might look like this:


FacebookFanPagesConnector_Page:
LOAD
	page as page,
	updated_time as Page_updated_time,
	timestamp#(mid(updated_time, 1, 10) & mid(updated_time, 12, 8), 'YYYY-MM-DDhh:mm:ss') as Page_updated_time_qvdatetime,
	...
	page_id as Page_page_id,
	can_post as Page_can_post,
	email as Page_email
FROM
[http://localhost:5555/QVSource/FacebookFanPagesConnector/?table=Page&appID=&format=html]
(html, utf8, embedded labels, table is @1);

Notice the format=html parameter in the request to QVSource and the corresponding (html, utf8, embedded labels, table is @1); QlikView load script set to load this as a html table.

By default, v2 of this connector returns data in QVX format and does not include a format=?? parameter in the request. Therefore the above script would be converted to:

FacebookFanPagesConnector_Page:
LOAD
	page as page,
	updated_time as Page_updated_time,
	timestamp#(mid(updated_time, 1, 10) & mid(updated_time, 12, 8), 'YYYY-MM-DDhh:mm:ss') as Page_updated_time_qvdatetime,
	...
	page_id as Page_page_id,
	can_post as Page_can_post,
	email as Page_email
FROM
[http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=Page&appID=]
(qvx);

Notice:
  • The format parameter has been removed (you could also set this explicitly to format=qvx however this is the default so is not needed).
  • (html, utf8, embedded labels, table is @1) has been updated to (qvx).
  • V2 has been added to the connector name as per the step above.

Step 3 - Check For Breaking Changes

V2 of this Connector uses the new v2.0 of the Facebook Graph API. Some breaking changes were made by Facebook in this update and consequently these changes impact QVSource and are listed below.


Step 4 - Check for New Functionality

The new v2 of this Connector has some additional tables, including Messages and Post, and additional columns on some existing tables. Check out the change log for full details.


(QVSource works with Qlik Sense as well as QlikView - See this page for notes.)
QVSource - The QlikView & Qlik Sense API Connector | © Copyright 2011 - 2016 Industrial CodeBox Ltd