NEW: All Drivers - Allow to parse Unix Epoch Timestamp value for DateTime column
NEW: All Drivers - Provide an option to limit log files by days (Add Two new properties - LogRollingMode (Size and Days) and MaxLogFiles (Used if Rolling by Days)
NEW: API Connector - ElasticSearch - Added FailIf attribute for usecase like SSIS when INSERT / UPDATE output not consumed and record update/insert fails which needs to be reported as error. Previously it was silent about the error
NEW: API Connector - ElasticSearch - Added support alias in Metadata query
NEW: API Connector - ElasticSearch - Added support for date, bool, int, long, double, float types (Previous version didn't detect datatypes)
NEW: API Connector - ElasticSearch - Added support for dynamic metadata (See MetaDetectionOrder property under Advanced Parameters - Set to Dynamic)
NEW: API Connector - ElasticSearch - Added support for Mixed DateTime with Unix Epoch Timestamp for date type
NEW: API Connector - ElasticSearch - Added support for read geo_shape and geo_point
NEW: API Connector - JIRA - Added Insert/Update/Delete operation for Comment Table
NEW: API Connector - JIRA - Added new tables Groups, ApplicationRoles
NEW: API Connector - Jira - Added read/write support for Team field type (Value listed in customfield_NNN_id and customfield_NNN_name fields)
NEW: API Connector - JIRA - Bulk Write to Issues doesnt work for more than 50 rows
NEW: API Connector - JIRA - Performance improvement for Comments Table Read Operation
NEW: API Connector - OData - Added new properties for OAuth Credentials (DoNotIncludeCredentialsInHeader, DoNotIncludeCredentialsInBody, RenewBeforeSec, ExtraHeaders, ContentType, EnableCodeVerifier, CustomAuthHeader, CustomTokenPrefix and RemoveAuthHeader)
NEW: API Connector - OneDrive - Added an option to list files / folders Shared With Me (new SearchType option)
NEW: API Connector - OneDrive - Added an option to select See Shared DriveId (Dropdown on UI) along with User DriverId (me) in list_files / list_folder and many other endpoints
NEW: API Connector - OneDrive - Added ConvertTo option to download_file endpoint to convert supported files to PDF or HTML format
NEW: API Connector - OneDrive - Added new endpoint copy_item to copy file or folder
NEW: API Connector - OneDrive - Added new endpoint list_files for recursive scan and using OrderBy field for list operation
NEW: API Connector - OneDrive - Added new endpoint move_rename_item to move or rename file or folder
NEW: API Connector - OneDrive - Allow File/Folder ID or Path in most endpoints
NEW: API Connector - OneDrive - Allow Lookup Operation (By ID Param) in Files Table (e.g. SELECT * FROM Files WHERE Id='Abxxx12')
NEW: API Connector - ServiceNow - Added two new options (Query and Fields) in get_table_rows
NEW: API Connector - SharePoint - Added a Default Drive Id parameter at connection level, Updated Auth SiteId Param to have extra option entry
NEW: API Connector - SharePoint - Added a UseRawCache option in get_list_fields to avoid duplicate API calls and fetch Columns metadata faster
NEW: API Connector - SharePoint - Added Insert / Update option for Multi Select Choice Field (Previously not possible)
NEW: API Connector - SharePoint / OneDrive - Added a new option (ConflictBehavior) in upload_file endpoint to replace/rename if target file exists
NEW: API Connector - SharePoint / OneDrive - Added new connection level parameters ExtraHeaders and SearchOptionForNonIndexedFields
NEW: API Connector - SharePoint / OneDrive - Added new parameters OrderBy, SearchType and SearchPath for list_files, list_folders, list_excel_files
NEW: API Connector - SharePoint / OneDrive - Added support for Read/Write CSV and JSON Files (New Tables FileReaderWriterJson, FileReaderWriterCsv)
NEW: API Connector - SharePoint / OneDrive - Use Id rather than Name for SheetId parameter in get_excel_worksheet and get_excel_worksheet_autodetect endpoints
NEW: API Connector - SharePoint Online - Added new endpoint copy_item to copy file or folder
NEW: API Connector - SharePoint Online - Added new endpoint move_rename_item to move or rename file or folder
NEW: API Connector - SharePoint Online, OneDrive - Added webUrlPath column in many endpoints, which list Files and folders. This path included a relative path after /Documents/ part in webUrl
NEW: API Connector - SharePoint Online, OneDrive - Sorted Files and Folders in Dropdown selection on UI
NEW: API Connector - Zoho CRM - Throwing `401 Unauthorized - invalid oauth token` error during Large Data Retrieval After OAuth Token Expiry after almost 1hour
NEW: API Connector Framework - Added Item count label for Dropdowns
NEW: API Connector Framework - Added new Auth attribute DefaultServiceUrl (Scenario like Jira OAuth Auth selection should set default Service URL on UI)
NEW: API Connector Framework - Added new EndPoint Property CustomOutputColumns and CustomInputColumns to set Dynamic Metadata without calling API call (useful for generic_request_write Input /Output Mapping)
NEW: API Connector Framework - Added new FailIfExpression property and new FailIF mode ExpressionFound for EndPoint (Use DataTable Expression only used when FailIf=ExpressionFound)
NEW: API Connector Framework - Added new Param Property AllowDuplicateHeader to allow same Header name as Key for Header Type parameter
NEW: API Connector Framework - Added new property InvokeOrder to control which parameters with ValueTemplate replaced first (SharePoint, OneDrive list_file sharedWithMe usecase)
NEW: API Connector Framework - Added new property OptionsEndPointContinueOnError to continue on error if one or more endpoints fails during Union operation (Multi endpoints scenario in OptionsEndPoint)
NEW: API Connector Framework - Added new property WriterDateTimeFormat to set DateTime value format for CSV, XML, JSON document for {$rows$} placeholder
NEW: API Connector Framework - Added Param Setting OptionsEndPointDistinct to UNION multiple results and apply distinct on it
NEW: API Connector Framework - Added support for Prefix "*" in EndPoint FailIfExpression - Prefixing expression cause to scan array records instead of scanning root level (e.g. "*P_error=true" will not cause double scan)
NEW: API Connector Framework - Allow QuotesAroundValue, HasColumnHeaderRow, RowDelimiter Params for When EndPoint set to RequestFormat=Csv (Previous these values were hard coded)
NEW: API Connector Framework - Allow to use parameters in ValueTemplate which invokes nested ValueTemplate
NEW: API Connector Framework - Exposed a new Property DoNotIndentArray to control Indent of Array Attributes (ElasticSearch usecase)
NEW: API Connector Framework - JIRA - Add two extra columns for each Custom User Type Field (customfield_NNN_accountId and customfield_NNN_email)
NEW: API Connector Framework - Shopify - Add support for get_products_count and get_orders_count endpoints
NEW: API Connector Framework - Shopify - Add support for X-Shopify-Api-Features header
NEW: API Connector Framework - Show checked Items in Green color in Multi Select Option Parameters on UI
NEW: API Connector Framework - String Column Length always defaults to 4000 when Expand is defined and ignores user defined Length attribute
NEW: API Driver - Add support for SQLCancel (Allow to cancel Long Running Command - e.g. stop execution for long paginated response from API)
NEW: API Driver - Added a new table __DynamicRequest__ to support BULK Write scenario from External System (e.g. INSERT INTO... SOURCE( external system )
NEW: API Driver - By default expose DT_IMAGE / DT_BYTES columns as DT_NTEXT (Unless some convert Base64 to Byte Array option set)
NEW: Data Gateway - All Drivers - Allow Generate Script for SELECT / INSERT / UPDATE in SSMS for Linked Server
NEW: Data Gateway - Document IP Filter option (Provide option help link)
NEW: Data Gateway - Provide a dropdown to select SQL Server Version for Code Generation on App Integration Tab (It changes Provider code based on Version) - New version of MS SQL (i.e. SQL 22 or higher) doesnt work with SQLNCLI11
NEW: Data Gateway - Support for C# code generator and other enhancements
NEW: JDBC Bridge Driver - Updated "Disconnected host" error message with better explanation if its due to Port being used by other processes
NEW: JSON / XML / CSV Driver - Add support for SQLCancel (Allow to cancel Long Running Command - e.g. stop execution for long paginated response from API)
Bug fixes
FIX: All Drivers - Driver UI Header image (Right side) crops if you resize
FIX: API Connector - Amazon Selling Partner (SP-API) - Download file to local disk operation may corrupt the target file rather than overwrite Save to File operation corrupts the target file rather than overwrite completely
FIX: API Connector - Asana - Download file to local disk operation may corrupt the target file rather than overwrite Save to File operation corrupts the target file rather than overwrite completely
FIX: API Connector - Dropbox - Download file to local disk operation may corrupt the target file rather than overwrite Save to File operation corrupts the target file rather than overwrite completely
FIX: API Connector - ElasticSearch - Fixed datatype issue with Insert/Update operation. Now you can update geo_point, geo_shape, nested and object type field as raw JSON (e.g. SET [tags]='["tag1", "tag2"]' ..) or by field path [my_object.field_1]=123 )
FIX: API Connector - Google BigQuery - You may get error 413 Request Entity Too Large in insertAll API call
FIX: API Connector - Google Drive - Download file to local disk operation may corrupt the target file rather than overwrite Save to File operation corrupts the target file rather than overwrite completely
FIX: API Connector - Google Sheets - Download file to local disk operation may corrupt the target file rather than overwrite Save to File operation corrupts the target file rather than overwrite completely
FIX: API Connector - Hubspot - ClientId and Client Secret should be Required If UseCustomApp=True
FIX: API Connector - JIRA - Comments table may not return more than 50 comments per each Issue
FIX: API Connector - JIRA - CustomColumnsRegex is not working correctly
FIX: API Connector - JIRA - Issues / Users tables return one less row due to pagination issue
FIX: API Connector - JIRA - Projects pagination not working (Max 50 projects returned)
FIX: API Connector - OneDrive - Download file to local disk operation may corrupt the target file rather than overwrite Save to File operation corrupts the target file rather than overwrite completely
FIX: API Connector - OneDrive - Folder selection dropdown takes really long time in some cases when many files but less folders
FIX: API Connector - Outlook Mail - Download file to local disk operation may corrupt the target file rather than overwrite Save to File operation corrupts the target file rather than overwrite completely
FIX: API Connector - ServiceNow - Using Basic Auth throws error - Input string was not in a correct format
FIX: API Connector - Sharepoint - Download file to local disk operation may corrupt the target file rather than overwrite Save to File operation corrupts the target file rather than overwrite completely
FIX: API Connector - SharePoint Online - Folder selection dropdown takes really long time in some cases when many files but less folders
FIX: API Connector - SmartSheet - Download file to local disk operation may corrupt the target file rather than overwrite Save to File operation corrupts the target file rather than overwrite completely
FIX: API Connector - SmartSheet - Write operation may fail in app like SSIS if API Target Error Output not attached downstream
FIX: API Connector - Zoho CRM - Token is not renewed in some cases (e.g. SA region) causing Not Authorized error (Specially long running Jobs)
FIX: API Connector Framework - Bool Property Param with blank value may throw error - Object of type 'System.String' cannot be converted to type 'System.Boolean'.
FIX: API Connector Framework - CSV LayoutMap with * (All) generates extra column named "*" in the file
FIX: API Connector Framework - OptionsEndPoint with multiple endpoints may add OptionsExtra for each EndPoint causing duplicate entries in dropdown
FIX: API Connector Framework - Param PropertyScope doesnt honor BatchSize and MaxRequestSize
FIX: API Connector Framework - RequestFormat CSV does not quote values in generated document for {$rows$} because all types detected as Object rather than String, Int, etc
FIX: API Connector Framework - VisibleIf always returns true in some cases (When Parameters in Expression not supplied as override value and default is used)
FIX: API Connector Framework - You may get error - Object reference not set to an instance of an object for some UI dropdown parameter selection where you have defined OptionsEndPointValueColumncolumn and not set OptionsEndPointLabelColumn
FIX: API Driver - Negative sign cause issue with UPDATE Statement
FIX: Data Gateway - API Driver - When DT_IMAGE, DT_BYTES type used - You may get error - Unable to cast object of type 'System.String' to type 'System.Byte[]'
FIX: Data Gateway - Binary Types (DT_BYTES, DT_IMAGE) may not work well in some cases (Padded extra zeros)
FIX: Data Gateway - Document Enable TLS Setting option
FIX: Data Gateway - DT_STR, DT_NUMERIC, DT_TEXT Datatypes not supported (Usecase - ServiceNow Connector in API Driver)
FIX: Data Gateway - Microsoft ODBC Driver v17 or v18 for SQL Server - Fails to connect to gateway - Communication link failure
FIX: Data Gateway - Table Listing in SSMS - Linked Servers - may not work for SQL Server 2022
FIX: General - JavaBridge.Properties file log option hangs UI and runtime (creates *.lck files)
FIX: JDBC Bridge Driver - Prepare call is invoked for each row in Bulk Insert
FIX: Salesforce Driver - SQL WHERE with date is not working