What's New

SSIS Productivity Pack

Detailed changelog for every release of KingswaySoft SSIS Productivity Pack

Version 21.2.1 - December 17, 2021

This release is mainly a service release, which comes with the following updates and fixes:

  • Cloud Storage
    • Enhancement: Performance enhancement when downloading non-exist file item from Azure Blob using Premium File Transfer Task.
    • Enhancement: Uploading files to Azure Blob Storage no longer makes API calls to list parent folder items when File Overwrite Mode is set to "Overwrite existing item" in Premium File Transfer Task.
    • Fixed: You may run into error "System.ArgumentOutOfRangeException: startIndex cannot be larger than length of string" in Premium File Transfer Task when downloading Azure Files files with "LESS THAN OR EQUAL TO" filter condition.
    • Fixed:  You may run into error "System.ArgumentOutOfRangeException: startIndex cannot be larger than length of string" in Premium File Transfer Task when downloading Azure Data Lake Storage Gen2 files with "LESS THAN OR EQUAL TO" filter condition.
    • Fixed: Pagination in OneDrive may not work properly.
  • Data Warehouse
    • New: Commands in Snowflake Task component now supports the execution of multiple-statement commands.
    • New: Pre & Post Commands in Snowflake Destination component now support the execution of multiple-statement commands.
    • Fixed: You may get a "Numeric value is not recognized" error in Snowflake Destination component when performing Bulk Copy action if the system has a special locale settings that uses "," as the decimal symbol.
    • Fixed: You may run into error "Load into table failed" in Amazon Redshift Destination component when Bulk Insert into Redshift table while the system has a special locale settings that uses "," as the decimal symbol.
  • JSON & XML Processing
    • Update: RequestHeaders and ResponseHeaders columns in HTTPRequests output now default to DT_NTEXT data type in JSON Source and XML Source components.
    • Fixed: XML Extract may output NULL value for those pass-through columns.
  • Google Services
    • New: We added Login Customer Id support in Google Ads Source component, which can be used to access the reporting data for a particular customer account.
    • Fixed: Google Drive Connection Manager may not take the provided OAuth ClientId value properly.
    • Fixed: Google Drive Destination component may not set mimeType properly when uploading files using Simple or Multipart upload mode.
    • Fixed: You may get "Cannot access a closed Stream" error in Google BigQuery Destination component when performing bulk actions.
    • Fixed: Google Ads Connection Manager may not set developer token properly when working with a token file generated by My Own App.
  • Marketing Intelligence
    • Update: Updated metadata for Bulk service in Bing Ads Source component.
    • Fixed: Retry on Intermittent Errors option in Bing Ads Connection Manager may not work properly.
  • NoSQL Components
    • Fixed: In some rare situations, you may get error "Could not load file or assembly 'MongoDB.Driver.Legacy' or one of its dependencies" in MongoDB Source/Destination component during runtime.
  • Premium Data Flow Components
    • New: Premium ADO NET Destination component now reports MySQL bulk load warnings in SSIS Execution Result when working with MySQL data provider.
    • Fixed: NULL value was written as 0 when performing Bulk Insert action to MySQL database through MySQL data provider in Premium ADO NET Destination component.
    • Fixed: Premium ADO NET Destination component may not write datetime values properly when working with MySQL data provider.
    • Fixed: "Append at end" write mode in Premium Excel Destination component may not work  properly when the component is configured to "Write No Column Header".
    • Fixed: "Calculated without format" Output Format may not work properly when reading with "Not Specified" Column Name in Premium Excel Source component.
  • Premium File Pack
    • Fixed: Premium File Transfer Task may cause Visual Studio to crash when repeatedly opening the component with constant double clicks.
  • REST Services
    • General
      • Fixed: REST Source component may report KeyNotFoundException when parameterizing the Source Object.
    • Magento
      • Fixed: Magento REST Source component may not output records correctly for the Search service endpoint.
    • SugarCRM
      • Enhancement: Improved API version detection when getting latest REST version.
    • Wordpress
      • Fixed: You may get error "Can not convert Array to String" when selecting certain endpoints in WordPress REST Source/Destination component .
    • Zoom
      • Update: Updated metadata for "Get User's Call Logs" endpoint to include more fields in Zoom REST Source component.

Version 21.2 - November 11, 2021

This release comes with the following updates and enhancements:

  • New Components
    • Cloud Storage
      • Google Drive Connection Manager
      • Google Drive Source
      • Google Drive Destination
    • Data Warehousing
      • Amazon Redshift Command Task
      • Google BigQuery Command Task
      • PostgreSQL Command Task
      • Premium ADO NET Command Task
      • Snowflake Command Task
    • HTTP/Web Services
      • AS2 Connection Manager
    • Message Queue Components
      • ActiveMQ Connection Manager
      • ActiveMQ Source
      • ActiveMQ Destination
      • SMPP Connection Manager
      • SMPP Source
      • SMPP Destination
    • NoSQL Components
      • Redis Connection Manager
      • Redis Source
      • Redis Destination
  • New services in the REST framework
    • DocuSign
    • Freshsales
    • GitHub
    • Pipedrive
    • Quickbase
    • Zoho Books
  • General
    • New: We added a new action button in the KingswaySoft License Manager which makes it easy to request a free trial.
    • New: We added limited password attempts feature to Connection Managers that use OAuth token file. When the limit is reached, access_token and refresh_token values will be deleted from the token file, this is to protect the file from unauthorized use. 
  • Big Data
    • New: EDI Destination component now supports transmitting EDI messages through AS2 Connection Manager.
    • New: We added EDI file writing properties support in EDI Destination component, which can be used to define the separator characters.
    • Fixed: Encoding in EDI Destination component may not work properly.
    • Fixed: You may get "System.InvalidCastException: Specified cast is not valid" error in Premium Data File Destination component when writing datetime values to a Parquet file.
  • Cloud Storage
    • New: We added VPC Endpoint support in Amazon S3 Connection Manager, which can be used to access Amazon S3 using AWS PrivateLink.
    • New: You can now manually specify S3 Endpoint in Amazon S3 Connection Manager.
    • New: We added a new "Download Chunk Size" option in the Box Connection Manager.
    • New: We added a new "Download Chunk Size" option in the OneDrive Connection Manager.
    • Update: We updated the API version to 2020-10-02 for Azure Blob Storage connection.
    • Update: We updated the API version to 2020-10-02 for Azure Data Lake Storage Gen2 connection.
    • Enhancement: There are some performance improvements when uploading files to Box using Premium File System Destination with Overwrite Mode.
    • Fixed: You may get "The given key was not present in the dictionary" error when reading Amazon S3 file properties in Premium File Properties Task while the S3 bucket has no folder records.
  • Data Generation and Anonymization
    • Fixed: Data Anonymizer component may create incorrect output values for RowIndex or Incremental Value anonymization type if the starting value and incremental value are different.
    • Fixed: Data Anonymizer component always outputs NULL values for RowIndex or Incremental Value anonymization type when the input value is NULL.
  • Data Warehousing
    • New: We added Amazon IAM Authentication Mode support in Amazon Redshift Connection Manager.
    • New: Snowflake Destination component now supports specifying Bulk Copy Temp Folder Prefix when using Bulk Copy.
    • Enhancement: We updated Snowflake client SDK to the latest v1.2.8 library.
    • Enhancement: Snowflake components now retry on 503 and 508 error codes.
    • Update: Preview function in Amazon Redshift Source component now always uses Explicit transaction type, this helps avoid committing changes during the preview query execution if there are any.
    • Update: Preview function in PostgreSQL Source component now always uses Explicit transaction type, this helps avoid committing changes during the preview query execution if there are any.
  • Data Quality and Comparison
    • Fixed: You may receive a KeyNotFoundException in Duplicate Detector when working with special character (like "İ") when the "Ignore Case" option is enabled.
    • Fixed: Duplicate Detector may report a KeyNotFoundException when using fuzzy Phone Number Match and the input value contains non-numeric character.
    • Fixed: In some rare situations, you may run into "String was not recognized as a valid Boolean" error in Duplicate Detector after upstream metadata changes.
  • Google Services
    • [General] New: Google service related connection manager now support using a JSON key file for the server-to-server authentication.
    • New: We added Google Analytics Data API support in Google Analytics Connection Manager, which can be used to extract report data for a Google Analytics 4 property.
    • New: Google Ads API support has been updated to v8.
    • New: We added Update/Upsert/Delete/FullSync action support when working with TABLEDATA object in Google BigQuery Destination component.
    • Fixed: Google BigQuery Destination component may fail with OutOfMemoryException when batch loads a large set of data.
    • Fixed: Uploading a 0 bytes empty file to Google Cloud Storage using Premium File Transfer Task may not work properly.
  • HTTP/Web Services
    • New: OAuth Token Generator now supports using .PEM private key file to generate OAuth JWT assertion token.
    • New: HTTP Connection Manager supports infinite timeout by setting the Timeout value to 0.
    • Fixed: Setting Host or Date HTTP header in HTTP Connection Manager may not work correctly.
  • JSON & XML Processing
    • New: We added Property Name From Column Value Source Type support in JSON Destination and JSON Merge components.
    • Enhancement: JSON/XML Destination/Merge components now retain input mapping when they are disconnected and re-connected from upstream components.
    • Fixed: XML Source/Destination/Extract/Merge component may report NullReference error when importing XSD file that has no schemaLocation attribute.
  • Mail Components
    • New: We added a new Resource Output in Email Source component, which returns those images contained in the email body.
    • Update: You can now change Tenant ID property when generating OAuth token for Exchange Web Service in the Email Connection Manager.
  • Marketing Intelligence
    • Fixed: You may get a System.IndexOutOfRangeException when working with Reporting object in Bing Ads Source component if only a few columns are selected in Columns page.
    • Fixed: Bing Ads Source component may report "Download report has corrupted data" when working working with Reporting.
  • Message Queue Components
    • New: Azure Service Bus Source component now supports working with Dead-Letter Queues.
    • New: AMQP Destination component now supports Delete message action.
    • New: Azure Service Bus Destination component now supports Delete message action.
    • New: RabbitMQ Destination component now supports Delete message action.
    • New: MSMQ Destination component now supports Delete message action.
    • Enhancement: There are some performance improvements when reading messages using the MSMQ Source component.
  • NoSQL Components
    • New: MongoDB source and destination components are significantly re-engineered, so they can both support complex JSON document structures. 
  • Premium Data Flow Components
    • New: Premium Derived Column component and Premium Expression Task now include support for the following new functions which can be used for logging purpose:
      • FireError()
      • FireInformation()
      • FireWarning()
    • New: Premium OData Source component now supports sending expand fields in $select query string parameter when working with SharePoint implementation.
    • Update: Premium OData Source component no longer fails on 404 Not Found error.
    • Update: Preview in Premium ADO NET Source component always uses Explicit transaction type.
    • Fixed: You may receive a KeyNotFoundException in Premium Excel Destination when one of the fields was not mapped.
    • Fixed: You may run into "ORA-01722: invalid number" error in Premium ADO NET Destination component when bulk insert numeric data into Oralce database using ODP.NET Unmanaged data provider.
    • Fixed: You may get error "ORA-00972: identifier is too long" in Premium ADO NET Destination component when performing bulk insert action with lookup configured.
  • Premium File Pack
    • New: Premium Flat File source component now supports using variable as the source.
    • New: We added a new SSH Tunnel (Proxy Jump) proxy type support in the SFTP Connection Manager.
    • New: We added Server Type option support in SFTP Connection Manager, which can be used to specify the target OS type.
    • New: SFTP Connection Manager now supports specifying Transfer Type option.
    • New: We added a new SSH Tunnel (Proxy Jump) proxy type support in FTPS Connection Manager.
    • New: We added a new File Overwrite Mode option in Premium File Transfer Task when performing Send Files action.
    • Update: Duplicate Mode in Premium File System Destination has now been renamed to Overwrite Mode. This should be considered a breaking change.
    • Fixed: Premium File Transfer Task may report "The item already exists" error even though the file does not actually exist under the target folder when transferring files to local file system.
    • Fixed: Premium File System Destination component may report a "Cannot create a file when that file already exists" error when performing the Move action with Overwrite duplicate handling mode.
    • Fixed: Premium Flat File Source component may not output data correctly when working with Fixed Width file with a Skipped Rows value specified.
  • REST Services
    • [General] New: You can now use SSIS variables in Boolean/Integer/Enum type Filter Parameter in REST Source component.
    • Azure Application Insights
      • Fixed: Query object in Azure Application Insights Source component may not load the metadata properly.
    • Azure Tables
      • New: We have added a new Output as Raw JSON support in Azure Tables REST Source component.
      • New: We have added a new Write as Raw JSON support in Azure Tables REST Destination component 
    • Elasticsearch
      • New: We added Manage Fields support in Elasticsearch REST Source and Destination components, which can be used to manually define that a field is an array type.
      • Enhancement: Elasticsearch REST Source component now supports sending "_source_includes" or "_source_excludes" properties dynamically based on field selections.
    • Facebook Business
      • Enhancement: Better error message in Facebook Business REST Source component when "Use Page Token" enabled but a page_id is not specified.
      • Update: We updated the default API Version to v12.0.
      • Fixed: Pagination may not work properly when reading from Insights Result object.
    • Facebook Messenger
      • Update: We updated default API Version to v12.0. 
    • Magento
      • New: We added Magento Query Language support in Premium Service Lookup component by utilizing Magento API searchCriteria query parameter.
      • Enhancement: Better custom fields detection.
    • MailChimp
      • Enhancement: Better MailChimp metadata detection for the raw object fields.
      • Fixed: MailChimp REST Source and Destination components may report a 426 Unknown "UpgradeRequired" error when trying to retrieve metadata from the service.
    • Microsoft Teams
      • New: We added Impersonation Id (App Acts As) support in Microsoft Teams REST Source and Destination components when the connection manager uses Client Credential authentication mode.
      • Fixed: Create or Replace Schedule action in Microsoft Teams Destination component may not work properly.
    • Salesforce Pardot
      •  New: We added Bulk Export support for Visitor Activity, List Membership, Prospect, Prospect Account, and Visitor in Salesforce Pardot REST Source component.
    • ServiceNow
      •  New: ServiceNow REST Destination component now supports detecting data policy rules and surfaces optional writable fields in metadata.
    • Shopify
      • Enhancement: We have some updated metadata for Order object and Transaction Object.
    • Stripe
      • New: We added Stripe-Version header support when sending API requests to Stripe.
      • Enhancement: Updated metadata.
    • SurveyMonkey
      • Enhancement: Updated Survey, Survey Response and Survey Questions objects metadata.
    • Xero
      • Enhancement: Updated Journals object metadata.
      • Fixed: Pagination in Xero REST Source component may not work properly with Journals object in Account API.
    • Zuora
      • New: Zuora REST Source component no longer fails on 50000040 Not Found reason code.
      • Fixed: Pagination in Zuora REST Source component may not work properly with Order object when a filter parameter is specified.

Version 21.1 - May 28, 2021

This release comes with the following updates and enhancements:

  • New Components
    • Big Data
      • CDM Source
      • CDM Destination
    • Data Quality
      • Address Parser
    • Premium Data Flow Components
      • Premium Service Lookup - this is a data flow component that provides lookup capabilities against all supported ADO.NET connections and a number of cloud applications such as Microsoft Dynamics 365, HubSpot,NetSuite, and most of our REST connections.
    • Testing and Simulation
      • Dummy Destination Component
  • New services in the REST framework
    • Active Campaign
    • Dynamics 365 Customer Insights
    • Microsoft To Do
    • Sendinblue
    • SendGrid
    • Snapchat Business
    • SuiteCRM
    • TikTok Business
    • YouTube Analytics
    • Zoho Desk
  • General
    • New: We now ship a new console version of KingswaySoft License Manager program which is designed to work more reliably in a container environment.
    • New: KingswaySoft License Manager program now always uses a secure service endpoint for activation and deactivation requests.
    • Enhancement: Some more high-DPI support improvements.
    • Enhancement: We added support for TLS 1.3 for those HTTP based connections.
  • Big Data
    • New: We have added three new EDI format support in EDI source/destination component.
      • HL7 - you can now work with health data within SSIS pipeline
      • NCPDP Script
      • NCPDP Telco
    • Update: In supporting the above new formats, we have introduced a new version of EDI assemblies. In order for the new version to work with existing packages, you will need to re-download those EDI assemblies utilized in the data flow.
    • Enhancement: EDI components are now equipped with some better output detection when option "Flatten Segment Loops" is enabled.
  • Cloud Storage
    • New: We added a new "Download Chunk Size" option in the Amazon S3 Connection Manager.
    • New: We added a new "Download Chunk Size" option in the Azure Data Lake Storage Connection Manager for ADLS Gen2 connections.
    • New: We added a new "Download Chunk Size" option in the Azure Files Connection Manager.
    • New: Azure Blob Storage Connection Manager now supports a new SAS Token authentication mode so that you can specify a SAS URL for connection purpose.
    • New: We added Share and Unshare actions support to Box destination component, which can be used to grant or revoke file access permissions.
    • Fixed: You might receive an error indicating "Either 'folder' or 'file' must be provided, but not both" in Premium File Transfer Task when transferring OneDrive files between different folders while the "Preserver Timestamp" option is enabled.
    • Fixed: Renaming an OneDrive file using Premium File Properties Task may not work properly.
  • Data Quality and Comparison
    • Fixed: Diff Detector component may report "The value being written to DT_TEXT or DT_NTEXT column is not a string or an array of bytes" when working with DT_TEXT or DT_NTEXT column.
    • Fixed: "Object reference not set to an instance of an object" error when "Treat Empty String as NULL" option is enabled in Duplicate Detector and there are null values in the input.
  • Data Warehousing
    • New: We added OAuth 2 and JWT authentication modes support in Snowflake Connection Manager.
    • New: Snowflake destination component now supports outputting Bulk Copy information to log during the runtime.
    • New: You can now use SSIS variables in the Pre & Post commands in Snowflake source/destination component.
    • New: We added an "Encoding" property support in PostgreSQL Connection Manager.
    • Enhancement: Significant performance improvement when performing Bulk Copy action with large data loads in Snowflake destination component.
    • Enhancement: Significant performance improvement when bulk uploading large data loads in Redshift destination component.
    • Enhancement: PostgreSQL destination component has some significant performance improvements when auto mapping a large number of columns at design time.
    • Fixed: Test connection in PostgreSQL Connection Manager may still report "SSL connection is required" error while SslMode has been specified.
    • Fixed: You may run into "System.NullReferenceException" when running multiple Snowflake destination components in parallel.
    • Fixed: Command Timeout setting in Snowflake Source/Destination component may not work properly.
  • Encryption and Compression Tasks
    • New: We added two new actions in PGP Task.
      • Encrypt And Sign
      • Verify Encrypted and Signed File
    • New: Output Detailed Information support in PGP Task.
    • Fixed: You may receive an "exception decrypting secret key" error when decrypting a PGP-encrytped file while the private key file contains multiple keys.
  • Google Services
    • New: We have added support for Google Ads API in Google Ads Connection Manager.
  • HTTP/Web Services
    • New: We added Bearer Token authentication mode support in HTTP Connection Manager.
    • New: We added support of Azure OAuth authentication mode in HTTP Connection Manager, which supports client credential and certificate OAuth types to authenticate to Azure services.
    • New: We added a new Google Service Account authentication mode support in HTTP Connection Manager.
    • Update: HTTP Requester Task component now uses separate properties to store Query String Parameters and Request Headers. This change should be considered as a breaking change, as a prior versions (v20.2.1 or earlier) would not be able to open or process an SSIS package saved by the new version.
  • JSON & XML Processing
    • Enhancement: JSON/XML Source/Destination/Merge/Extract component now tries to detect encoding automatically upon file import.
    • Fixed: You may receive a "String was not recognized as a valid DateTime" when working with Microsoft JSON datetime format (format like "/Date(1224043200000)/") in JSON Source/Extract component.
    • Fixed: XML Source/Extract may not output the repeated element values correctly when there are empty tag values like <{NodeName}/> involved. 
  • Mail Components
    • New: We added OAuth2 authentication support for Exchange Web Service protocol in Email Connection Manager.
    • Fixed: In some rare situations, you may receive an error indicating "The specification of a mailbox with the public folder root is invalid" when testing connection in Email Connection Manager while using Exchange Web Service protocol.
  • Message Queue Components
    • New: We added a new "Retry on Intermittent Errors" option in IBM MQ Connection Manager, which can be used to retry upon intermittent connection failure errors.
    • New: We added a "Peek then Delete" option to RabbitMQ source component, which can be used to ensure the message retrieval reliability when using Receive and Delete receive mode.
    • New: We added some new regions support in Amazon SQS Connection Manager.
    • Fixed: RabbitMQ destination component might report a "Value cannot appear as table value" error when writing to custom datetime or GUID data type fields.
  • NoSQL Components
    • New: Amazon DynamoDB source component now supports reading from Global Secondary Index.
    • New: We added some new regions support in Amazon DynamoDB Connection Manager.
    • Enhancement: MongoDB source component now reports a better error message when the specified database or collection does not exist.
    • Update: Max Degree of Parallelism now defaults to 1 in CosmosDB destination component.
    • Fixed: Refreshing Amazon DynamoDB source/destination component resets the object to the first object in the list.
  • Premium Data Flow Components
    • New: Premium Derived Column component now includes support for the following new functions:
      • RaiseError()
      • GetItemAtPositionInString()
      • GetItemCountInStringArray()
      • ShowMessageBox()
    • New: Premium Derived Column component now supports renaming a column by modifying the output alias through Advanced Editor.
    • New: We added AutoFit Column Width support in Premium Excel destination component.
    • New: We have added "SharePoint" service implementation in Premium OData Connection Manager, which is used for OData service implementations that closely follow the Microsoft SharePoint documentation.
    • New: You can now use SSIS variables in the OData Query Builder in Premium OData source component.
    • New: Premium OData source component now supports performing bound actions towards a collection of entities.
    • New: You can now use SSIS variables in the Pre & Post commands in Premium ADO.NET source/destination component.
    • New: Premium ADO.NET destination component now supports batch insert action for all the connections.
    • New: Premium ADO.NET destination component now validates that at least one input column is mapped for Delete action.
    • New: We added a "CombineAll" table combining strategy in Premium PDF source component
    • Enhancement: Some performance enhancement when loading Preview in Premium ADO.NET source component.
    • Update: The maximum batch size value in Premium OData source component is updated to 1,000,000.
    • Fixed: Premium OData source/destination component may "The attribute 'ConcurrencyMode' was not expected in the given context" error when retrieving metadata for a Dynamics NAV/Business Central on-premises connection.
    • Fixed: You may receive an "ORA-00933: SQL command not properly ended" error when loading Preview in Premium ADO NET source component through an Oracle Provider for OLEDB connection.
    • Fixed: "Format String" option in Premium Excel destination component was applied to the entire column, while it should only be applied to the written cells.
    • Fixed: You may get error "An item with the same key has already been added" when there are duplicate column names specified in Premium Excel Destination component.
  • Premium File Pack
    • New: We added a "Skip Writing On No Row" option in Premium Flat File destination component, which can be used to skip creating the empty file when there are no input rows.
    • New: Premium Flat File destination component now supports a new Append to file option.
    • Fixed: Premium Flat File source component may not read complete data from DT_NEXT or DT_TEXT type field for large data columns (>10,000 length).
    • Fixed: Premium File System source component may report “The process cannot access the file because it is being used by another process” error when reading fileContent or fileSize properties in some special situations.
  • REST Services
    • [General]: REST Source component no longer fails on 404 Not Found error.
    • ADP
      • New: We added "asOfDate" filter parameter support for Workers service endpoint in ADP REST source component.
      • Fixed: ADP REST source component may not output any rows when reading from Time Off > Time Off Requests service endpoint.
    • Azure Tables
      • Fixed: Azure Tables REST destination component failed whole batch when the first record in the batch failed.
    • Eventbrite
      • Update: We have removed 'event.description' field but added 'event.summary' field to Event object in Eventbrite REST component.
    • Facebook Business
      • New: Added Ad Insights breakdown fields metadata to Facebook Business REST source component.
    • Infusionsoft
      • Update: Infusionsoft service has been renamed to Keap/Infusionsoft to respect the vendor's recent branding changes.
    • Jira
      • New: Jira REST Connection Manager now supports Basic authentication mode.
    • LinkedIn Business
      • Update: We have adapted the LinkedIn query tunneling feature so that reading requests are now using the POST HTTP method.
    •   Magento
      • New: You can now call a writing action endpoint (PUT and POST endpoints) in Magento REST source component.
      • Update: Now store code specified in Magento REST Connection Manager is applied to every request.
    • Microsoft Teams
      • Fixed: Microsoft Teams REST source component may not retrieve channels records properly.
    • Salesforce Pardot
      • New: We added Pardot v3 API support.
      • Update: We have removed Pardot API authentication mode support from Salesforce Pardot REST Connection Manager as Pardot’s user authentication system has been discontinued.
      • Fixed: Missing output rows when reading from “Get specific Prospect by Email” endpoint in Salesforce Pardot REST source component.
    • ServiceNow
      • Fixed: In some rare situations, you may run into “The requested query is too long to build the response pagination header URLs” error when reading from ServiceNow REST source component.
    • Shopify
      • Fixed: Pagination in Shopify REST source component worked improperly with Payouts and Transactions objects.
    • Smartsheet
      • New: Smartsheet REST destination now supports auto-detect input data type when writing to Smartsheet Text/Number columns for discovered sheet objects.
    • Square
      • New: Instance Type support in Square REST Connection Manager.
      • Update: Updated metadata to latest API version.
    • Xero
      • Enhancement: Updated Journal and Reports objects metadata for Accounting API.
      • Fixed: “String was not recognized as a valid DateTime” error when reading Xero datetime values.
    • Zoom
      • Update: Zoom REST source component no longer fails on 404 Not Found error.
    • Zuora
      • New: We added support for Query source type in Zuora REST source component.
      • New: We added “List all records” endpoint support to many Zuora objects in Zuora REST source component.
      • Update: Zuora REST source component no longer fails on 404 Not Found error.
      • Update: Zuora REST component now list custom object with a suffix of “(Custom Object)” if the custom object name is conflict with system object.
  •   Template Merge Components
    • New: HTML source component now supports using variable as the source.

For other releases click on the respective year:
2023 - 2022 - 2020 - 2019 - 2018 - 2017 - 2016