Published: Tuesday, August 27, 2024 - 05:52
New: [Pardot] Included 'Visitor Activity' resource. - 3978
New: [Hubspot] Included 'Form Submission' resource. - 3980
New: [BigCommerce] Implemented to use new Category endpoints. - 3977
Fixed: [ZipTask] Issue with TAR compression of files, with sizes bigger than 8GB - 3969
Fixed: [JavaScript] An ocassional error "The directory is not empty" in the post-execution cleanup. - 3960
Fixed: Transferring a file from one REST-based File Manager to another via In-memory stream variables trims data - 3967
Fixed: [Zip Task] A regression issue with Zip AES decompressing. - 3962
Fixed: Various issues with renaming items in Google Drive - v2.1 - 3959
Fixed: [Composite Records] The escaping of . in names of composite outputs/inputs of components is now _ (for consistency). - 3964
Fixed: [File Transfer Task] For "Get remote file list" with REST connections, folders couldn't be excluded by "RemoteFilter" expression - 3954
Fixed: [File Transfer Task] Sometimes the selection in the File Browser didn't activate properly the OK button in the dialog. - 3952
Fixed: [File Transfer Task] Path was not always configured with the correct separator. - 3948
Fixed: [Blackbaud] Corrected Read.Result definition for 'NXT | Constituent' resource. - 3945
New: [Excel Source] Property TrimColumnNames to specify whether to remove whitespace from start/end of column names - 3931
New: [OpenAPI Import] Support for schema types with multiple references - 3935
Fixed: [Parquet] Issues with composite records supports
Fixed: [Parquet] Change the default column length for string columns to 250 - 3934
New: [Shopify] Replaced value_type with type in metafield. - 3932
Fixed: [Table Difference] Have a row for each difference among comparable rows, not just the first difference - 3923
New: Use Secure cookies to prevent vulnerabilities when using HTTP - 3925
Fixed: SpashForm always wait VS Editor in component load - v2.1 - 3922
Fixed: [REST] Increased result Id column length. - 3907
New: [Zendesk] Updated 'Organization Membership' resource to use cursor pagination. - 3904
Fixed: [Google BigQuery] Corrected expression for Job.Create action. - 3899
Fixed: [Exchange] Removed Test definition because it is not needed. - 3896
Fixed: [Database Destinatinon] Crash in dynamic flow context, in case not all input columns are used - 3894
Fixed: [JavaScript Component] Possible crash on first change of metadata - 3888
Fixed: [REST] Better handling of nil=true attributes from XML responses - 3885
Fixed: [QuickBase] Configure field names to exclude special dot (.) character. - 3880
New: JavaScript Function to return input column names - 3877
Published: Tuesday, April 23, 2024 - 11:26
Fixed: [FLEE] Expression editor was not highlightning properly some keywords and SSIS variables
New: [Editor] Have a distinctive highlight of SSIS variables in various places where SQL-like expressions are used - 3869
Fixed: [SendGrid] Corrected Bounce resource metadata. - 3867
New: [JavaScript] Include detailed stack trace information in dot template expressions evaluation (REST configuration) and in other contexts, as well. - 3865
New: [Preview] When previewing data in REST Source and Salesforce Source differentiate b/n NULL and empty strings - 3863
Fixed: [Base] Rework variable replacement logic in FLEE expressions (2.1) - 3861
Fixed: [WSDL] Error in addSecurityBody when using custom authentication
Fixed: [WSDL] When analyzing the types in the response, by default prefer direct child types instead of inherited types - 3857
Fixed: [REST] Resolve ""Block length does not match with its complement." issue with RestSharp" - 3843
New: [Amazon S3] Support for VPC endpoints - 3840
Fixed: [Microsoft Graph] Implemented to remove symbols from list column names... - 3845
New: [Blackbaud] Included definition for new /creditmemos API. - 3841
Fixed: [REST] Modified to ignore undefined values when handling structured fields. - 3836
New: [Blackbaud] Included additional metadata in 'Church | Gift' resource. - 3835
Fixed: [Data Flow Task Plus] - a regression issue with setting scale and precision for some data types in destination components (e.g. OLEDB Destination) - 3825
Fixed: [Zendesk] Corrected Ticket -> Search pagination. - 3814
Fixed: [Base] Registry-free process was not handled correctly. - 3800
Fixed: [JSON Source] issue with not properly quoted string in array in a DT_NEXT column (was not a valid JSON array)
Fixed: [MongoDB Source] issue with not properly quoted string in array in a DT_NEXT column (was not a valid JSON array) - 3792
New: [Microsoft Graph] Included additional definitions. - 3788
Fixed: [Hubspot] Updated default authentication scope. - 3782
Fixed: [REST] Better error handling when failing the retrieve a token via Edge web control - 3778
Fixed: [REST] Unable to handle response in Iterator.Next.Value when only Read.Result is used. - 3766
Fixed: [SSH] Previous folder restore may fail after upload. Ignore. - 3763
Fixed: [WSDL Import] Regression issue with import without a specified location - 3755
Fixed: [REST Destination] Exception "COM object that has been separated from its underlying RCW cannot be used." when processing BLOBs. - 3753
Fixed: [Square] Fix recently introduced syntax error - 3751
Fixed: [Linkedin] Fixed incorrect DoT definition. - 3743
New: [Square] Updated configuration to use the default redirect_uri . - 3736
New: [Zendesk] Updated configuration to use the default redirect_uri . - 3734
New: [REST] Display documentation about token parameters when retrieving a new token - 3732
New: [Smartsheet] Updated configuration to use the default redirect_uri . - 3729
New: [WSDL] Support for specifying namespaces of parameters in READ operations - 3726
New: [MailChimp] Updated configuration to use the default redirect_uri . - 3721
Fixed: [Base] Prevent sending excessive runtime telemetry - 3699
Fixed: [REST] Incorrect processing of request Url definition when Service element defined. - 3696
Published: Wednesday, November 1, 2023 - 09:13
Fixed: [REST] Evaluate definitions wrong result in parallel execution - 3691
Fixed: [OpenAPI Import] crash when no schema is specified for an array element - 3682
Fixed: [Microsoft Graph] Modified to configure more user-friendly list columns - 3673
New: [REST] Included resource name in list editor caching process. - 3672
Fixed: [ADP] Remove ZERO WIDTH SPACE (U+200B) characters. - 3666
New: [OpenAPI Import] Automatically configure the processing of endpoint responses that are not simply arrays - 3663
Fixed: [Power BI] tenant parameter was not used during OAuth token generation. - 3127
Fixed: [Trello] Updates in CardT template. - 3655
Fixed: [JavaScript] A deadlock occurring in some rare situations - 3653
Fixed: [WSDL Import] Issue when referencing an external XSD with importelement - 3644
Fixed: [OpenAPI Import] Error when path ends with a slash - 3646
Fixed: [PureCloud] Fixes in 'Datatable Row' resource. - 3645
Fixed: [Google BigQuery] DATETIME field type was not handled properly. - 3642
Fixed: [OpenAPI Import] Allow the import to continue if there are no fatal errors. - 3638
Fixed: [REST] Minor fixes in different REST configurations. - 3637, 3631
New: [REST Configuration Editor] Show warnings for circular references in template fields
New: [Open API Import] Sort endpoints in the Import Wizard by path (easier finding) - 3625
Fixed: [SugarCRM] Various fixes. - 3630
Fixed: [Shopify] Service reports next page marker inconsistently with different case. - 3626
Fixed: [REST] In parameters editor be able to use the editor popup for existing parameters, not just new ones. - 3624
Fixed: [QuickBase] Failure in data query. - 3617
Fixed: [AMQP Connection] Support for TLS 1.2 - 3611
New: [Parquet Source] Improve support for timespan values - 3613
New: [OpenAPI Import] Various small improvements
New: [WSDL Import] Various small improvements - 3489
Fixed: [File Transfer Task] Specifying only wildcard for the Remote parameter (no folder) caused failure when using 'Receive Action'. - 3606
Fixed: [OpenAir] Included UserWorkschedule type. - 3604
Fixed: [WSDL Import] Various small issues - 3602
New: [Kafka] Add support for logging
New: [Kafka] Update Conluent.Kafka client to 2.1.1 - 3605
New: [JSON Destination] Support for storing result into a stream Variable" - 3592
New: [XML Destination] UI for type and variable - 3591
Fixed: [REST] Modified not to use Path methods which are unable to handle path containing double quote (") characters. - 3585
New: [JSON Destination] Improve behavior in dynamic data flows by outputting all upstream columns - 3586
New: [Zendesk] Included cursor pagination for Ticket and User resources. - 3589
New: [Microsoft Graph] Support for delta endpoint in Message resource. - 3582
Fixed: [Amazon S3] Upload from stream variable - 3576
New: [Base] Implemented to set transfer stream name from configured storage variable description. - 3578
New: [Copper] Implemented to configure array for parameters with suffix _ids. - 3573
Fixed: [Google Cloud Storage] Use more appropriate endpoint for testing connectivity for 'Service Account' - 3095
New: [WSDL Import] Improve error message in case referenced element is missing - 3567
Fixed: [File Transfer Task] Incorrect initialization of output stream. - 3564
Fixed: [General] Some destination editors crashed when displaying a tooltip if the column name contained special symbols like {} - 3522
Fixed: [ArcGIS Feature] Various improvements. - 3557
Fixed: [NetSuite Source] High-DPI scaling in Query designer
Fixed: [Dynamics GP] High-DPI scaling in Query designer
Fixed: [QuickBooks Source] High-DPI scaling in Query designer - 3523
Fixed: [Kafka] Issues with incorrect and incomplete list of SSL-related properties - 3553
Fixed: [SugarCRM] Made client_secret authentication parameter optional. - 3549
Fixed: [Hubspot] Failed to upload file using 'File Transfer Task'. Other... - 3547
Fixed: [Sage Intacct] Corrected metadata in 'Attachment Legacy' resource. - 3546
Fixed: [KRONOS] Defined hr_customFields and pay_info fields under Employee resource. - 3543
New: [File Transfer Task] Support for setting file permission in SFTP after upload - 3540
Fixed: [Base] Modified LoadSimpleKeyValueList function to use case-insensitive dictionary. - 3539
Fixed: [Zendesk] Fixes in 'Ticket Field Option'. - 3529
Fixed: [Microsoft Graph] Removed wrong definitions. - 3528
Fixed: [Zoho CRM 2] Removed wrong definition. - 3531
Fixed: [Smartsheet] Removed wrong definition. - 3530
New: [Parquet] Support for "date" and "time" fields
Fixed: [Parquet] Rename "datetimeoffset" type to "timestamp"
New: [Parquet Destination] Accept other input data types besides DT_DBTIMESTAMPOFFSET when outputting timestamps - 3499
New: [WSDL/SOAP] Support for more granular (field-level) namespaces in SOAP services - 3518
Fixed: [REST Source] Crash when handling in a dynamic data flow consequtive resources with a single and then multiple outputs. - 3512
Fixed: [File Transfer Task] Regression issue with receiving "Access Denied" error, in case SFTP server doesn't support changing directories - 3513
Published: Thursday, July 13, 2023 - 04:19
Fixed: [Base] Code that serialized script parameters into variables failed when project parameters were prefixed with underscore (_) character - 3505
Fixed: [JSON Destination] Issue with opening the Editor before specifying the JSON sample - 3500
Fixed: [Data Flow Task Plus] Remove special THUNK_COLUMN if included in 'Data Conversion' component - 3496
Fixed: [Smartsheet] When clear parameter was configured, the destination sheet was incorrectly reset during design time - 3490
Fixed: [REST] WebView2 module crash when trying to handle localhost hookup. - 3487
Fixed: [Sage Intacct] Included definition for create_sotransaction action.... - 3479
New: [Hubspot] Increased Contact resource action batch limit to 1000. - 3480
New: [LDAP Destination] Support for changing user passwords in Active Directory (via the "unicodePwd" field)
Fixed: [LDAP Destination] An issue with DT_GUID and DT_DBTIMESTAMP values
New: [LDAP Destination] Include complete error details in error messages - 3466
New: [LDAP Destination] Support for renaming objects (via updating their CN) - 3157
Fixed: [Base] Stream abstraction over BlobColumn is no longer attached to current buffer row. - 3476
Fixed: [REST] Failed to retrieve complex structured fields. - 3474
Fixed: [Parallel Loop Task] Error when executing parent->child package with parameters with coinciding names - 3472
Fixed: [Salesforce Source] Got NULL when an output column names differs from an external column name - 3464
Fixed: [REST] When preparing the payload for an action, preserve the order of the defined fields - 3460
New: [Parquet Source] Remove the Schema property and make the component more convenient to use in dynamic data flows - 3427
Published: Wednesday, May 24, 2023 - 05:16
Fixed: [PDF Source] Exception "Dictionary entry value is not indirect object." when loading a PDF document - 3389
New: [Blackbaud] Definition for school advisory API - 3450
Fixed: [QuickBooks Online] Correction for report Total composite. - 3447
New: [QuickBooks Online] Defined Report selector. - 3441
Fixed: [Power BI] Additional improvements. - 3440
New: [XML Destination] Support for importing XSDs with complex type extension
New: [XML Destination] Support for importing XSDs with repeatable group - 3419
Fixed: [REST Connection] Issues with property TokenStore
Fixed: [Exchange Connection] Issues with property ServerUser
Fixed: [SMTP Connection] Issues with property ServerUser
Fixed: [IMAP Connection] Issues with property ServerUser - 3437
Fixed: [Amazon S3] Improvements in configuration (2.1) - 3435
New: [NetSuite] Implemented to include name attribute in list reference fields output. - 3430
Fixed: [Install] Incorrect parent install folder for 64bit modules. - 3429
New: [QuickBooks Desktop] Enable TLS1.2 in QBConnector.exe - 3420
Fixed: [Google Analytics] Implemented report metadata initialization not to fail... - 3424
New: [Sage Intacct] Modified to select fields up to three levels deep. - 3422
New: [Database Destination] Oracle OLE DB bulk support - 3421
New: [REST Connection] UserAgent property - 3412
New: [Salesforce Source] Support for compound field Address - 3402
Fixed: [Kafka] Support semicolons in password (useful for connecting to Azure Event Hub) - 3414
Fixed: [REST Connection] Resolve "WSDL Importer page not fully visible in some high-DPI scenarios" - 3410
Fixed: [Blackbaud] Improved School resources pagination definition. - 3407
Fixed: [Amazon S3] Support for names containing + symbol - 3405
Fixed: [Dynamics Business Central] Additional fixes around the support for navigation properties. - 3398
Fixed: [General] Columns were not displayed in Error Output page of source components, when they were removed and added again - 3394
Fixed: [Destinations] Exception when opening a Component Editor when targeting SQL Server 2022 - 3388
Fixed: [Zendesk] Removed pagination in 'Ticket Field Option' resource. - 3383
Published: Wednesday, March 22, 2023 - 18:44
New: [Blackbaud] Included teachers definition in 'School | Section' resource. - 3378
New: [REST] Implemented JS-friendly method to get list of available resources. - 3373
Fixed: [XML Destination] Nested groups support. - 3369
Fixed: [General] Prevent a license check failure if license expires just after execution has started - 3372
Fixed: [Amazon S3] "Inefficient upload of file. - 3356
Fixed: [Microsoft Dataverse] Field's metadata caching was not updated after 'FetchXml' parameter modification. - 3361
Fixed: [Power BI] Various fixes and enhancements. - 3359
New: [Dynamics Business Central] Support for navigation properties. - 3357
New: [REST Connection] "New property "RequestsPerMinute". - 3349
Fixed: [Parquet Source] Upgrade SDK to Parquet.Net 3.10.0 to fix an issue with incorrect reading of some parquet files. - 3348
Fixed: [Blackbaud] Pagination never ends for School resources. - 3350
Fixed: [REST] Modified to skip composite fields when processing at the root. - 3342
Fixed: [Zendesk] Modified id field definition to accommodate larger identifiers. - 3337
Fixed: [Sage Intacct] Incorrect caching of all object relationship fields, instead of only loading from the list selected by the customer. - 3338
New: [Microsoft Graph] Included definition to retrieve Message from shared folder. - 3333
Fixed: [JavaScript] Optimized COM object release. - 3331
Fixed: [General] Error with SQL Server 2022 support, related to interface type 'CozyRoc.SqlServer.SSIS.Patch.IDTSBufferR' (affects multiple components) - 3328
Fixed: [XML Destination] Exception when importing XSD with "union" of base types
Fixed: [XML Destination] Exception when using the component in a loop. - 3316
Fixed: [JavaScript Component] Design-time error when selecting/modifying a script in case the main input has different properties from the existing one. - 3321
New: [General] Customize JavaScript syntax highlighter. - 3314
New: [General] "Tune how and which column differences are displayed in the mapping pages." - 3318
New: [REST] Support for updating a token in a Database storage. - 3317
New: [XML Destination] Use the standard SSIS+ 250 chars length for external DT_WSTR columns, instead of 50 (the change doesn't affect the runtime behavior) - 3312
Fixed: [Google Analytics] Multiple ranges report retrieve failed. - 3307
Fixed: [EDI Source] Configuration's delimiters were accidentally overwritten. - 3303
Fixed: [REST Source] Non-enumerable parameters appeared in the request during the fields metadata initialization. - 3301
Fixed: [REST Destination] Non-enumerable parameters appeared in the request during the fields metadata initialization. - 3301
New: [XML Destination] Auto-conversion from string to date values.
New: [XML Destination] Quickly navigate from mapping to model by double-click.
New: [XML Destination] Support for XSD "group" element - 3251
Fixed: [REST] According to OAuth1 specification the signature has to be generated for all lower-case 'Base String URI'. - 3293
Published: Sunday, February 12, 2023 - 06:37
Fixed: [SurveyMonkey] Fix incorrect page editor UI. - 3288
Fixed: [REST] Regular fields were incorrectly filtered out from action payload. - 3285
Fixed: [VS Extension] Fixed default icons of connection managers - 3276
New: [Licensing] The machine ID for ADF SSIS IR now explicitly contains the number of nodes - 3273
Fixed: [Amazon S3 REST] - "The path is not of a legal form." error during listing items in a bucket - 3252
Fixed: [REST] When logging is enabled, attempting to log the request content caused a crash - 3266
New: [Blackbaud] Modified to make the Test address to be customizable. - 3268
New: [Hubspot] Included additional definitions. - 3257
Fixed: [VS Extension] Show SSDT incompatibility warning just once - 3253
Fixed: [REST] Incorrect handling of requests containing Query parameters in OAuth1 module. - 3247
Fixed: [JavaScript] Prevent having temporary JS script files left out after execution of JS Component and JS Task. - 3238
New: [XML Destination] Performance improvements - 3233
Fixed: [Base] Restored a needed entry. - 3242
Fixed: [RabbitMQ] Hanging package executions when package is run as a part of a SQL Agent jobs (i.e. with ISServer.exe) - 3117
Fixed: [Excel Source] Processing of columns with type different from string... - 3231
Fixed: [Telemetry] When telemetry is turned off, skip unnecessary WMI queries - 3227
New: [Blackbaud] Replaced deprecated 'School | Dorm Resident' resource with... - 3224
New: [XML Destination] Support for self-referencing elements, attribute group references and simple type restrictions. - 3217
New: [Base] Updated with the official SQL 2022 and SSDT 4.3 modules. - 3216
New: [Base] Updated to use latest SSDT 4.3 manifest definitions. - 3213
Fixed: [REST] Modified to interpret empty string input for composite field as undefined. - 3207
New: [XML Destination] Simple type references support. Support choice located in Complex type. - 3206
New: [Shopify] Defined 'Discount | Price Rule' and 'Discount | Discount Code' resources. - 3203
Fixed: [Dynamics Business Central] Create/Update actions failed because there is... - 3201
Fixed: [Parquet Source] Crash when reading an empty data page
Fixed: [Parquet Source] Performance issue with "string" and "byte array" columns
Fixed: [Parquet Source] Streaming not properly working (big files consumed excessive memory) - 3195
New: [Zuora] Support for 'Data Query' functionality. - 3192
Fixed: [Google BigQuery] Incorrect processing for timeout parameter when... - 3185
New: [Zip Task] Support for decompressing ZIP files using deflate64 algorithm - 3132
Fixed: [Hubspot] Removed depreciated scope. - 3181
Fixed: [Smartsheet] Implemented improved handling of numeric input values when writing data. - 3177
New: [REST] Included ability to instantiate REST connection. - 3173
New: [XML Destination] Support for `` element when importing model from XSD. - 3139
Fixed: [XML Destination] Better default Scale for decimal columns. - 3169
Fixed: [REST] The non-enumerable parameters were incorrectly used in fields... - 3165
Fixed: [VS Extension] Invoking GetCanonicalName unmanaged function in earlier... - 3162
Fixed: [Zuora] Typo fix. - 3152
Fixed: [Formstack] Corrected portal avatar retrieval. - 3151
Fixed: [ADP] Fix in getActionData function. - 3145
Fixed: [Basecamp] Incorrect Question resource Name definition. - 3144
Fixed: [Sage Intacct] Issue when XML response returned no child data rows. - 3140
Fixed: [Message Queue Task Plus] Issue with the task after changing target version. - 3137
Fixed: [Hubspot] Updated scope parameter to match the scopes configured for the application. - 3134
New: [PDF Source] SkipIncompleteRows property to handle content with unexpected number of column values that's incorrectly recognized to be within a table and thus causing a runtime crash. - 3131
Fixed: [ActiveCampaign] Action payload not sent as body. - 3123
Fixed: [Hubspot] Modified to use the new Hubspot OAuth scope definitions. - 3120
New: [Amazon Athena] Modified to use region-specific authentication Test host address. - 3118
New: [Microsoft Graph] Defined Prompt parameter. - 3111
Published: Friday, October 14, 2022 - 04:44
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
Published: Thursday, August 4, 2022 - 11:43
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
Published: Thursday, June 23, 2022 - 15:52
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
Published: Thursday, June 9, 2022 - 16:45
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
Published: Friday, May 20, 2022 - 19:39
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
Published: Tuesday, April 26, 2022 - 09:41
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
Published: Monday, April 18, 2022 - 11:24
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
Published: Monday, March 7, 2022 - 04:02
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.
Published: Saturday, February 12, 2022 - 06:03
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.
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 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.
Published: Monday, May 17, 2021 - 07:56
