Published:
Tuesday, January 25, 2022 - 07:13
- 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
ColumnAddedevent handler whenDelayValidationisFalse. - 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
TempSchemaproperty was ignored (tempdbwas 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
Tabledataresource. - 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.getListingmethod. - Fixed: [Google Drive]
Google.GDrive.getChildrenfunction 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
topelement. - 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
Readendpoints. - 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
undefinedvalues. - Fixed: [REST] Build proper resource's fields when importing from WSDL.
- Fixed: [REST] Corrected element overwrite detection when processing
Field.Itemdefinitions. - 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
getClrTypealso 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
Readfor 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.