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.

QVSource 1.6.0 Now Available

We have just released version 1.6.0 of QVSource - The QlikView & Qlik Sense API Connector.

This blog posts outlines the main changes. 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 new connector to JIRA (hosted or locally run). Currently there are only a couple of tables, one to retrieve all issues and another to make and custom REST API request but we will add to this in the next release - please let us know what features/data you need so we can make sure you are covered.

Updated Connectors

  • IMPORTANT/BREAKING CHANGE: We have removed the MyAccounts and Messages tables (as we do not believe they are being used and would now require us getting approval from Facebook to continue using) as well as the FriendsWhoUseThisApp table which we also believe is not useful from the Facebook Fan Pages Connector.
  • V3 of the Facebook Insights Connector has been added (and V2 removed). All requests to FacebookInsightsConnectorV2 will now be automatically routed to FacebookInsightsConnectorV3 (although we would still recommend making the same change in all your load scripts to avoid confusion). BREAKING CHANGE: Unfortunately, Facebook have now changed their Insights API and application insights are no longer available in this version of the connector although we hope to resolve this soon.
  • We have a new V2 of the Salesforce Connector. This replicates the functionality of the previous version and also has additional Insert and Update tables which allow you to write data back to Salesforce from your QlikView or Qlik Sense load scripts.
  • The MongoDB Connector now scans all items in the MongoDB Collection in order to establish all possible columns before generating the table for QlikView/Qlik Sense.
  • A new TableSchema table has been added to the Google BigQuery Connector.
  • The SugarCRM Connector has new max results and order by inputs which makes it much easier to get just the data you need. We hope to add a filter input to this connector also soon.
  • The Klout Connector now makes all API calls over HTTPS instead of HTTP.
  • The Adobe Analytics (Omniture) Connector has a fix in to avoid having duplicate column names in the result tables.

Deprecated Connectors

The following connectors have been deprecated and will likely be removed from the product in a future version.

  • The DFA Connector (which was still in beta) has been deprecated as it uses an API which Google are now removing later in the year. Please contact us if you would like us to consider redeveloping this connector to use the latest DFA API.

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.

QVSource 1.5.2 Now Available

We have just released a new version of QVSource - The QlikView API Connector. This blog posts outlines the main changes

As always, we would also recommend you also read the notes on the "Change Log" tab of any connectors you are using for a comprehensive overview of changes.

New Connectors

  • SugarCRM: We have a brand new connector for SugarCRM, one of the most widely used CRM systems on the market. This connector allows QlikView users to load Accounts, Contacts, Leads, Opportunities, Forecasts, Meetings and Calls.

Updated Connectors

  • Facebook Insights V2: We have a completely revised V2 of our Facebook Insights Connector which uses the new UI style. This offers huge performance and usability improvements over the previous version (which is now deprecated and marked for removal) and we would recommend all users to upgrade. We have instructions here on upgrading from the previous version. Please note that the previous V1 of this Connector will be removed from QVSource in June 2014 so all users should upgrade no later than this.
  • MongoDB: We have a new version of our MongoDB Connector which uses the new UI style and the latest MongoDB Driver. The previous version of this Connector is now deprecated and although this Connector is still in beta would encourage all users to start using this new version and providing feedback or comments.
  • Google Calendars: We have a new version of our Google Calendar which uses the new UI style. This has a small but breaking change which is that the default data format is now QVX - we would recommend you regenerate your load scripts.
  • Google AdSense: We have a new version of our Google AdSense Connector which uses the new UI style and the latest API (v1.4) version. Please note that the previous V1 of this Connector will be removed from QVSource in June 2014 so all users should upgrade no later than this.

Removed/Deprecated Connectors

Of particular importance are the four removed Connectors listed below. If you are using these you must upgrade to start using the new versions.

  • The following Connectors have been removed as they have been replace/superseded with new improved versions:
  • Salesforce Connector: We have also deprecated our Salesforce Connector for QlikView. This is because Qlik have their own Connector to this already. We are not currently planning to remove the QVSource version from the product but are no longer actively maintaining or developing it. If you find the Qlik Salesforce Connector does not meet your requirements please get in touch.

Connector Updates

  • Google AdWords Connector: We have upgraded this by two AdWords API versions to the latest v201403. Please check the Report related updates here and here for changes and new features which you may be able to use in your reports.
  • Google Analytics Connector: We have fixed a minor bug where the WebProfiles table did not page correctly. This would only have affected users who had more than 1000 Web Profiles.
  • Google DFP Connector:
    • We have upgraded to the latest DFP API version v201403.
    • We have reduced memory utilisation and improved performance.
    • The Connector now makes more intelligent usage of the API quota limits.
    • The parameter input area should now scroll vertically.
  • Google Drive & Spreadsheets Connector: We have added the ability to specify a folder ID to move a newly created spreadsheet to.
  • Google Plus Connector:
    • The Person table has been renamed ObjectDetails (as it can return data for a Person or Page). For script generated using previous versions, the table People should be automatically mapped to this name. This table also has the following new fields: occupation, plusOneCount, circledByCount and primary_placesLived.
    • We have added a new ObjectDetailsAsXML table which returns all the details returned by the API as XML (ObjectDetails selects a subset of these to a structured table). This can then be natively parsed/loaded in QlikView.
  • Twitter Connector: We have added Post_UserLookup_Info and Post_UserLookupById_Info tables and an associated example application on GitHub here illustrating how they can be used. The purpose of these tables is to support the use case of loading information on a large number of followers or friends. Because the API only allows a limited number of calls per 15 minutes, if the account you are interested in has above a certain number of followers/friends then you need to accumulate this data over a number of reloads over a number of 15 minute windows.
  • Sentiment Analysis & Text Analytics Connector:  The ChatterBox option has been renamed to Sentimental. The Excitement table has been removed and an Anger table has been added for Chinese. These are changes based on the underlying API and not due to QVSource.
  • Facebook Fan Pages & Groups Connector:
    • The User and Person tables now always return a row, a new status column indicates any errors returned if there was an issue retrieving the data.
    • We have fixed a bug in the 'Don't return items before' feature which was sometimes not going back as far as it should.
    • We have fixed bug where the has_at_least_this_many_likes and has_at_least_this_many_comments fields always had a value one larger than the actual.
    • We have added comment_link and like_link columns to FeedItems and Posts tables. This contains a link which allows you to open the post in a browser from your QlikView application.
  • Blue Yonder Connector: We have upgraded this in line with the latest v1.14.0 and also changed the parameter input for the API version so the user can enter their own version number (rather than picking from a drop down).
  • General XML/JSON/SOAP Web Connector: We have added a new User Agent input field to allow this to be overridden.
  • You Tube Analytics Connector: This Connector has now been taken out of beta.
  • HEIDI Connector: The parameter input area should now scroll vertically.

QVSource On GitHub

You will now find most of our example and 'starter' applications over on our GitHub page here.

You don't need to know anything about GitHub to use them (just look for the 'Download ZIP' button for any applications you are interested in). However if you do have a free GitHub account you can use it to receive alerts for changes to the applications and also as a way of exploring the load scripts and their changes on the GitHub site itself (look for the LoadScript.txt file in the sub folder of the application you are interested in).

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 at the personalised download link we should have sent you via email.

Before that - If you like what we are doing with QVSource and haven't already, please take a minute to rate us on QlikMarket or leave a recommendation on our LinkedIn product page.

Page List