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