(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.2There 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 ConnectorsNote 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) ConnectorAmazon S3 ConnectorBlue Yonder ConnectorBox ConnectorDropbox 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 ConnectorGoogle DoubleClick For Advertisers (DFA) ConnectorGoogle DoubleClick for Publishers (DFP) Connector (Includes Breaking Changes)Google Prediction ConnectorGoogle Webmaster Tools ConnectorHelper ConnectorInstagram ConnectorKlout Connector (v2)MailBox Connector (IMAP/POP3)MailChimp Connector (v2) (Includes Breaking Changes)MongoDB Connector (v2)MS CRM Connector (Includes Breaking Changes)Notification ConnectorOData Connector (V2)Office 365 Sharepoint ConnectorOneDrive ConnectorSugarCRM ConnectorSurveyMonkey ConnectorSentiment 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 ConnectorYouTube Analytics ConnectorYouTube Connector (v3)Core Engineapplication/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 InterfaceIf 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) Added new Ftp Mode input parameter to all FTP tables which allows FtpSslExplicit (Use FTP protocol with explicitly secured TLS/SSL connection) and FtpSslImplicit (Use FTP protocol with implicitly secured TLS/SSL connection) to be set. (07 Feb 2016)FTP tables should now work with anonymous servers (i.e. if username and password are left blank). (28 Jan 2016)If a proxy is configured (as noted here http://wiki.qvsource.com/An-Introduction-For-Enterprise-Users.ashx#Proxy_Authentication_1 for WinForms version or here http://wiki.qvsource
