• New: [Kafka Connection] Support for KeyStorePassphrase, TrustStoreLocation and TrustStorePassphrase properties - 3104
  • New: [REST] More flexible Amazon authentication module (to support Amazon Selling Partner API) - 3059
  • New: [General] Instead of sending e-mail to support, open the page for submitting a new SSIS+ ticket - 3094
  • New: [XML Destination] Support for external XSD references when initializing the document model.
  • New: [XML Destination] Support for global XSD definitions when initializing the document model.
  • Fixed: [XML Destination] Improve support for XML namespaces - 3061
  • Fixed [Parquet Destination]: Issue with skipping a record at each batch of records (batch size is determined by 'Row Group Size') - 3087
  • Fixed: [QuickBooks Online] Modified to use the correct Date type in the relevant fields. - 3103
  • Fixed: [monday] Modified not to perform pagination for resources not supporting. - 3101
  • Fixed: [Query] Included code to ignore blank rows. - 3096
  • New: [REST Editor] Enhanced "Pagination Setup" form for customizing the paging at the endpoint or the resource level. - 3073
  • Fixed: [VS Addon] Prevent a crash due to attempt to setup CozyRoc group in the Toolbox - 3084
  • Fixed: [Parquet Source][Parquet Destination] Preserve the case of headers in Parquet files - 3085
  • Fixed: [REST Source] Prevent memory issues due to Log Viewer - 3088
  • New: [VS Addon] Ability to deploy a package to COZYROC Cloud from Visual Studio - 3024
  • Fixed: [REST Destination] Suboptimal throughput when using more than 2 parallel threads - 3079
  • New: [Microsoft Graph] Included definition to retrieve Site/User/Group drive data. - 3083
  • Fixed: [REST] Return raw data instead of throwing exception when JSON response cannot be parsed. - 3081
  • Fixed: [Power BI] Modified to remove pagination definitions for resources which do not support it. - 3080
  • New: [REST] Included processing for ArrayBuffer input in File parameters. - 3075
  • Fixed: [Database Destination] Issue with SQL Server matching NULL values in Update, Upsert and Delete mode - 3025
  • Fixed: [REST] Fixed connection.getData method to only auto select fields where AutoSelectForRead=false - 3069
  • Fixed: [REST] Complex field processing failed when input field was set to null. - 3068
  • Fixed: [Microsoft Graph] Removed pagination for 'Teamwork | Channel' resource. - 3067
  • New: [Microsoft Graph] Improved handling of SharePoint list item lookup fields. - 3066
  • Fixed: [REST] Removed code that made it impossible to overwrite fields defined in Item definition. - 3064
  • Fixed: [MongoDB Destination] Support _id that's not an ObjectID - 3056
  • Fixed: [Shopify] Corrected two resources having the same Transaction name. - 3060
  • New: [BigCommerce] Modified to bulk update in Product resource. - 3058
  • Fixed: [Microsoft Graph] Modified the default scope because the existing scope requires very privileged access. - 3057
  • Fixed: [PDF Source] - Fixed a crash when processing client-provided PDF file - 3047
  • Fixed: [Sage Intacct] Very slow processing of large XML responses - 3042
  • Fixed: [EDI Source] Permit adding extra output columns - 3051
  • Fixed: [REST] In design-time support working of utils.getListEditor with non-standard parameters object. - 3048
  • Fixed: [Sage 300] Indicate that [host] is parameterizable - 3049
  • New: [General] Support for SQL Server 2022 (Preview) - 3030
  • New: [General] Support for SQL Server 2022 (Preview) - 3030
  • Fixed: [Parquet Source] Proper retrieving of file path from connection manager - 3044
  • Fixed: [General] Occasionally missing CozyRoc group in SSIS Toolbox - 3043
  • Fixed: [REST] A recent regression in FTP Browser for REST connections - 3039
  • Fixed: [Salesforce File] Better error message when attempting to upload a Salesforce file without choosing a library - 3040
  • Fixed: [File Transfer Task] - Issues with the dialog for selecting FTP/SFTP folders & files - 3035
  • New: [Amazon Athena] Support for data retrieve by directly specifying a Query statement. - 3038
  • Fixed: [BigCommerce] Missing forward slash in Url definition for Create action... - 3036
  • Fixed: [File Transfer Task] Regression issue with sending a file to a Unix-based SFTP servers - 3033
  • Fixed: [REST] Improve performance of processing of HTTP responses with XML content - 3029
  • Fixed: [Microsoft Dataverse] Parameters not processed when using 'Create' action. - 3032
  • Fixed: [QuickBooks Online] Included minorversion parameter for all web service requests. - 3028
  • Fixed: [Zoho Sheet] Included prompt=consent parameter for the OAuth for authorization request. - 3026
  • Fixed: [Zoho CRM] Corrected expression for the token expiration configuration. - 3027
  • Fixed: [OpenAPI] Skip all read built-in verifications - 3023
  • New: [IMAP Connection Manager] Support for Outlook OAuth 2.0
  • New: [SMTP Connection Manager] Support for Outlook OAuth 2.0 - 3012
  • Fixed: [Zendesk] Enabled fields to be available for create in 'Organization Membership' resource. - 3019
  • Fixed: [REST] Improved cache reload check. - 3017
  • FixedL [Microsoft Dataverse] Removed the replacement of underscore characters in the resource name. - 3016
  • Fixed: [REST Destination] A validation issue when the component has multiple inputs and the root input has an _ in its name - 2998
  • Fixed: [Google Sheets] Backward compatibility fix for the handling of firstRowColumnNames parameter - 3014
  • New: [Shopify] Additional metadata definition. - 3013
  • Fixed: [REST] Moved UI-related functions in a separate module. - 3010
  • New: [Microsoft Dataverse] Support for IgnoreNullValue, IgnoreMissingIdentifier, IgnoreUnchanged action parameters. Various other improvements. - 3009
  • New: [Zendesk] Improved handling of user_fields. - 3008
  • Fixed: [REST] Proper handling of complex fields in composites. External metadata was incomplete for fields defined completely in code. - 2997
  • Fixed: [Parquet] More robust handling of column mapping in source and destination. NOTE: Need to refresh metadata after upgrading. - 3001
  • Fixed: [Table Difference] A possible crash when input columns are included in the log output. - 3006
  • Fixed: [OpenAPI Import] Don't stop the import due to square brackets in identifiers (they are supported in OpenAPI v.2) - 3004
  • Fixed: [Parquet Destination] Handling of decimal, byte and float values - 3000
  • Fixed: [REST] Composite fields metadata was not extracted correctly for batch processing. - 2988
  • New: [Microsoft Dataverse] Implemented to use navigation property information for lookup field update. - 2986
  • New: [XML Destination] Component for generating XML files. - 2705
  • Fixed: [General] Duplicated columns in asynchronous error output when metadata dependent changes are made. - 2983
  • Fixed: [Database Destination] Eliminate compilation warning messages. - 2982
  • New: [REST] Enable token retrieval via Microsoft Edge WebView2.
  • New: [Design-Time] The design time features in Visual Studio require .NET Framework 4.5 or later - 2972
  • New: [Microsoft Dataverse] Support for update picklist field with both name and code, update/upsert with alternate keys, upsert using "Duplicate Detection Rules". - 2981
  • Fixed: [Preview] "Input string was not in correct format." tooltip when column name contains {}. - 2979
  • Fixed: [REST] Streamlined and simplified parameters UI definition further. - 2978
  • New: [Smartsheet] Enhanced parameters UI. - 2977
  • Fixed: [REST] Retrieval of dependent parameter collection failed because of missing parameters reference. - 2976
  • Fixed: [General] Closing the components' editors with OK button may skip refreshing the metadata (if after a significant change the user has not moved to another page). - 2974
  • Fixed: Better handling of input columns in components with multiple inputs. - 2973
  • Fixed: [REST] Updated definitions of parameter editors for consistency. - 2971
  • Fixed: [Database Destination] "Cannot Resolve Collation Conflict" when using SQL Server and ADO.NET. - 2967
  • New: [Twilio] Definition for 'Message' resource. - 2969
  • Fixed: [Data Flow Task Plus] Issues with PDW Destination when working with Flat File Source in dynamic data flow. - 2933
  • Fixed: [Visual Studio Addon] In some situations "Remove Static Columns" didn't work for particular destinations components in Data Flow Task Plus. - 2914
  • New: [REST] Support for parameters of type "Cookie". - 2965
  • New: [SurveyMonkey] Enhanced parameters UI. - 2963
  • Fixed: [JSON Destination] "Duplicate element name" error in scenarios with multiple input columns with two dots in their name. - 2961
  • New: [Jira] Support for expand field when querying "Issue" resource. - 2957
  • Fixed: [Sage Intacct] Improve error handling. - 2958
  • Fixed: [Salesforce Source] a regression issue with bulk mode. - 2956
  • New: [Database Destination] Support DB2 running on "IBM i" operating system (ODBC and MS OLEDB). - 2915
  • Fixed: [JavaScript] Memory overflow error - 2952
  • New: [Sage Intacct] Implemented parameter to explicitly select relationship fields to read. - 2951
  • New: [REST] Resolve "Multiple selection list Editor for Rest Source and Destination" - 2950
  • New: [REST] BigCommerce configuration - 2929
  • Fixed: [Core] SSIS Catalog package execution failures after installation on machine with SQL Server Data Tools installed. - 2945
  • New: [REST Editor] Editor definition enhancements. - 2944
  • Fixed: [REST Connection] Cannot create token for the second time. - 2943
  • Fixed: [Salesforce Source] Support relationships to custom objects in nested queries. - 2934
  • Fixed: [SharePoint Source] Do not alphabetically sort the columns. - 2939
  • Fixed: [Sort Plus] The memory limit (in MaxMemoryAllowed) property was not respected very strictly in various situations.
  • New: [Sort Plus] Added new property LoggingLevel for controlling what gets logged and MaxParallelOffloads and BlobColumnsMaxBytes properties for more precise control over memory management. - 2864
  • Fixed: [Data Flow Task Plus] Issue with handling of asynchronous error output in a destination component with composite data. - 2925
  • Fixed: [Dynamics Business Central] Modifications for on-premises service support. - 2910
  • Fixed: [Salesforce Source] Issue with parsing some SOQL queries with newlines - 2935
  • Fixed: [Typeform] Form response for text fields was not extracted properly. - 2930
  • New: [Tableau Destination] Add support for multi table extract hyper file. - 2926
  • Fixed: [MongoDB Destination][REST Destination][Fix] [MongoDB Destination][REST Destination] Included code to synchronize error output columns with main input during metadata reinitialize. Same code is already used in other destination components processing composites. - 2922
  • New: [Data Flow Task Plus] Implemented to report improved error messages for COM exceptions. - 2921
  • New: [Excel Task Plus] "Set cell" action now accepts variables of any type, not just string. - 2919
  • New: [Hubspot] Modified Scope parameter default to follow latest Hubspot guidelines. - 2917
  • New: [REST Destination] Enable extracting extra fields in error output, upon creating/updating records (via ErrorHandling.SuccessMessage definition). - 2911
  • Fixed: [Microsoft Dataverse] Corrected not to create records when using Update action. - 2912
  • Fixed: [REST Connectipn] Authorized Token Dialog storage type radio buttons HDPI scaling issue. - 2867
  • New: [Power BI] New configuration. - 2909
  • New: [IMAP Connection Manager] Support for Google OAuth 2.0
  • New: [SMTP Connection Manager] Support for Google OAuth 2.0 - 2904
  • Fixed: [Smartsheet] Configure some text/number fields - 2905
  • New: [Kronos] Support for global reports. - 2903
  • Fixed: [Database Destination] Proper handling of DT_DBTIME2 and DT_DBTIMESTAMPOFFSET input column types when using OLE DB driver.
  • Fixed: [LDAP] In Active Directory attributes from auxiliary classes were missing in object metadata (e.g. sAMAccountName missing in user).
  • Fixed: [Microsoft Dataverse] Lookup fields reset.
  • Fixed: [REST] Do not ignore NULL fields in Set.
  • Fixed: [REST] Encrypt additional parameters in authentication token.
  • Fixed: [REST] Fix XML string formatting in WSDL import.
  • Fixed: [REST] Regression issue leading to ignoring some action.
  • New: [GoToWebinar] Client Id/Secret for authentication token are now configurable.
  • New: [Google BigQuery] Implemented enhanced configuration for various parameters.
  • New: [Installer] Eliminate dependency issue, related to Microsoft.Diagnostics.Tracing.EventSource.dll occasionally removed from GAC.
  • New: [Installer] Simplify deployment of Sage.SData.Client.35.dll and Jurassic DLLs.
  • New: [JSON Source] Support parsing of date values in case the output column has been manually changed to a date one.
  • New: [JavaScript Component] Support for dynamic data flows.
  • New: [Linkedin] Definition for 'Page Statistic' resource.
  • New: [Microsoft Dataverse] Support for attributes alias in FetchXml.
  • New: [OFTP Connection Manager] Introduced a connection manager for Odette File Transfer Protocol.
  • New: [REST Destination] Support for parallel writes via a new property "MaxParallelThreads".
  • New: [SendGrid] Updated 'Single Send' resource metadata.
  • New: [Shopify] Defined additional resources.
  • New: [Visual Studio Addon] A new context menu item "Analyze columns usage..." for Data Flow Task to remove unused outputs and columns.
  • Fixed: [General] Preview in some source components editors was very slow when displaying many columns.
  • Fixed: [Installer] Jurassic.v4.5.dll was not installed in GAC on servers with SQL Server 2019.
  • Fixed: [LDAP Destination] Properly handle input columns of type DT_TEXT/DT_NTEXT.
  • Fixed: [REST Connection Manager] A regression with not being able to browse to a file (e.g. in Google BigQuery "Service Account" authentication).
  • Fixed: [REST] Don't wrap undefined and null in utils.ensureArray function.
  • Fixed: [REST] Incorrect handling of text content response.
  • New: [Blackbaud] Support for reading 'School | User' using new list id API.
  • New: [Capsule CRM] New configuration.
  • New: [Excel] Use latest FlexCel 7.14.0.0 library version.
  • New: [File Transfer Task] When creating a new connection, display the supported list of REST configurations to enable quicker selection.
  • New: [Google Cloud Storage] New configuration.
  • New: [Microsoft Dataverse] Defined separate components for lookup fields.
  • New: [Multiple] More detailed logging in several destination components.
  • New: [REST Config Editor] Display Editor of user defined property.
  • New: [REST] Support for client certificates.
  • New: [Sage Intacct] Improved handling for object detail fields.
  • New: [Salesforce] Updated to use latest 54 API version.
  • Deprecated: [OneDrive] Use 'Microsoft Graph' configuration instead.
  • Fixed: [ArcGIS Feature] Corrected based endpoint template to follow ESRI documentation example.
  • Fixed: [Base] Error Disposition page in various components editors didn't save edits unless the user moved to another page before closing the editor.
  • Fixed: [Base] If there is an exception during the list loading, the VS crashes.
  • Fixed: [Base] Mappings page preserve sorting of columns after refresh.
  • Fixed: [Blackbaud] Pagination definitions for the School endpoints are now in the base template.
  • Fixed: [Bloomerang] The pagination had to be corrected to stop if the amount of records retrieved is less than the specified batch size.
  • Fixed: [Data Flow Task Plus] Define empty mapping for configured destination columns.
  • Fixed: [Data Flow Task Plus] Depending on how project/solution is loaded in Visual Studio, the editor was not displayed on double-click.
  • Fixed: [Data Flow Task Plus] Detect when multiple source columns are mapped into the same destination column.
  • Fixed: [Data Flow Task Plus] Failure to process with not mapped column definition and specified mandatory list.
  • Fixed: [Data Flow Task Plus] Fixed issue related to Flat File Connection and downstream failures after first iteration.
  • Fixed: [Data Flow Task Plus] Implemented to report what modules fail to dynamically load.
  • Fixed: [Data Flow Task Plus] Issue with executing against SQL Server 2012.
  • Fixed: [Data Flow Task Plus] Issue with using ColumnAdded event handler when DelayValidation is False.
  • Fixed: [Data Flow Task Plus] Modified to configure script object model only if there is a script.
  • Fixed: [DataFlow Source] Issue when using in dynamic data flows.
  • Fixed: [Database Destination] Add handling for bulk processing for not officially supported databases.
  • Fixed: [Database Destination] Crash when loading list of tables for a given schema using the latest MySQL ODBC driver.
  • Fixed: [Database Destination] Error message missing when DB2 ADO.NET driver is used and the component is set to fail.
  • Fixed: [Database Destination] Error when SQL Server destination table uses user-defined type, as aliases.
  • Fixed: [Database Destination] In OLE DB bulk mode error rows were always redirected, regardless the setting.
  • Fixed: [Database Destination] In SQL Server the TempSchema property was ignored (tempdb was always used).
  • Fixed: [Database Destination] Issue with default value for BIT data type in ODBC.
  • Fixed: [Database Destination] Issues with handling NULL values in regular (non-bulk) mode.
  • Fixed: [Database Destination] Recognize IBM DB2 OLE DB driver.
  • Fixed: [Database Destination] Redirect rows violating integrity constraint when ODBC connection in bulk mode is used.
  • Fixed: [EDI Connection] Crash upon changing metadata in the EDI configuration file.
  • Fixed: [EDI Connection] Crash when Windows FIPS-only security setting is enabled.
  • Fixed: [EDI Destination] Issue with truncateable segments.
  • Fixed: [EDI Destination] Remove redundant subcomponent separator.
  • Fixed: [EDI Source] Escape symbol was not handled properly when multiple delimiter symbols were in use.
  • Fixed: [Eventbrite] Modified to use different Eventbrite app registration.
  • Fixed: [File Transfer Task] Remove redundant trailing slashes in folder names when browsing for an item.
  • Fixed: [File Transfer Task] Upload with specified full remote file path failed.
  • Fixed: [GoToWebinar] Issue with pagination.
  • Fixed: [Google BigQuery] Failed to read from Tabledata resource.
  • Fixed: [Google BigQuery] Included definition for NUMERIC field type.
  • Fixed: [Google Drive] Crash due to folders with thousands of items.
  • Fixed: [Google Drive] Item root folder was not configured properly in the GDrive.FileManager.getListing method.
  • Fixed: [Google Drive] Google.GDrive.getChildren function doesn't include the special @shared element.
  • Fixed: [Hubspot] Support for update of contact email.
  • Fixed: [Infusionsoft] Miscellaneous fixes.
  • Fixed: [JavaScript Component] Attempted conversion of the object to a primitive value failed.
  • Fixed: [JavaScript Component] Don't replace variables when reading code and parameter values.
  • Fixed: [Message Queue Task Plus] Fix validation when Action is ConfirmDelivery (queue is not needed).
  • Fixed: [Message Queue Task Plus] Got a "Body is not binary type" error when trying to read string message in AMQP compatible queue.
  • Fixed: [Message Queue Task Plus] Shouldn't require a value in a variable to pass validation.
  • Fixed: [Message Queue Task Plus] The General tab in the editor was empty.
  • Fixed: [Microsoft Dataverse] Implemented to generate new identifier for Upsert when no identifier is provided.
  • Fixed: [Microsoft Dataverse] In FetchXML processing take in account the specified attributes and the top element.
  • Fixed: [Microsoft Dataverse] Included code for handling of systemuser and team lookup fields.
  • Fixed: [Microsoft Dataverse] Included definition for proper create and update of lookup type fields.
  • Fixed: [Microsoft Dataverse] Modified to more reliably set the resource key field.
  • Fixed: [Microsoft Dataverse] Modified to enable for update child entities.
  • Fixed: [Microsoft Graph] Corrected Test URL for Service authentication.
  • Fixed: [Microsoft Graph] Fixed default Read endpoints.
  • Fixed: [Microsoft Graph] issue with setting of boolean values.
  • Fixed: [Mongo DB Connection] The "replicaSet" parameter is now optional.
  • Fixed: [NetSuite] Missing custom fields for 'VendorCredit' record.
  • Fixed: [ODBC Destination] Issue with incorrect handling of milliseconds in date values.
  • Fixed: [ODBC Destination] issue when inserting NULL values in numeric field with precision > 15 in PostgreSQL.
  • Fixed: [Package Connection] Visual issue when referencing a package (only in high-DPI).
  • Fixed: [Pipedrive] Custom field value was not retrieved properly.
  • Fixed: [PowerShell Task ] Disappearing "Script" tab contents after clicking "None".
  • Fixed: [Query] Use double quote (") for quoting names, because the square brackets are supported only by SQL Server.
  • Fixed: [REST Configuration Editor] The validation of the currently edited JS module didn't allow referencing code from other JS modules.
  • Fixed: [REST Connection] High-DPI issue with dialog for starting a new custom REST configuration.
  • Fixed: [REST Connection] Skip problematic empty path in Open API files.
  • Fixed: [REST Connection] Some HTTP requests were not retried in accordance with the Retry settings in the Advanced tab.
  • Fixed: [REST Connection] Some items might not be visible in OpenAPI import, due to missing scroller.
  • Fixed: [REST Connection] Location of the current element in Custom configuration editor not fully displayed when not fitting in a single line.
  • Fixed: [REST Destination] A crash in case Resource Manager parameters are not initialized.
  • Fixed: [REST Destination] Issue with configuring composite fields.
  • Fixed: [REST Destination] Small update to use the common extension method for NULL detection.
  • Fixed: [REST Source] A rare issue with processing fields in composite objects.
  • Fixed: [REST Source] Preview page may crash when displaying a huge number of columns.
  • Fixed: [REST Source] When editing parameters 'Delete' key was deleting the entire value instead of a single character.
  • Fixed: [REST Source] an issue when opening the detailed view for an individual row from the Preview page.
  • Fixed: [REST] Add proper "Content-type" depending on SOAP version when importing from WSDL.
  • Fixed: [REST] Better handling of JavaScript undefined values.
  • Fixed: [REST] Build proper resource's fields when importing from WSDL.
  • Fixed: [REST] Corrected element overwrite detection when processing Field.Item definitions.
  • Fixed: [REST] Cosmetic improvements in the wizards for importing OpenAPI and WSDL definitions.
  • Fixed: [REST] Crash when editing parameters without definition.
  • Fixed: [REST] Crash when there are no parameters configured for URL fields.
  • Fixed: [REST] Don't allow underscore in imported OpenAPI resource names, as it is a reserved symbol.
  • Fixed: [REST] Failed authentication when the connection was used in multiple parallel threads.
  • Fixed: [REST] Failed to cast values from array into string.
  • Fixed: [REST] Issue with handling minus (-) symbol, when converting from XML to JSON.
  • Fixed: [REST] Issue with processing JSON with numbers expressed in scientific notation, where the second part starts with a zero (e.g. -7E-05).
  • Fixed: [REST] Modified not to execute an action if input set is empty after excluding special fields.
  • Fixed: [REST] Modified to apply first explicit Read templates (higher priority).
  • Fixed: [REST] Modified to be possible to "short-circuit" the initialization of external resource fields from the configuration.
  • Fixed: [REST] Non-enumerable parameters are now properly ignored when preparing the web request.
  • Fixed: [REST] Preserve endpoints order when deselecting endpoints from the wizard in OpenAPI Import.
  • Fixed: [REST] Search for types in getClrType also in already loaded assemblies.
  • Fixed: [RabbitMQ Connection] RoutingKey visible in Send Message according to Exchange type.
  • Fixed: [RabbitMQ] Durable exchange error.
  • Fixed: [RabbitMQ] Message manual delivery problem.
  • Fixed: [Salesforce Destination] NullReferenceException error related to external columns with custom properties.
  • Fixed: [ServiceNow] Retrieve less fields to construct the resource's metadata.
  • Fixed: [Shopify] Implemented common object definitions for reuse in multiple resources.
  • Fixed: [Shopify] Updated to use latest API version.
  • Fixed: [Smartsheet] Implemented proper handling for text/number fields.
  • Fixed: [Table Difference] Clarify that "Update ID" applies only to "Compare" columns (i.e. not "Use New" and "Use Old").
  • Fixed: [Tableau] Incorrect pagination definition.
  • Fixed: [Tableau] issue with refresh token handling.
  • Fixed: [Teamwork] Pagination support.
  • Fixed: [UiPath] Disabled Read for Log resource.
  • Fixed: [Visual Studio Addon] In Visual Studio About box, a wrong version/build number of the extension was displayed
  • New: Support for custom Amazon S3 properties in File Transfer Task UI.
  • New: Support multi-root XML string formatting in REST Source/Destination parameters.
  • New: [Amazon Athena] New configuration.
  • New: [Amazon S3] Modified existing Amazon S3 Task/Connection to inform they are deprecated by a REST-based configuration
  • New: [Amazon S3] Support for session token.
  • New: [Azure Table] New configuration.
  • New: [Base] Enable drag&drop of variable placeholders in task & component editors.
  • New: [Base] In the mapping screen for destination components, indicate which columns differ in data type and other column properties.
  • New: [Blackbaud] Included more definitions update and delete in 'Church | Gift' resource.
  • New: [Blackbaud] Included support for new NXT endpoints.
  • New: [Database Destination] Support for custom WHERE clause for UPDATE, DELETE and UPSERT actions.
  • New: [Database Destination] Support for triggers firing.
  • New: [Dynamics Business Central] New configuration.
  • New: [Dynamics CRM Connection] Permit creation of connection manager without specifying "Organization" parameter" (workaround for the disabling of the discovery service for Dynamics 365).
  • New: [EDI Connection] Validation for problematic characters in xmlTag in EDI config files.
  • New: [EDI Destination] Add support for escaping delimiters.
  • New: [File Transfer Task] Add support for Salesforce Files.
  • New: [File Transfer Task] In the files/folder browser display also files when "Action" is "Receive files" or "Delete remote files".
  • New: [File Transfer Task] Support for recursive sending of subfolders.
  • New: [File Transfer Task] Support for retrying upon intermittent errors.
  • New: [Google BigQuery] Implemented support for nested (RECORD) fields.
  • New: [Google Maps] New configuration.
  • New: [Google People] New configuration.
  • New: [Installer] Abort the setup if SSIS/SSDT prerequisites are not installed.
  • New: [JavaScript] Expose additional properties and methods of Microsoft.SqlServer.Dts.Runtime.Variable to use in JavaScript scripting.
  • New: [JotForm] New configuration.
  • New: [Kintone] New configuration.
  • New: [License Manager] Target .NET Framework 4.0.
  • New: [LinkedIn] The client id and secret are now configurable during the token generation.
  • New: [Microsoft Dataverse] Add support for FetchXML in data retrieval.
  • New: [Microsoft Dataverse] Included support for 'continue-on-error' data processing.
  • New: [Microsoft Dataverse] Support for FetchXML -> link-entity element.
  • New: [Microsoft Graph] Enhanced configuration for various parameters.
  • New: [PDF Source] Introduced component for reading tabular data from PDF files.
  • New: [Pardot] Implemented support for OAuth authentication. Other improvements and enhancements.
  • New: [Parquet Destination] Add support for Apache Parquet files generation.
  • New: [Parquet Source] Support for reading Apache Parquet files.
  • New: [PayPal] New configuration.
  • New: [PowerShell Task] Expose additional properties and methods of Microsoft.SqlServer.Dts.Runtime.Variable to use in PSH scripting.
  • New: [QuickBooks Online] New configuration.
  • New: [REST] Allow setting a template field for a template field in REST Editor.
  • New: [REST] Custom editor for user parameters in XML format.
  • New: [REST] Deduce the JavaScript transformation expression necessary to parse a response from an example.
  • New: [REST] Enable storing REST API Tokens in SQL Server.
  • New: [REST] Import of WSDL definition for interacting with SOAP services
  • New: [REST] Support for enhanced UI controls populated with JavaScript.
  • New: [REST] Updated OpenApi.NET to v.1.2.3 .
  • New: [Salesforce Connection] Up-to-date Salesforce URLs (production and sandbox) in the Advanced tab.
  • New: [Salesforce Source] Elaborate & optimize usage of LIMIT statement in metadata initialization.
  • New: [Salesforce Source] Prevent errors in metadata initialization due to WHERE clause leading to no records returned for analysis.
  • New: [Salesforce] Introduce settings for automatic retries for handling intermittent errors.
  • New: [Stripe] New configuration.
  • New: [Typeform] New configuration.
  • New: [Zoho Sheet] New configuration.