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.

Page List