Version 5.8.0.11008 [Oct 16, 2025]
To view full release notes (including previous versions): click here
New Features/Improvements
- NEW: API Connector - Azure DevOps - Added new columns Severity, ProposedFix, Symptom, RootCause, HowFound, FoundInEnvironment, BusinessValue, ValueArea, TestedBy, TestPriority, Activity
- NEW: API Connector - Azure DevOps - Added new field ResolvedBy for WorkItem operations (SELECT/UPDATE/INSERT) and added three new params (BypassRules, SuppressNotifications, ValidateOnly)
- NEW: API Connector - Azure DevOps - Changed datatypes for Description, Steps, ReproSteps, SystemInfo and History columns to DT_NTEXT to handle more than 4000 chars (helps in some ETL tools like SSIS)
- NEW: API Connector - AzureDevOps - Added support for ParentId column and Expand Parameter (To get ParentId, you must set Expand Parameters=Relations)
- NEW: API Connector - Gmail - New connector to read / download mail and attachments from Gmail email account
- NEW: API Connector - JIRA - Added a new endpoint get_worklogs_after to fetch worklogs entries modified after a specified date/time
- NEW: API Connector - Outlook Mail - Add a new endpoint download_messages to download all messages as *.EML file for specififed search criteria / user mailbox / folder
- NEW: API Connector - Outlook Mail - Added a new endpoint delete_message to delete message by MessageId
- NEW: API Connector - Outlook Mail - Added a new endpoint delete_messages_by_search to delete multiple messages (bulk operation) by User / Folder / Search conditions
- NEW: API Connector - Outlook Mail - Added new endpoints get_groups and get_group to read Group data
- NEW: API Connector Framework - Provide Check All / Uncheck All option for Multi-Select dropdowns for parameter selection UI
- NEW: API Source, API Destination - Added support for many new Parameters in generic_request endpoint (e.g. SaveContentAsBinary - Which enables Save binary response to file)
- NEW: API Source, API Destination - Added support for ResponseFormat (CSV / XML) to support CSV and XML Parser
- NEW: AuthorizeInFullBrowser=True put in <Auth ConnectionString=xxxx here
- NEW: Download File Task - Some servers may reject download request due to missing User-Agent request
- NEW: Dummy Data Source - Add support for variables and placeholder functions in sample data values (e.g. {{User::MyValue}} or <<c:\temp\dummy.png,FUN_FILE_BASE64ENC>> )
- NEW: Dummy Data Source - Support sample data in bas64 format (byte array) for DT_IMAGE and DT_BYTES columns
- NEW: General - Add new placeholder function FUN_INVOKE_MULTI to call multiple functions in sequence using previous function output as input
- NEW: General - Added new string functions FUN_LEN, FUN_LEFT, FUN_RIGHT, FUN_PADCHARS
- NEW: General - Enhanced Tls1.3 capability with modern encryption ciphers and security standards
- NEW: HTML Table Source - Add New Property DoNotFailWhenTableNotFound - By default component fails at runtime if Table not found (search by Number, XPath or CSS)
- NEW: HTML Table Source - Add Support for reading from <DIV> or <CUSTOM> tag based Tables
- NEW: HTML Table Source - Change Default Length to 500 (was 255 which was too short for some)
- NEW: HTML Table Source - Give option to include extra columns with custom XPath from anywhere in HTML Table along with primary table rows
- NEW: HTML Table Source - Support Wild Card Pattern in local file path (e.g. c:\files\invoice_*.htm)
- NEW: JSON / XML / CSV Source, Parser Transform - Allow Base64 string for DT_BYTES column to be treated as Byte Array
- NEW: Logging Task - Allow variable placeholders in Log File Path
- NEW: MongoDB Source - New options for Aggregate Query (SSIS 2019 or Higher) - BypassDocumentValidation, Comment and Hint in JSON Style Query (e.g. {Table:MyTable, Hint:'YearCol=1;MonthCol=-1' , Comment:'Some Query Label' } {..some native query..}
- NEW: MongoDB Source - New Options for Find / Distinct Query (SSIS 2019 or Higher) - Timeout, Comment, Hint, AllowDiskUse, CursorType=NonTailable|Tailable|TailableAwait, NoCursorTimeout, AllowPartialResults - (e.g. {Table:MyTable, options...} {your query}
- NEW: Upsert Destination - Error message doesnt report column name for data truncation related errors (used to work in older version)
- NEW: Upsert Destination - For errors related to SqlDateTime overflow - Improve messages to Include Column and Row Details
- NEW: Upsert Destination - Provide column name for data conversion / truncation error with buffer row number by scanning full buffer rather than just checking first row
Bug fixes
- FIX: API Connection Manager - Auth ConnStr was applied wrong way on Auth UI load
- FIX: API Connection Manager - Changing Auth doesnt refresh Inner connection details (e.g. Password / Client Id) causing failure on dropdown select (e.g. Azure DevOps - OAuth to PAT change and select Project dropdown fails)
- FIX: API Connector - JIRA - You may get error Remote server returned 401 Gone. This is due to CHANGE-2046 (/search endpoint deprecated, now use /search/jql)
- FIX: API Connector - Outlook Mail - Clicking on MailFolderId parameter may throw error 400 bad request (due to /users/users twice in the URL)
- FIX: API Connector - SmartSheet - Table list shows only 100 sheets (stopped working after recent SmartSheet API changes related to totalCount attribute)
- FIX: API Destination - Some endpoints like download_attachment may not be invoked if Destination is not attached due to usage of ValueTemplate with functions like FUN_FILE_WRITE
- FIX: API Source, API Destination - generic_request EndPoint doesnt work for CSV/XML formats (i.e. when ResponseFormat parameter is set no effect)
- FIX: Export JSON / XML Task - Map Item with function is not treated as string and rendered as raw fragment
- FIX: HTML Email Task - Preview may not render fine in some CSS/Styles
- FIX: HTML Email Task - Provide an option to use inline style for themed tables rather than using <style> tag and css class (helps with clients like Outlook which strips <style> tag)
- FIX: HTML Table Source - Using Path C:/myfile.htm //myshare/file.htm rather than C:\myfile.htm OR \\share\file.htm throws error - Table not found for specified criteria
- FIX: JSON / XML / CSV Source - Disable duplicate warning for each page in paginated URL - Streaming mode is disabled because you enabled pagination option
- FIX: JSON / XML / CSV Source - Shorten Exception message prefix so actual column causing error is visible
- FIX: MongoDB Connection Manager - You may get error - MongoServer.Create has already created 100 servers which is the maximum number of servers allowed (Need to call MongoServer.UnregisterServer on Dispose)
- FIX: OAuth Connection Manager - CacheToken option may not work correctly in Multi-threads (Calls multiple token calls in some cases)
- FIX: SMTP Connection Manager - You may get session timeout error in somecases