QVSource is now part of Qlik Connectors

We are excited to announce that Qlik Web connectors will be launched in early July - the release of the QVSource portfolio within the Qlik Connectors product suite. After Industrial CodeBox was acquired by Qlik in April of 2016, we have spent the last couple of months getting our product ready to be delivered and sold as a standalone Qlik product for both QlikView and Qlik Sense.

This release is focused on the rebranding of the product, and moving to Qlik’s infrastructure, including licensing, documentation and support – with limited updates to the functionality from the QVSource Web Edition 1.0.3. release on April 27. The pricing structure will be simplified as a part of this release. The available connectors will continue to be divided into Standard and Premium connectors. But Standard connectors will be made available for free, and the Premium connectors on a flat per connector annual subscription. Note that beta connectors will no longer be shipped with the product. We will be announcing a revisited program for beta connectors shortly.

In addition, it’s important to note that as of as of July 5th 2016 Qlik support will officially take over support for existing QVSource Customers and Partners. Here is what you need to know:

  • All support inquiries should be managed using the Qlik Support Portal, starting on July 5th 2016
  • Support at QVSource should no longer be used, instead use the support portal.
  • QVSource will eventually be retired and there will be no further development to this product; with this, we strongly recommend that you upgrade to Qlik Web Connectors, which will replace QVSource.
  • If you have an open support ticket with Industrial CodeBox, it will not be transferred to Qlik Support, but it will be managed by ICB until it’s closed

We are now turning our attention to work closely with the rest of Qlik’s product management team to jointly develop an updated roadmap. There are many exciting possibilities we will be considering including a tighter integration with the core Qlik Sense product and related capabilities as well as deploying our connector capabilities into the Cloud.

Stay connected via Qlik’s blog moving forward!

QVSource Web Edition 1.0.3 Now Available

(This blog post originally appeared on the QVSource blog here.)

We are delighted to announce the availability of a new version of QVSource - The QlikView and Qlik Sense API Connector!

We have only released an update of the Web Edition this time (version 1.0.3) as the WinForms edition is now deprecated and will no longer be supported after the 22nd May 2016. If for some reason you are unable to upgrade to the Web Edition please contact us and explain, otherwise please now use the new and improved Web Edition of QVSource if you are not already.

Updates Since 26 Feb 2016 (Previous 1.0.1 Release)

The following updates have been made to the QVSource Core and Web UI as well as the connectors listed.

Please pay particular attention to any connectors which may have breaking changes highlighted below.

Azure Data Marketplace Connector (Includes Breaking Changes)
bitly Connector (v2)
Box Connector
Dropbox Connector (v2)
Exact Online Connector
Facebook Fan Pages & Groups Connector (v2)
Facebook Fan Pages & Groups Connector (v3)
Facebook Insights Connector (v3)
File Transfer Connector (FTP/SFTP)
Google AdWords Connector (v2)
Google Calendar Connector
Google Drive & Spreadsheets Connector
Google Webmaster Tools Connector
MailBox Connector (IMAP/POP3)
MS CRM Connector
Office 365 Sharepoint Connector (Includes Breaking Changes)
OneDrive Connector (Includes Breaking Changes)
Salesforce Connector (v2)
SurveyMonkey Connector
Sentiment Analysis & Text Analytics Connector (v2)
Web Connector for General JSON/XML/SOAP APIs (v2)

Core Engine

  • Improved error messages for errors during string decryption (e.g. from stored settings or URL parameters). (29 Mar 2016)
  • Fixed bug with Version element in log files being set to 0.0 rather than actual 'engine' version. (10 Mar 2016)
  • File extension for error logs changed from .xml to .txt. (10 Mar 2016)
  • Added response_time column to all Google Connector CanAuthenticate tables. (03 Mar 2016)
  • application/xml rather than text/xml now used throughout for tables which write a raw XML response. (26 Feb 2016)

General & Web User Interface

  • The Instagram Connector has been removed (applications now have to apply for API and our initial application has been unsuccessful). The current connector will stop working in June 2016. (22 Apr 2016)
  • The Yahoo! Placemaker Connector has been removed (underlying API is being shut down). (22 Apr 2016)
  • Improve warning and error messages for licence file upload. (17 Mar 2016)
  • More helpful error messages now for various invalid table requests (e.g. loadAccessToken missing). (13 Mar 2016)
  • File extension for error logs changed from .xml to .txt. (13 Mar 2016)
  • Fixed user management API caching bug. (11 Mar 2016)
  • OAuth tokens in UI are now obfuscated. (02 Mar 2016)
  • Support tab now loads asynchronously (and does not degrade page load time). (29 Feb 2016)
  • Upgraded to NancyFX 1.4.3. (29 Feb 2016)
  • Upgraded to Angular JS 1.5.0. (29 Feb 2016)
  • Fixed table rendering bug in IE9. (29 Feb 2016)

Azure Data Marketplace Connector

  • BREAKING CHANGE: We have updated/changed the OAuth Client ID. You will need to reauthenticate with the connector and update any embedded tokens you may have in your request URLs. (12 Apr 2016)

bitly Connector (v2)

  • Fix missing permissions. (09 Mar 2016)

Box Connector

  • Fix UserEvents source_path, add in a few missing columns for UserEvents and EnterpriseEvents. (16 Mar 2016)

Dropbox Connector (v2)

  • Updated Metadata table to use dropboxPath parameter instead of dir parameter. (22 Mar 2016)
  • Updated UploadFile table to use uploadPath parameter instead of dropboxPath parameter. (22 Mar 2016)
  • Added CanAuthenticate table. (03 Mar 2016)
  • Added recursive, include_media_info, include_deleted params to List table. (03 Mar 2016)
  • Added notes for id:XXX rev:XXX values for the Path parameter. (03 Mar 2016)
  • Added mode, auto rename and mute params to UploadFile table. (03 Mar 2016)
  • Added Usage table. (03 Mar 2016)
  • Added Metadata table. (03 Mar 2016)
  • Added Revisions table. (03 Mar 2016)
  • Added Search table. (03 Mar 2016)
  • Added DownloadFile table. (03 Mar 2016)

Exact Online Connector

  • Remove note about save/run before authenticating. (07 Mar 2016)

Facebook Fan Pages & Groups Connector (v2)

  • NOTE this version (V2) of this connector is now deprecated. New users should use V3 of this connector and existing users should begin upgrading to V3. V2 will no longer work after 7th August 2016. (31 Mar 2016)
  • Max Items Per API Request (maxItemsPerPage) parameter added to most tables which return paged results. We would only recommend setting this to a lower value of the default of 100 if you are receiving an error. (31 Mar 2016)
  • Max API Calls/Second (maxAPICallsPerSecond) will now accept a decimal number. So for example you can enter 0.5 to allow only one API request every two seconds. (31 Mar 2016)

Facebook Fan Pages & Groups Connector (v3)

  • Added talking_about_count column to Page table. (28 Mar 2016)

Facebook Insights Connector (v3)

  • Drop down of pages should no longer be limited to first 25. (08 Apr 2016)

File Transfer Connector (FTP/SFTP)

  • Upgraded to latest (2016 R1.1) of RebEx. (17 Mar 2016)

Google AdWords Connector (v2)

Google Calendar Connector

  • Added new EventAttendees table. (08 Apr 2016)

Google Drive & Spreadsheets Connector

  • GetSpreadsheet table now downloads data as CSV instead of TSV internally which was used previously. This may resolve occasional issues with parsing cells which contain combinations of ,'s and "'s. (19 Mar 2016)
  • GetSpreadsheet table will now retry once after a 10s wait in the case of a 429 error response (and also still wait 1s between successive successful requests). (10 Mar 2016)
  • GetSpreadsheet table will now retry once after a 3s wait in the case of a 429 error response and also wait 1s between successive successful requests. (03 Mar 2016)

Google Webmaster Tools Connector

  • Throw exception if dimensionFilterGroups is included in dimensionFilter parameter. (31 Mar 2016)
  • Added notes to SearchAnalyticsQuery table. (31 Mar 2016)
  • Added responseAggregationType column to SearchAnalyticsQuery table. (31 Mar 2016)
  • Changed parameter mode. (31 Mar 2016)
  • Bump up default row limit to 5000. (31 Mar 2016)

MailBox Connector (IMAP/POP3)

  • Added logging to API call logs. (07 Apr 2016)
  • Fixed memory consumption issue in Web Edition for this connector. (07 Apr 2016)
  • Removed feature to save latest log to cache. (07 Apr 2016)
  • Fixed bug where emails could not be retrieved (XML deserialised) from cache if they contained certain invalid characters (e.g. 0x0B, 0x0C, 0x01). (07 Apr 2016)
  • Removed unnecessary code to get count of emails in ImapMessagesInFolder table. (31 Mar 2016)
  • Added 'Before' input parameter to ImapMessagesInFolder table. (23 Mar 2016)

MS CRM Connector

  • Added OrganisationID, BusinessUnitId, Version, and response_time_ms columns to CanAuthenticate table. (01 Mar 2016)
  • Tweaked progress reporting code. (01 Mar 2016)
  • Warn message now also logged if the .TotalRecordCount is not returned (which is not expected). (01 Mar 2016)
  • Added new maxRows parameter. (01 Mar 2016)
  • Added API call logging. (26 Feb 2016)
  • Improved progress feedback (including total count) and cancellability of running table. (26 Feb 2016)

Office 365 Sharepoint Connector

  • Remove note about save/run before authenticating. (07 Mar 2016)
  • Fixed bug with duplicated logging of API calls. (03 Mar 2016)
  • Fixed bug in code to download lists (ListItemsFromID and GetDataFeed tables). (02 Mar 2016)
  • ListItemsFromID table now defaults to downloading data in pages of 1000 items at a time (instead of 100) and we have also added a note recommending that ?$top=1000 is added to the end of the feed parameter for the GetDataFeed table. (02 Mar 2016)
  • Removed max results parameter from GetFile table. (02 Mar 2016)
  • BREAKING CHANGE: ListResources renamed to Lists. (29 Feb 2016)
  • BREAKING CHANGE: GetData renamed to ListItemsFromID. (29 Feb 2016)
  • Added ListFolders and ListFiles tables. (29 Feb 2016)
  • Added GetFile table. (29 Feb 2016)

OneDrive Connector

  • BREAKING CHANGE: We have updated/changed the OAuth Client ID. You will need to reauthenticate with the connector and update any embedded tokens you may have in your request URLs. (12 Apr 2016)
  • Minor update to OAuth redirect URL. (29 Feb 2016)

Salesforce Connector (v2)

  • Use specific instance if available for APIVersions. (04 Apr 2016)
  • Removed XPATH parameter from RequestRawXml table (where it was never used). (26 Mar 2016)
  • RequestRawXml no longer errors when application/json is returned from the API request but converts this to XML. (23 Mar 2016)

SurveyMonkey Connector

  • Add GetResponses table. (15 Mar 2016)
  • Fix missing permissions. (09 Mar 2016)

Sentiment Analysis & Text Analytics Connector (v2)

  • Added EmotionAnalysis table to AlchemyAPI provider. (08 Apr 2016)

Web Connector for General JSON/XML/SOAP APIs (v2)

  • The JsonToXmlRaw and JsonToTable tables should now better handle cases where JSON contains double colons and $'s in element names (e.g. {"$", "value"} or {"name1::name2", "value"}). (06 Apr 2016)

Download Latest

Where do I find this new release? If you are a QVSource customer or have requested a trial in the past you should see this new release in the personalised download link we should have sent you via email.

If you are new to QVSource you can download a fully functional free trial from our website. As noted above though, we would strongly recommend you use the new Web Edition download (which contains the above updates also).

QVSource Web Edition 1.0.1 Now Available

(This blog post originally appeared on the QVSource blog here.)

We are delighted to announce the availability of a new version of QVSource - The QlikView and Qlik Sense API Connector!

We have released an update of both the WinForms Edition (version 1.6.9) and the new Web Edition (version 1.0.1). However, as noted in an earlier post, the WinForms edition is now officially deprecated and will no longer be supported after the 22nd May 2016. Therefore we would strongly recommend you now start working with the Web Edition if you are not already.

IMPORTANT - Upgrade to .NET 4.5.2

There has been a key update to these latest releases - you will now need to ensure you have the .NET Framework 4.5.2 installed on your machine (rather than .NET 4.0 which was required previously). If you do not already have it you can access it here.

New Connectors

Note that we have the first version of a brand new connector to Office 365 Sharepoint.

We also have a new V3 version of the Facebook Fan Pages & Groups Connector, V2 is now deprecated and we would advise all users to start working with the new V3 which works with the latest version of the Facebook Graph API.

Finally, we have a new V2 of the DropBox Connector which replaces V1 (although it is essentially the same, it simply uses their latest API).

All Updates (Since 24th Nov 2015)

The following updates have been made to the QVSource Core and Web UI as well as the connectors listed.

Please pay particular attention to any connectors which may have breaking changes highlighted below.

Adobe Analytics (Omniture) Connector
Amazon S3 Connector
Blue Yonder Connector
Box Connector
Dropbox Connector (v2)
Facebook Fan Pages & Groups Connector (v2)
Facebook Fan Pages & Groups Connector (v3)
Facebook Insights Connector (v3)
File Transfer Connector (FTP/SFTP)
FreeAgent Connector (v2)
Google AdWords Connector (v2)
Google BigQuery Connector
Google DoubleClick For Advertisers (DFA) Connector
Google DoubleClick for Publishers (DFP) Connector (Includes Breaking Changes)
Google Prediction Connector
Google Webmaster Tools Connector
Helper Connector
Instagram Connector
Klout Connector (v2)
MailBox Connector (IMAP/POP3)
MailChimp Connector (v2) (Includes Breaking Changes)
MongoDB Connector (v2)
MS CRM Connector (Includes Breaking Changes)
Notification Connector
OData Connector (V2)
Office 365 Sharepoint Connector
OneDrive Connector
SugarCRM Connector
SurveyMonkey Connector
Sentiment Analysis & Text Analytics Connector (v2) (Includes Breaking Changes)
Twitter Connector (v2)
Web Connector for General JSON/XML/SOAP APIs (v2) (Includes Breaking Changes)
Yahoo! Placemaker Connector
YouTube Analytics Connector
YouTube Connector (v3)

Core Engine

  • application/xml rather than text/xml now used throughout for tables which write a raw XML response. (26 Feb 2016)
  • Updated WinForms version of Web Server so that the connector ID can now be passed in as a query parameter instead of part of the path. So for example http://localhost:5555/QVSource/Connect/?connectorID=TwitterConnectorV2&table=Search&... can be used in place of http://localhost:5555/QVSource/TwitterConnectorV2/?table=Search&... This has been done so that we can explore working via the new Qlik REST Connector. (23 Feb 2016)
  • Added new format=json option. (23 Feb 2016)
  • Fixed bug in processParamsSync feature (See http://wiki.qvsource.com/Synchronous-Asynchronous-And-Batch-Requests-Explained.ashx). (16 Feb 2016)
  • RC3 for new public release. (11 Feb 2016)
  • Short URL Expander Removed. (11 Feb 2016)
  • Added first version of Office 365 Sharepoint Connector. (08 Feb 2016)
  • Added DropBox V2 Connector. (08 Feb 2016)
  • IMPORTANT: Upgraded to .NET version 4.5.2 (previously 4.0 was used). (07 Feb 2016)
  • Connectors which use one or more SOAP requests should now correctly pick up configured Proxy (e.g. RPS Connector, DFP Connector and AdWords Connector). (07 Feb 2016)
  • POTENTIALLY BREAKING CHANGE: We had some custom code to replace certain special characters which are valid JSON but invalid XML with safe values for XML. We have now removed this code and internally use some system level .NET code which should account for all potential invalid values but now uses different replacements. These replaced values might ultimately end up being table column names depending on whether you are using a connector table which provides raw XML or a structured table and you may need to adjust your scripts accordingly according to the following. This is actually a QVSource wide change but the most likely place it will impact is in certain specialist uses of the General Web Connector. (22 Dec 2015)
  • Fixed threading issue which may cause QVSource to crash if status page (e.g. at http://localhost:5555/qvsource) was requested while application was still starting up and registering connectors. (22 Dec 2015)
  • All multi line inputs now (e.g. JSON and XML inputs and some string inputs, e.g. the POST parameter on the Web Connector) can now accept an @file=c:\path\to\file.txt input so that the contents can be more easily managed in an external file. This can be used in conjunction with the ReplaceTokensInFile table of the Helper Connector (http://wiki.qvsource.com/Helper-Connector.ashx#ReplaceTokensInFile_Table_0) which can be used to modify this file before it is read. (11 Dec 2015)
  • RC for new release. (11 Dec 2015)
  • Updated to reference Newtonsoft v7 externally. (05 Dec 2015)
  • Added deprecated message to WinForm title text and also about and licence text areas. (02 Dec 2015)

Web User Interface

  • If there is an error response from the API in XML or JSON format when running a table in the UI, this should now be shown to the user. (25 Feb 2016)
  • RC4 for new public release. (14 Feb 2016)
  • Column aliases in generated load script should now have _ after table name. (13 Feb 2016)
  • RC3 for new public release. (11 Feb 2016)
  • Short URL Expander Removed. (11 Feb 2016)
  • IMPORTANT: Upgraded to .NET version 4.5.2 (previously 4.0 was used). (08 Feb 2016)
  • Added first version of Office 365 Sharepoint Connector. (08 Feb 2016)
  • Added DropBox V2 Connector. (08 Feb 2016)
  • RC2 for new public release. (08 Feb 2016)
  • RC for new public release. (03 Feb 2016)
  • : characters in table column names and generated script (which break QlikView/Qlik Sense load script) should now be replaced with underscores _. (14 Jan 2016)
  • @file=c:\path\to\file.txt style inputs can now be used on multi line inputs to have their values populated from file. See http://wiki.qvsource.com/Multi-Line-Input-Parameters.ashx for more information. (17 Dec 2015)
  • Removed (beta) text from footer. (26 Nov 2015)
  • Fixed check for updates feature on about tab. (26 Nov 2015)
  • Changed MIME type for QVX response which means it should now be rendered in browser again (as in earlier beta versions) rather than being downloaded as a file. (26 Nov 2015)
  • Added warning for IE9 or earlier. (26 Nov 2015)
  • Fixed bug with boolean input parameters not saving correctly on tables. (26 Nov 2015)
  • Fixed issue with CSV file download not always correctly escaping commas and quotes. (26 Nov 2015)
  • The 'Show All' connector settings (on the My Settings tab) should no longer show empty values. (26 Nov 2015)
  • Minor fix to startup code which logs errors instantiating connectors. (24 Nov 2015)

Adobe Analytics (Omniture) Connector

  • Minor refactoring of web exception handling. (07 Dec 2015)

Amazon S3 Connector

  • Added paging to ListObjects table. (25 Nov 2015)

Blue Yonder Connector

  • Minor internal note renaming. (13 Feb 2016)
  • Minor update so that there is now a maximum of 3 concurrent requests across all instances of the connector. (01 Dec 2015)

Box Connector

  • Updated EnterpriseEvents table in line with Box API updates. (17 Feb 2016)

Dropbox Connector (v2)

  • Updated to use V2 Dropbox API for all tables. (10 Feb 2016)

Facebook Fan Pages & Groups Connector (v2)

  • This has now been tagged as deprecated as we have started work on a new V3 of this Connector. There is no intention to remove this connector in the next 6 months, tagging as deprecated at this stage is primarily intended to encourage any new users of the product to start with the new V3 of the Connector. (04 Feb 2016)
  • Added more helpful error message when connector not authenticated. (07 Jan 2016)
  • Minor refactoring of web exception handling. (07 Dec 2015)

Facebook Fan Pages & Groups Connector (v3)

  • Added 'status' column to User, Page and UserOrPage tables. If the table runs successfully this column will contain the string 'OK', otherwise it will contain the error message. (13 Feb 2016)
  • Removed maxPerRequest param. (09 Feb 2016)
  • Added first version of UserOrPage table. (09 Feb 2016)
  • Internal refactoring and caching enhancemenents. (09 Feb 2016)
  • Added caching for Type table. (09 Feb 2016)
  • Pictures should now be rendered in table in Web Edition (if enabled in settings). (08 Feb 2016)
  • Added Type table. (31 Jan 2016)
  • Added more helpful error message when connector not authenticated. (07 Jan 2016)
  • Initial release of V3. (18 Dec 2015)

Facebook Insights Connector (v3)

  • Minor internal refactoring/performance improvements (for Web Edition). (20 Feb 2016)
  • Removed dependency on Microsoft.VisualBasic assembly on startup. (02 Feb 2016)
  • Added more helpful error message when connector not authenticated. (07 Jan 2016)
  • Upgraded to version 2.5 of the Facebook Graph API. (17 Dec 2015)
  • Minor refactoring of web exception handling. (07 Dec 2015)
  • Updated Page ID drop down to show "global_brand_page_name (id)" in dropdown rather than just "name" (which is not always unique). (03 Dec 2015)
  • Web Edition now shows page picker dropdown. (03 Dec 2015)

File Transfer Connector (FTP/SFTP)

FreeAgent Connector (v2)

  • Minor refactoring of web exception handling. (07 Dec 2015)

Google AdWords Connector (v2)

  • Minor internal refactoring. (07 Feb 2016)
  • Upgraded to v201601 of the API. See https://developers.google.com/adwords/api/docs/reference/#v201601 for notes on relevant updates to reporting. (03 Feb 2016)
  • Added extra note to Report tables about looking up territory names from numerical IDs. (16 Dec 2015)
  • Minor refactoring of web exception handling. (07 Dec 2015)

Google BigQuery Connector

  • Default timeout increased to 30 minutes. (22 Feb 2016)
  • Added TableSchemaAsXml table. (22 Feb 2016)

Google DoubleClick For Advertisers (DFA) Connector

Google DoubleClick for Publishers (DFP) Connector

Google Prediction Connector

  • Minor internal refactoring. (15 Feb 2016)
  • Removed dependency on Microsoft.VisualBasic assembly. (02 Feb 2016)

Google Webmaster Tools Connector

  • Fixed encoding of siteUrl by targeting .NET4.5 and removing previous workaround that did not work for https sites. (12 Feb 2016)

Helper Connector

  • Added a Tokens File input parameter to the ReplaceTokensInFile table which allows you to also specify a list of tokens and replacement values in a separate file (which could, for example, be created using the Qlik store (txt) command). (22 Dec 2015)
  • Added ReplaceTokensInFile table. (15 Dec 2015)

Instagram Connector

  • User Name is now required for UserSearch table. (11 Feb 2016)

Klout Connector (v2)

  • Internal refactoring and performance improvements (minor). (01 Dec 2015)
  • Table names are now case sensitive (as with most connectors). (01 Dec 2015)
  • Minor refactoring of web exception handling. (01 Dec 2015)
  • Removed old table name mappings (from 2012 version of Connector). (01 Dec 2015)

MailBox Connector (IMAP/POP3)

  • Mail IDs used in cache keys are now hashed. (16 Feb 2016)
  • html columns are now rendered as encoded html when running in Web Edition UI (previously the html was rendered inside the data table preview). (29 Jan 2016)
  • Added additional notes to the Username and Password parameters to explain that these can be deleted from the generated URL to have the values stored in settings to be picked up by default instead. (29 Jan 2016)
  • Added seen and flags columns to the ImapMessagesInFolder table. (04 Jan 2016)
  • Added a new checkbox input parameter 'Allow Self Signed Client Certificate'. You might wish to check this if you are receiving an 'The remote certificate is invalid according to the validation procedure' error or other certificate related error as long as you are sure you are connecting with the correct server. (08 Dec 2015)

MailChimp Connector (v2)

  • BREAKING CHANGE: The API Key input parameter is now set to be encrypted. If you are using this connector you should regenerate a load request and copy the value of the newly updated/encrypted APIKey= parameter to your load URLs. Alternatively, if you simply remove this parameter from your load URLs the value stored in settings will be used. Note that you can also use the Encrypt table in the Hepler Connector to create the encrypted value on the fly. (13 Feb 2016)

MongoDB Connector (v2)

  • Please note that as a new official BI Connector (https://docs.mongodb.org/manual/products/bi-connector/) is now available for MongoDB 3.2 and later you may wish to first consider this. Because of this we are also now considering retiring this connector if it does not offer any advantages over this. (10 Dec 2015)
  • Upgraded to MongoDB Driver 1.11.0. This should now support version 3.0 of MongoDB. (10 Dec 2015)
  • Fixed bug where if 'Max Number Of Rows' input parameter was set, the connector would still first inspect all documents in collection to establish column structure for table, now it will only inspect the first 'Max Number Of Rows' documents. (10 Dec 2015)

MS CRM Connector

  • Added API call logging. (26 Feb 2016)
  • Improved progress feedback (including total count) and cancellability of running table. (26 Feb 2016)
  • BREAKING CHANGE: The connection string input parameter is now set to be encrypted. If you are using this connector you should regenerate a load request and copy the value of the newly updated/encrypted connectionString= parameter to your load URLs. Alternatively, if you simply remove this parameter from your load URLs the value stored in settings will be used. Note that you can also use the Encrypt table in the Hepler Connector to create the encrypted value on the fly. (12 Feb 2016)
  • Input parameter "Check All Data For Columns" set as optional now. (02 Feb 2016)
  • Minor refactoring. (27 Jan 2016)
  • Added new input parameter "Check All Data For Columns". Previously, if certain columns did not appear in the first 5000 rows of data they would not be included in the results at all. Checking this new option causes the connector to analyse all pages of results before building the columns which fixes this issue. However, it does mean that all of the data has to be loaded into memory in one go rather than streaming the data in oages of up to 5000 results at a time (which is the behaviour if this new option is not checked). (27 Jan 2016)
  • Minor refactoring. (09 Dec 2015)
  • CanAuthenticate table now gives hint to try https instead of http if the connection throws a null reference exception and URL=http://... is being used rather than URL=https://.... (09 Dec 2015)

Notification Connector

  • Minor internal code refactoring. (17 Dec 2015)

OData Connector (V2)

  • Added optional auth header. (23 Feb 2016)
  • Updated auth parameters to be included in the generated load URL by default. If you delete the parameter values from the generated load URL it will fall back to the value stored in settings. (23 Feb 2016)
  • Added additional info about request URL to warn log entry in the case of XML needing to be sanitised before loading. (23 Feb 2016)
  • Connector now attempts to sanitise XML before loading following a bug report where one OData source included invalid content in XML. (05 Feb 2016)
  • Fix CleanupUrl bug when using file paths. (29 Jan 2016)
  • Removed optional paging type parameter as it is not being used. (30 Nov 2015)

Office 365 Sharepoint Connector

  • Added SubSites table. (25 Feb 2016)
  • Added Sub Site Path parameter to ListResources table. (25 Feb 2016)
  • Added GetData table. (25 Feb 2016)
  • Initial release. (08 Feb 2016)

OneDrive Connector

  • Minor update to improve efficiency for Drives and Items tables. (08 Feb 2016)

SugarCRM Connector

  • Minor refactoring of web exception handling. (08 Dec 2015)
  • Fixed bug where request would hang in certain circumstances for CustomRequest table. (08 Dec 2015)

SurveyMonkey Connector

  • Added other available columns to GetRespondentList table. (22 Feb 2016)
  • Added custom_id column to GetRespondentList table. (12 Jan 2016)
  • Added date_start and date_modified columns to GetRespondentList table. (07 Jan 2016)
  • Connector should now use app wide proxy settings. (16 Dec 2015)

Sentiment Analysis & Text Analytics Connector (v2)

  • Fix to Repustate SentimentChunked table. (13 Feb 2016)
  • BREAKING CHANGES: The embedded API key for AlchemyAPI which was included in previous versions has now been removed. (26 Nov 2015)
  • Minor refactoring of web exception handling. (26 Nov 2015)

Twitter Connector (v2)

  • Fixed bug in Followers table where it made unnecessary API requests and used up all of current quota unnecessarily. (15 Feb 2016)
  • Fixed issue in RateLimit table where _x002F_ was shown in data instead of / character. (08 Feb 2016)
  • Minor internal refactoring. (01 Dec 2015)
  • Fixed issue where Post_XXXX tables would error in web edition. (01 Dec 2015)

Web Connector for General JSON/XML/SOAP APIs (v2)

  • Some parameters no longer unnecessarily appear in the generated URL if they have their default values. (14 Feb 2016)
  • Fixed bug with Encrypt URL input parameter not working in Web Edition. (14 Feb 2016)
  • POSSIBLE BREAKING CHANGE: Removed support for using cleanXML parameter in request URL (see earlier in change log) as this has now been superceded by removeInvalidChars parameter which should be used instead. (04 Feb 2016)
  • Removed 'Remove Invalid Characters' input parameter from JsonToTable and RawXmlToTable tables. (04 Feb 2016)
  • Added code to sanitise XML before processing in the case it might contain invalid characters. (04 Feb 2016)
  • POTENTIALLY BREAKING CHANGE: We had some custom code to replace certain special characters which are valid JSON but invalid XML with safe values for XML. We have now removed this code and internally use some system level .NET code which should account for all potential invalid values but now uses different replacements. These replaced values might ultimately end up being table column names depending on whether you are using a connector table which provides raw XML or a structured table and you may need to adjust your scripts accordingly according to the following. This is actually a QVSource wide change but the most likely place it will impact is in certain specialist uses of the General Web Connector. (22 Jan 2016)
  • Added feature allowing @file=drive:\path\to\file.txt for the POST parameter value so that the connector will pick up the text from here instead of the parameter value itself. This is because occasionally (particularly for SOAP requests) the URL generated to QVSource can be very long and exceed the length supported by QlikView or Qlik Sense. (14 Dec 2015)
  • Last request time (for the minimum time between requests feature) is now stored in settings rather than in memory against connector instance (which fixes compatibility for new web edition). (30 Nov 2015)

Yahoo! Placemaker Connector

  • Minor refactoring of web exception handling. (07 Dec 2015)

YouTube Analytics Connector

  • Added quotaUser parameter to Report and MyChannels tables which helps enforce per user quota limits. (16 Dec 2015)

YouTube Connector (v3)

  • Fixed empty table bug when there are 0 results. (15 Dec 2015)
  • Fixed VideoStatistics API error when using more than 50 video ids. (07 Dec 2015)
  • Fixed ChannelStatistics API error when using more than 50 channel ids. (07 Dec 2015)
  • Return early if no nodes found or all nodes found (in a single API request) are duplicates. (07 Dec 2015)
  • Added optional status info to VideoStatistics table. (02 Dec 2015)
  • Update quota info for VideoStatistics table. (02 Dec 2015)

Download Latest

Where do I find this new release? If you are a QVSource customer or have requested a trial in the past you should see this new release in the personalised download link we should have sent you via email.

If you are new to QVSource you can download a fully functional free trial from our website. As noted above though, we would strongly recommend you use the new Web Edition download (which contains the above updates also).

QVSource Reaches 100 Five Star Reviews!

We were super excited this week to see QVSource receive it's 100th Five Star rating on Qlik Market and just wanted to mark the occasion with a blog post.

We're really proud of the product and it's amazing to see how much value it's bringing to QlikView and Qlik Sense users around the globe.

Thanks for all of your support!

QVSource (WinForms) 1.6.7 Now Available

(This blog post originally appeared on the QVSource blog here.)

We are delighted to announce the availability of a new version of QVSource - The QlikView and Qlik Sense API Connector!

IMPORTANT

Please note, as per our previous blog post, QVSource Web Edition is now available and this is the recommended version now if you are new to QVSource. We are releasing this update to the WinForms edition to help existing commercial users who are not yet ready to transition to the new Web Edition. However, it is likely this will be the last major release of the WinForms edition of QVSource.

The WinForms edition is now officially deprecated and will no longer be supported after the 22nd May 2016.

As always, in addition to reading the following for the highlighted updates and changes to QVSource we would also recommend you read the notes on the "Change Log" tab of any connectors you are using for a comprehensive overview of changes as there may have been other minor bug fixes and improvements made which are not listed below.

General Updates

  • The QVSource Windows Service (QVSourceService.exe) is now set to compile to any CPU (previously it was forced to 32 bit only). This was causing it to run out of memory for a couple of users (whereas the desktop version behaved differently). This is now resolved and it should run as 64 bit on 64 bit architectures.

Updated Connectors

  • Text Analytics Connector
    • BREAKING CHANGE: In order to make the Text Analytics Connector compatible with the new Web Edition of QVSource, we have had to make a breaking change carefully detailed here. This means making a slight adjustment to any load scripts which use this connector.
    • We have also made a fix to the Repustate connector to keep up to date with their API.
    • POSSIBLE BREAKING CHANGE: We have remove the embedded Alchemy API Key from this connector, you must sign up for you own Alchemy API key and enter it into the connector if you are using this (rather than one of the other sentiment API options the connector offers).
  • General Web Connector: Added a cookie container which maintains any cookies set for the lifetime of the running application (e.g. resends them with new requests) and a new Cookies table which allows these to be extracted. This further opens up the number of APIs which this connector can work with.
  • Twitter Connector: For UserTimeline table:
  • Google Drive Connector: Added two new inputs to GetSpreadsheet table to rename column headers (Column1, Column2 etc.) and to skip first X rows.
  • Google AdWords Connector: Upgraded to v201509 of API (https://developers.google.com/adwords/api/docs/reference/#v201509) for any items which may affect your report queries.
  • Google DFP Connector: Upgraded to v201505 of the API. Please read the release notes carefully https://developers.google.com/doubleclick-publishers/docs/rel_notes#v201505.
  • FTP Connector: FTPGetRawFile/SFTPGetRawFile tables now stream contents of file as binary (rather than first converting to text first).
  • Google BigQuery Connector: This is now out of beta. If you are a commercial user of QVSource who has been using this as a beta please contact us for pricing and licensing.
  • Google DFA Connector Back!: We marked this as deprecated, mistakenly thinking that the API it uses was due to be sunset by Google in September 2015. On realising our mistake we have removed the deprecated flag and hope to bring it out of beta in the future.
  • Facebook Fan Pages Connector:
    • For certain types of errors returned from the Facebook API, the connector will now wait a few seconds and retry the request a second time. This will also be logged.
    • BREAKING CHANGE: Removed the GroupMembers table (unfortunately we no longer have permission to make this API request (https://developers.facebook.com/docs/graph-api/reference/v2.4/group/members) as it requires the user_groups permission (https://developers.facebook.com/docs/facebook-login/permissions/v2.2) which is only 'granted to apps building a Facebook-branded client on platforms where Facebook is not already available'.)
  • MailBox Connector:
    • Added a new checkbox input parameter 'Allow Self Signed Client Certificate'. You might wish to check this if you are receiving an 'The remote certificate is invalid according to the validation procedure' error or other certificate related error as long as you are sure you are connecting with the correct server.
  • MongoDB Connector:
    • Upgraded to MongoDB Driver 1.11.0. This should now support version 3.0 of MongoDB as well as have various other fixes compared to the previous version 1.9.2.235 which the connector used.
    • Please note that as a new official BI Connector is now available for MongoDB 3.2 and later you may wish to first consider this. Because of this we are also now considering retiring this connector if it does not offer any advantages over this.
  • Box Connector:
    • ListFilesAndFolders table now requests results in batches of 1000 instead of 100.
    • Added recurse depth input parameter to ListFilesAndFolders.

New Connectors

Removed Connectors

Download Latest

Where do I find this new release? If you are a QVSource customer or have requested a trial in the past you should see this new release in the personalised download link we should have sent you via email.

If you are new to QVSource you can download a fully functional free trial from our website. As noted above though, we would strongly recommend you use the new Web Edition download (which contains the above updates also).

QVSource Web Edition Now Commercially Available!

We are absolutely delighted to announce that the Web Edition of QVSource is now commercially available! Coincidentally this is also happening almost 4 years to the day since the original WinForms edition of QVSource was commercially released which has gone on to win awards and gather nearly 100 Five Star reviews on Qlik Market!

There is also one major new feature in this release as compared to the recent beta announced and detailed here - a brand new user management UI!

Although we slipped our planned release date by a few weeks, the product is actually now more polished than we had ever envisioned for a first version and we are really pleased with the result. We have also received some great feedback from early users and even have a few customers who are getting great value from it.

Having said that we do appreciate that it is still relatively new and we look forward to your feedback and fixing any issues which may arise over the next few months.

There is one important change which all current users of QVSource should note: The current (as of today previous!) 'WinForms' edition of QVSource is now officially deprecated and the next release of this will state this in the title bar. Our current plan is to end support of the WinForms edition of QVSource in six months - so on the 22nd May 2016, after which there will be no new builds or releases of QVSource WinForms edition.

This shouldn't be of concern, the new Web Edition is an almost seamless swap in replacement for the WinForms edition and operates in a very similar manner, there are just a few new things to learn if you wish to deploy it on a central server in your organisation. We would recommend reading the new doc pages here to get an overview of the new version and detailed information on the differences.

One final thing to users who have been working with the previous beta(s) of the web edition, we have made a slight modification to the paths used to store user settings, log, cache files etc. so you will need to re-authenticate with any connectors you have been using.

QVSource Web Edition Beta Update 0.9.8

We are pleased to announce that a new beta of the new Web Edition of QVSource is now available - this will likely be the final beta before commercial availability in a few weeks.

We have some customers already working with the beta and have received some really great feedback, so if you have not tried it already, please do! Once the Web edition is launched, the current WinForms edition of QVSource will be deprecated and eventually removed.

NOTE - If you are a customer or trial user of QVSource you will find the download available on the same page where you accessed the current WinForms edition of QVSource.

In this blog post we will outline the main updates in this version.

Copy Script Button

We are pleased to finally have a button to copy the generated load script or request URL to your clipboard - a big shout-out to the clipboard.js library, which we are using to provide the functionality. This should work from desktop OS's but might not work from all tablet devices.

Download Data As File

A new Download button is now available under the data grid preview which allows you to download your data as a QVX (or CSV, TSV, XML or HTML) file - this might be useful if you would like to send the data to a colleague to load into their QlikView or Qlik Sense application or have a simple backup. Note that when you click the download it does re-run the query to the API in the background so you might get slightly different or more up to date data.

Larger Multiline Input

Some connectors have an input parameter where the user needs to enter an XML, JSON or other arbitrary text string - for example the POST parameter on the General Web Connector:

 

This was always a little too small for any serious editing, so now, clicking the new button at the top right opens up a much larger popup window:

OAuth Username

Many of the APIs that QVSource connects to use OAuth and in the past we have only shown the token in the UI after authentication. Often users may have a number of different accounts they use for a service and it was difficult to remember which account the connector had been authenticated for.

We are now starting to show this in the UI as highlighted below. This is currently available for all of the Google Connectors, Twitter and the Facebook Connectors and we plan to add this to all connectors where possible:

Text Analytics Connector

The Sentiment Analysis & Text Analytics Connector is finally available in the Web Edition - we have had to making a breaking change to the way this works which is explained here (but briefly, the Sentiment API is now selected via the Table Category dropdown as shown below). Note that for consistency we have also had to make this change in the WinForms edition but we will mention this in the notes for that release soon. The main thing to note is that you will have to make a minor change to your load script if you are moving from the current WinForms edition to this new Web Edition.

New Connectors

We have new connectors to Amazon S3 and Exact Online! These will also be in the next release of the WinForms edition.

Coming Soon

The last major feature we are working on before release is a user manager/editor so you will no longer need to edit an XML file - we are really pleased with how it both looks and works but unfortunately it just missed making it into this release - something to look forward to for the first commercial release! Here is a sneak preview:

QVSource 1.6.3 Now Available

We have just released version 1.6.3 of QVSource - The QlikView & Qlik Sense API Connector!

This is quite a substantial release under the covers, as we prepare to make the first beta download of the new web edition of QVSource available we have now upgraded all of the (non deprecated) connectors to use the new UI style. This has allowed us to remove a lot of legacy code and unify all the connectors under one system.

If you are interested in being notified of the new beta download for the web edition of QVSource please go to your usual download link where you will find a new tab for the web edition.

As always, in addition to reading the following for the highlighted updates and changes to QVSource we would also recommend you read the notes on the "Change Log" tab of any connectors you are using for a comprehensive overview of changes.

New Connectors

  • We have a brand new Survey Monkey Connector.

Updated Connectors

  • Twitter Connector:
    • Fixed bug where search query for Twitter search table(s) was not being URL encoded. This bug appears to have been introduced 09/03/15. Note that this was also fixed in the recent intermediate 1.6.1.8 release made available on 10th June.
    • Added a 'manual' authentication option which helped a user who was running a very old version of IE and could not authenticate using the default option in QVSource. The manual auth option is now available for all OAuth1 and OAuth2 based connectors.
  • Google Adwords Connector:
    • Our AdWords Developer application has been approved and this connector can now be used by everyone.
    • Upgraded to v201506 of API, please read Reporting section of migration guide for any items which may affect your report queries.
  • Text Analytics & Sentiment Analysis Connector:
    • Polish is now available as an option with the Repustate API.
    • Fixed bug in Alchemy API Sentiment table which gave an error if <mixed> element was not present in the response.
  • Facebook Insights Connector:
    • BREAKING CHANGE: Removed page_storytellers table/metric. This metric is deprecated after the deprecate_PTAT migration.
    • Fixed bug where data from requests for different object IDs was getting mixed up.
    • Insights tables (excluding application insights) now have empty tables shown (i.e. with column headers) even if no data returned for selected date range.
    • Fixed bug where real-time tables (e.g. those with * at the end of their name) were no longer working. Note that this was also fixed in the recent intermediate 1.6.1.8 release made available on 10th June.
  • JIRA Connector:
    • Added AllProjects table and optional projectIdOrKey for AllIssues table.
    • Added option to first download all data then write table to minimise issues with missing columns.
  • OData Connector:
    • Updated code to set HTTP Basic authentication which did not appear to work in some scenarios.
  • YouTube Data Connector:
    • Added duration_timespan and duration_total_seconds columns to VideoStatistics table.
    • Updated 'Include Content Details' quota info, conditionally include extra columns.
    • Added url encoded comment and comment response text.
    • Added a ChannelStatistics table.
  • YouTube Analytics Connector:
    • BREAKING CHANGE - The MyId table has been removed as it relied on the now deprecated YouTube API V2.
    • We have updated the number of API calls which can be made per second through the connector.
  • Azure Data Marketplace Connector - This has been updated to the new UI style.
  • OneDrive Connector:
    • BREAKING CHANGE: Updated to use new API. This is a breaking change as available tables and columns have changed.

Removed Connectors

V1 of the OData Connector and Salesforce Connectors have been removed. These both have new and improved V2 versions which you should use instead.

Download Latest

Where do I find this new release? If you are a QVSource customer or have requested a trial in the past you should see this new release in the personalised download link we should have sent you via email. You can also use this link to register your interest in the new beta download for the web edition of QVSource and being notified when it's available.

If you are new to QVSource you can download a fully functional free trial from our website.

QVSource 1.6.1 Now Available

We have just released version 1.6.1 of QVSource - The QlikView & Qlik Sense API Connector!

There are a lot of updates, so please scan this blog post for any connectors you are using or thinking of using. As always, we would also recommend you read the notes on the "Change Log" tab of any connectors you are using for a comprehensive overview of changes.

New Connectors

  • We have a V2 of the OData Connector (V1 is now deprecated, see below). This uses the new UI style and has some additional functionality, in particular the ability to extract referenced/linked tables using the columns with the _Feed and _Entry suffixes (the values of which can be used as new OData Resource Path inputs). You should regenerate your QlikView and Qlik Sense load scripts for the new version.

Updated Connectors

  • V3 of the Facebook Insights Connector now has the first version of application insights available and now uses version 2.3 of the Facebook Insights and Facebook Application Insights API.
  • Google DFP Connector Updates
    • Upgraded to v201502 of the API. Please read the release notes carefully.
    • Added fix for "WebClient does not support concurrent I/O operations" error which you may have experienced if running multiple reloads simultaneously.
    • The PQLAsXml table now returns the raw SOAP response from the DFP API (formerly we were re-serialising the deserialised object model back to XML and the result was wrong).
    • Reports are no longer saved to a temporary file in an intermediate step but rather streamed directly to the output.
    • Added new 'raw' ReportRaw table which returns the exact contents returned from the API (tab separated values file at time of writing).
    • Upgraded to new OAuth 2 framework.
  • YouTube Connector:
    • Comments and Comment Responses now use the YouTube V3 API.
    • Added search term to comments tables.
    • Added channel comments.
    • Added 'Include Statistics Details' to VideoStatistics table.
  • The Google Analytics Connector now has support for Unsampled Reports (note these are available to Google Analytics Premium Customers only) via the UnsampledReportsInsert, UnsampledReportsList and UnsampledReportsGet tables. Note at present we only support customers who have set this up to export the reports to Google Drive and the Google Drive Connector now has a new GetRawFileByIdAsText table to retrieve these more easily.
  • SugarCRM Connector
    • Improved code for checking refreshing access token.
    • Added CustomRequestAsXml table.
  • JIRA Connector: We have added created/updated date filter on AllIssues table and removed the maximum items cap of 500 which was a bug. NOTE - We expect this will be the last release where this connector will be in beta, so if you are making use of this please contact us about pricing.
  • Adobe Analytics (Omniture) (NOTE - We expect this will be the last release where this connector will be in beta, so if you are making use of this please contact us about pricing):
    • DWCheckRequest table now always returns a single row, even in the case of an error message being returned from the API.
    • Fixed bug in ReportSuiteGetSegments table. Also, it now checks for both segments and sc_segments elements (a new element_name column specifies which).
    • Expanded notes for some tables.
    • Fixed bug with ReportGetQueue table.
    • Added ReportQueueAndWait and ReportQueueFromFileAndWait tables. This means you no longer need to construct logic to check the queue and wait for the report to complete in your QlikView and Qlik Sense load script.
  • We have Added inReplyTo column to IMAP and POP messages tables to the MailBox Connector.
  • We have added a new max API calls per second input parameter to the Facebook Fan Pages Connector and V3 of the Facebook Insights Connector. This might help users who are receiving API quota exceed limits.
  • We have also noted that with respect to Groups, the Facebook Fan Pages Connector will only now work with open/public groups. This appears to have been a change since the deprecated v1.0 of the Facebook API.
  • The Short URL Expander Connector has been updated to use the new UI style.
  • The Yahoo Placemaker Connector has been updated to use the new UI style.
  • Google Drive: IMPORTANT: It seems Google now have automatically updated all spreadsheets to the new version. If you are using load scripts which load the older versions of Google Spreadsheets we would advise you to check these are still running and if not, quickly regenerate your load scripts which should be straightforward.
  • Klout Connector:
    • Upgraded to new UI style.
    • Added a new KloutIDFromInstagramId table. You could now use the Instagram Connector to find Instagram users and then this connector to get data on their social influence.
  • Notification Connector:
    • BREAKING CHANGE - The sendemail_status, sendemail_result and sendemail_filesattached are now named status, result and filesattached.
    • Added 'Use SSL' input parameter.
    • From field no longer mandatory (username will be used if not set).
    • Upgraded to new UI style.
  • Mashape Connector (BREAKING CHANGES - You should regenerate your load scripts when updating to this version):
    • Upgraded to latest UI style.
    • Added content type input parameter.
    • QVX is now the default response format (previously it was HTML). Ensure you upgrade to use QVX format (recommended) or use &format=html in your requests (not recommended).
    • Cache time in hours will now accept integers only.

Deprecated Connectors

V1 of the OData Connector is now deprecated and planned for removal from QVSource in August 2015. Please upgrade to V2 of the Connector (see above).

Removed Connectors

Download Latest

Where do I find this new release? If you are a QVSource customer or have requested a trial in the past you should see this new release in the personalised download link we should have sent you via email.

If you are new to QVSource you can download a fully functional free trial from our website.

Loading Qonnections 2015 Instagram Posts Into Qlik Sense (Or QlikView)

In this post we will demonstrate using the new Web Edition of QVSource to load data from Instagram into Qlik Sense Desktop.

The QVSource Web Edition is currently in private beta but should be available for general (beta) download in June 2015. We are also currently hosting an invite only cloud hosted instance of QVSource Web Edition which a number of users are already testing out the new version with. If you would like to be considered for access to this please fill out this form.

NOTE: You can also try this out using the current QVSource Desktop Edition. Whichever version of QVSource you are using, when using Qlik Sense just remember that at present you will first need to make this minor config change in order to allow load requests from arbitrary URLs.

First of all we fire up QVSource and open the Instagram connector. We ensure we are authenticated with Instagram and then select the SearchForTags table and enter ‘qonnections’ in the Tag field. There are (at time of writing) 303 results for ‘qonnections’:

We can see that there are a few Instagram tags being used in relation to Qonnections, the most popular one being simply 'qonnections'. We can now go to the MediaByTag table and make sure that this tag name is entered as the tag to find Instagrams for and then run the table.

We then select the Qlik Sense tab and copy the script to the clipboard:

Now we fire up Qlik Sense Desktop, create a new app and open the data load editor:

We paste in the script, and click load data:

And run the reload:

Note that we do not necessarily get back as many results as suggested in the earlier table as the SearchForTags table above shows counts including images which are private or might have subsequently been deleted.

We then return to the app overview and create a new sheet:

We edit the sheet and drag a bar chart in:

Then add the dimension username:

...and a measure of count(id):

We then limit to the top 10:

...and complete the edit, giving us the top 10 posters:

We now create a new sheet and add a table with dimensions for user name and link; and a measure for sum(likes count):

We can then sort by likes (descending) to see the most liked posts and poster:

We click ‘done’ to view the results:

Now we create a new sheet and add a bar chart with create time (utc qlik date) as dimension and count(id) as measure. This can be sorted by the dimension (date) first and saved, showing the peaks in posting media around the annual Qonnections conference:

This demonstrates just how easy it is to pull data from instagram and quickly extract meaningful patterns and trends. This is just a simple example, in a real world example we might want to write QlikView/Qlik Sense load script to loop through a number of different tags which were used during the event. We could also extract a great deal more data such as comments and likes using the many other tables which the connector supports.

You will find a more complete example for QlikView over on our GitHub Page - note that although this is for QlikView the load script should also work fine in Qlik Sense giving you the same data model to build your user interface on top of.

You can request a fully functional free trial of QVSource from our and try out the 35+ Connectors it supports with QlikView or Qlik Sense.

Page List