Table of Contents
The following release notes cover the versions of Qlik Web Connectors released in June 2021.
Qlik Web Connectors June 2021
Patch 1 (2.109.1)
Some highlights in this release include:
- Fixed authentication in Qlik GitHub Connector.
- Qlik Facebook Fan Pages Connector – this connector has now been deprecated and will be removed in a future version.
- Qlik Office 365 Sharepoint Connector: Updated to use v2.0 of authentication API (fixes error AADSTS90027 during consent/authentication)
- BREAKING CHANGE for Qlik Watson Natural Language Understanding Connector: Added API URL for connection for all tables.
Release (2.109.0)
Overview Some highlights in this release include:
- One Deprecated connector – Google AdSense Connector has been deprecated and will be removed in a future version.
- In this release there have been many fixes to the connectors, which may include BREAKING CHANGES and, as such, please pay particular attention to any connectors which you may use in the Change Log section below.
Documentation about the Qlik Web Connectors can be found at https://help.qlik.com/enUS/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Setupdep...
Qlik Web Connectors Community Page
Qlik Web Connectors Community Page is used to make announcements and provide additional information on using the product and features, so please join this group.
Deprecated Connectors
When upgrading connectors to the latest APIs unfortunately the changes can be so extensive that we’re unable to modify the existing connector. When this happens we’ll create a new version of the connector and put the existing one into a ‘Deprecated’ state. This means that at some point in the future it will no longer be available and after entering the deprecated status, it will no longer be updated. The date is normally determined by the underlying API which will often have its own expiry date, after which the connector using it will no longer work.
You can see connectors affected under the Deprecated tab in Qlik Web Connectors.
Qlik Google AdSense Connector
Connector is now deprecated and will be removed in a future version.
Qlik Web Connectors (Change Log)
Updates Since Qlik Web Connectors June 2021 Release (2.109.0)
The following updates have been made to the Qlik Web Connectors Core and Web UI as well as the connectors listed.
Please pay particular attention to any connectors which may have breaking changes highlighted below.
Qlik Azure Storage Connector
- Updated to use v2.0 of authentication API (fixes error AADSTS90027 during consent/authentication).
Qlik Facebook Fan Pages Connector
- Deprecated - this connector will be removed in a future version and some of the tables will likely stop working in November 2021 due to deprecation of the API version used.
Qlik GitHub Connector
- Fixed an issue with authentication not working.
Qlik Microsoft Dynamics CRM Connector V2
- Updated to use v2.0 of authentication API (fixes error AADSTS90027 during consent/authentication).
Qlik OData Connector
- Fixed issue 'Data at the root level is invalid. Line 1, position 1' caused by BOM in returned XML data for ListResources and GetData tables.
Qlik Office 365 Sharepoint Connector
- Updated to use v2.0 of authentication API (fixes error AADSTS90027 during consent/authentication).
Qlik Watson Natural Language Understanding Connector
- BREAKING CHANGE: Added API URL, which must be included for all tables.
- Updated to use API version=2021-03-25
Updates Since Qlik Web Connectors December 2020 Release (2.98.0)
The following updates have been made to the Qlik Web Connectors Core and Web UI as well as the connectors listed.
Please pay particular attention to any connectors which may have breaking changes highlighted below.
Core Engine
- Memory usage (GC finalization) fix when running as a service.
- DefaultRequestTimeoutMs can now be configured via deploy.config (min=180000, max=5400000).
- Support TLS v1.2 minimum.
- Removed the EnableUserManagement option from deploy.config - the user management UI is now automatically enabled for admins when forms authentication is used.
- Removed 'Providers' config from deploy.config, except FormsUsers which remains.
- Fix encoding issue.
- Updated React 16.14.0.
- Updated Bootstrap 4.6.0.
- Updated library used for parsing CSV data used by some connectors.
Qlik AmazonS3 Connector
- Increase number of retries and improve logging when API requests fail.
- Fix output mimeType / encoding issues for GetRawObjectAsText table.
- Handle rare case where response headers are not populated for Metadata table.
Qlik AYLIEN News Connector V2
- Fix resource cleanup bug, add request retry strategy.
Qlik Dropbox Connector
- Improvements to authentication flow.
- BREAKING CHANGE: UploadFile now returns only status and error_message columns.
- Security improvements.
- POSSIBLE BREAKING CHANGE: Updated OAuth to use refresh tokens. Previous access token based connections should still work but Dropbox may expire these tokens in the future so we would recommend you reauthenticate.
Qlik FTP/SFTP Connector
Qlik GitHub Connector
- New columns for UserRepositories, OrganisationRepositories: License_Name, Disabled, Stargazers_Count, Watchers_Count.
- Added paging to FileChanges table.
- New columns for PullRequests: User_Login, Requested_Reviewers_Login, Requested_Teams_Name, Assignees_Login, Merge_Commit_Sha, Active_Lock_Reason, Author_Association, Draft, Locked.
- New Tables: CompareCommitsStats, CompareCommits.
Qlik Google Ad Manager Connector
Qlik Google AdSense Connector
- BREAKING CHANGE: Connector is now deprecated as the API version will stop returning data on October 12, 2021. The connector will be removed in a future version.
- Security improvements.
Qlik Google AdWords Connector
Qlik Google Analytics Connector
- Fix progress update.
- Table CreateReport: Removed invalid values from Dimensions and Metrics parameter.
- Security improvements.
Qlik Google Calendar Connector
Qlik Google Drive & Spreadsheets Connector
- POSSIBLE BREAKING CHANGE: GetWorksheet table is now deprecated. Please switch to using either GetWorksheetV2 or (preferably) GetSheetValues at the earliest opportunity.
- Added GetWorksheetV2 table to support migration away from the GetWorksheet table with minimal impact.
- 'GID Override' parameter no longer requires user to prefix value with _ - i.e. value can be copied from the URL as noted in the parameter popup description.
- ListFiles and ListSpreadsheets now set corpora=allDrives when searching 'All Drives' - some items may have been missing before.
- Improve error message when encountering multiple files with the same name.
- driveId parameter now converted to a dropdown which is autopopulated with logged in user's values.
- Removed unnecessary scope request during authorisation.
- Improved request retry strategy for GetWorksheet table.
- Security improvements.
Qlik Google Search Console Connector
- siteUrl parameter now converted to a dropdown which is autopopulated with logged in user's values.
- Security improvements.
Qlik JIRA Connector
- Added basic request retry strategy to help with 429 & 5XX errors.
Qlik Mailbox IMAP Connector
Qlik Mailbox POP3 Connector
Qlik OData Connector
- POSSIBLE BREAKING CHANGE: The authHeader parameter is now set to be encrypted. If you are using this connector/parameter you will need to update your load scripts. You can regenerate your load script in the UI and copy the value of the newly updated/encrypted authHeader= parameter to your existing scripts. Alternatively, if you simply remove this parameter from your scripts the value stored in settings will be used. Note that you can also use the Encrypt table in the Helper Connector to create the encrypted value on the fly.
Qlik Office 365 Sharepoint Connector
- Improve retry strategy for IOException / SocketException.
- Added option to override authentication endpoint, client ID and client secret in deploy.config.
- Connector will now retry API requests in the case of certain error conditions.
Qlik OneDrive Connector V2
- Improve retry strategy for IOException / SocketException.
- Added API request retry for connection reset by peer, remote party has closed the transport stream, operation has timed out.
Qlik Outlook 365 Connector
- Added body_contentType and body_content columns to EventsForCalendar and AllEvents tables.
Qlik Qualtrics Connector
- surveyId parameter now converted to a dropdown which is autopopulated with logged in user's values.
- Updated CSV parsing library used by the Responses table.
Qlik Slack Connector V2
- New table: 'Replies'.
- Added reply_count, thread_ts, reply_users_count, latest_reply, reply_users, ts columns to Message table.
- BREAKING CHANGE: removed deprecated column skype from Profile table.
Qlik SMTP Connector
Qlik Strava Connector
- Added the following columns to the Activities table: max_watts, average_watts, weighted_average_watts, average_cadence, suffer_score, average_heartrate, max_heartrate, kilojoules.
Qlik SugarCRM Connector
Qlik SurveyMonkey Connector
- New Column: GetResponses - tag_data_labels.
Qlik YouTube Analytics Connector
Known Issues and limitations
IP v6 Addresses
IP v6 addresses are not supported when you enter an IP v6 address for the purpose of white listing.
Load Balancing
Load Balancing is not supported.
About Qlik
Qlik’s vision is a data-literate world, where everyone can use data and analytics to improve decision-making and solve their most challenging problems. A private SaaS company, Qlik offers an Active Intelligence platform, delivering end-to-end, real-time data integration and analytics cloud solutions to close the gaps between data, insights and action. By transforming data into Active Intelligence, businesses can drive better decisions, improve revenue and profitability, and optimize customer relationships. Qlik does business in more than 100 countries and serves over 50,000 customers around the world.
qlik.com
.png "Former Employee"){kind=icon}