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).

Page List