ODBC PowerPack 2.2.1 Released

Announcements ODBC PowerPack
1

Version 2.2.1.10308 [Mar 04, 2026]

To view full release notes (including previous versions): click here

Download Latest Version

New Features/Improvements

  • NEW: All API Drivers - OAuth Connection - Fixed misleading error when token response is blank but status code is 204
  • NEW: All Drivers - Examples Tab now supports HTML formatted description
  • NEW: All Drivers - Provide a property to do custom SQL text replace for bad values generated by some client UI Tools (e.g. MS Access sending 0/1 for Bool when Salesforce needs True/False)
  • NEW: All JSON / XML / CSV Drivers - Show which value causing the issue and what line
  • NEW: API Connector - All - Improved connector descriptions
  • NEW: API Connector - Azure DevOps - Added support for On-Premises Azure DevOps Server
  • NEW: API Connector - Google Calendar - Added many new columns to list_events, create_event, and update_event endpoints
  • NEW: API Connector - Google Calendar - Added new columns (StartsOn, EndsOn, Location, Recurrence, etc.) to get_event and list_events endpoints
  • NEW: API Connector - Google Calendar - Added new parameter SendUpdates for create_event and update_event to send notifications
  • NEW: API Connector - Google Calendar - Added new parameters (Start Time, End Time, Show Deleted, etc.) to list_events endpoint
  • NEW: API Connector - Google Calendar - Added support for pagination in List Calendars endpoint
  • NEW: API Connector - Google Calendar - Added support for reading events from all calendars
  • NEW: API Connector - Google Calendar - Added support for supplying attendees, attachments, and reminders as raw arrays of emails
  • NEW: API Connector - Google Calendar - Added UserId parameter for list_calendar endpoint to support Service Account Authentication
  • NEW: API Connector - Google Search Console - Added support for the DimensionFilterGroups parameter in get_report
  • NEW: API Connector - OData - Added new endpoints get_metadata_tables and get_metadata_columns
  • NEW: API Connector - OneDrive - Allowed use of Target Folder Path rather than just Id in copy/move endpoints
  • NEW: API Connector - Outlook Mail - Added support for reading Excel attachments directly from Outlook Mail
  • NEW: API Connector - ServiceNow - Added new attachment-related endpoints for list, download, and upload operations
  • NEW: API Connector - ServiceNow - Added new endpoint get_record_labels to retrieve UI labels (tags) for parent table records
  • NEW: API Connector - ServiceNow - Added new endpoint get_table_row_count to get row counts for tables or filters
  • NEW: API Connector - ServiceNow - Added new option DateTimeValueHandling to treat DateTime as DateTime2
  • NEW: API Connector - ServiceNow - Added two new OAuth connection types (Client Credentials and User Credentials Grants)
  • NEW: API Connector - SharePoint Online - Added support for Update/Insert on Multi-Select LookupId and Person datatype fields
  • NEW: API Connector - SharePoint Online - Allowed use of Target Folder Path rather than just Id in copy/move endpoints
  • NEW: API Connector - Shopify - Added OAuth Authorization Code Grant (3-legged) authentication option
  • NEW: API Connector - Shopify - Changed default API version from 2023-01 to 2025-01
  • NEW: API Connector - Zoom - Added new endpoint list_meetings_all to show scheduled meetings for all users
  • NEW: API Connector - Zoom - Added new endpoint list_past_meetings_all to show past meetings for all users
  • NEW: API Connector Framework - Added new property OptionsEndPointErrorHelp to show custom error help in UI
  • NEW: API Connector Framework - Added new property TestParser for TestEndPoint to validate bad ServiceUrls
  • NEW: API Connector Framework - Added option ExpandContinueOnError to continue showing lists on expand failure
  • NEW: API Connector Framework - Added properties CustomErrorRegexPatterns and CustomErrorTexts for custom error handling
  • NEW: API Connector Framework - Added Property Param DateTimeValueHandling to treat datetime as DT_DBTIMESTAMP2 or DT_STR
  • NEW: API Connector Framework - Added RowFilter parameter to support advanced client-side filtering
  • NEW: API Connector Framework - Added Slug property for all API objects to allow persistent URLs
  • NEW: API Connector Framework - Added support for <Desc> Node with CDATA in all configuration nodes
  • NEW: API Driver - Add new Metadata Scan Options (e.g. RowsToScanForMetadata) for WITH clause or via Connection Settings for metadata request with dynamic output columns also remove unused option RowsToScanToGuessMeta
  • NEW: API Driver - Add support for Binary Types (return Byte array rather than Base64 encoded string for DT_IMAGE / DT_BYTES type)
  • NEW: API Driver - Added validation for API Service URL (users are now warned to choose from the dropdown if a custom URL is entered)
  • NEW: API Driver - Improved query performance by storing only the source columns referenced in Advanced SQL into temporary storage (You can control this behavior using the IncludeAllSrcColumnsInDb=0|1 hint in the WITH clause)
  • NEW: API Driver - Improved Token Generation UI, added non-blocking flow, and enhanced process scanning performance
  • NEW: API Driver - Improved Token Generation UI, added non-blocking flow, and enhanced process scanning performance
  • NEW: API Driver - Performance improvements when merge mode is used (META='@OverrideMode:1 ...')
  • NEW: Data Gateway - Provide options to throw valid error / treat datetime type as DateTime2 to deal with bad date values (Helps to avoid OPENQUERY issue - Error converting data type DBTYPE_DBTIMESTAMP to datetime)
  • NEW: Data Gateway - Update App Integration Code Generator to include Encrypt and TrustServerCertificate options in @provstr
  • NEW: General - Updated Installer / dlls to have minimum .net Framework 4.5.1 or Higher
  • NEW: JDBC Bridge - Change default port from 50433 to 41000 to avoid Docker/Hyper-V/WSL2 reserved port ranges
  • NEW: JSON / XML / CSV Driver - HTTP Connection - Exposed a new property StreamReadWriteTimeoutMs for long running API calls which may timeout at 10 minutes mark
  • NEW: JSON / XML / CSV Driver - Scan 3000 rather than 300 records by default for local files to guess datatypes - If source is URL then scan default (300) as before

Bug fixes

  • FIX: All API Drivers - You may get error: Option 'rowstoscanformetadata' is not supported - When you try to use this option in WITH clause
  • FIX: All Drivers - If datetime or numeric data is read as CHAR / WCHAR then on certain cases it may not send correct string (e.g. Numeric / DateTime issue with Non-US Environment - Issue with ToString ) (Alteryx Usecase)
  • FIX: All Drivers - Numeric Data might return as localized number when Caller app request as string type (e.g. CHAR) (Alteryx Usecase)
  • FIX: All Drivers - Scale may not be reported correctly for SQL_DESC_SCALE request (It was reported as 0) - (Alteryx Usecase)
  • FIX: All Drivers - Sometimes SQL_C.TIME / SQL_C.TYPE_TIME may produce bad or blank data
  • FIX: API / JSON / XML / CSV Driver - Added META attribute support for Byte/Blob datatype and direct SSIS types (DT_IMAGE, DT_BYTES) to enable binary data handling as byte arrays
  • FIX: API Connector - Google Calendar - [BREAKING] Switched to new ZappySys app when UseCustomApp=False (old app was blocked for many users)
  • FIX: API Connector - Google Calendar - Updated to use new default app (old app was blocked for many users)
  • FIX: API Connector - Jira - Added retry logic on error code 429 (Too many API requests)
  • FIX: API Connector - Jira - Fixed UpdatedAfter parameter for get_worklogs_after endpoint
  • FIX: API Connector - Jira - Resolved 400 Bad Request error when looking up Issues table by Id in WHERE clause
  • FIX: API Connector - OneDrive - Fixed issue where FileId selection showed wrong Id in builder
  • FIX: API Connector - Outlook Mail - Fixed issue where missing contentId caused malformed filenames in download_message_attachments
  • FIX: API Connector - ServiceNow - Added new option DateTimeValueHandling to treat DateTime as DateTime2
  • FIX: API Connector - ServiceNow - Automatically mapped large text fields to DT_NTEXT to prevent truncation
  • FIX: API Connector - ServiceNow - Fixed get_table_rows endpoint returning zero results due to incorrect parameter separator
  • FIX: API Connector - ServiceNow - Used system-defined length from metadata instead of fixed 2000 characters for string columns
  • FIX: API Connector - SharePoint Online - [BREAKING CHANGE] Defaulted to treating Input DateTime as UTC (previously treated as Local)
  • FIX: API Connector - SharePoint Online - Fixed issue where FileId selection showed wrong Id in builder
  • FIX: API Connector - SharePoint Online - Fixed numeric types with decimal points being detected as DT_I4 instead of DT_I8
  • FIX: API Connector - Shopify - Added OAuth Authorization Code Grant (3-legged) authentication option
  • FIX: API Connector Framework - Changed default DataEndPointWhere behavior to continue on errors; added ThrowOnError property
  • FIX: API Connector Framework - Fixed DT_DBDATE type incorrectly sending time parts causing server-side errors
  • FIX: API Connector Framework - Fixed MetaDetectionOrder Property with MergeStaticDynamic value not working
  • FIX: API Connector Framework - Fixed SaveContentAsBinary for MultiPart responses in download endpoints
  • FIX: API Connector Framework - Fixed typos in exposed properties (changed "Contine" to "Continue")
  • FIX: API Connector Framework - Resolved UI freezing/slow loading for dropdowns with many entries
  • FIX: API Driver - Added support for overriding meta for expression columns (e.g. select abs(col1) as mycol WITH(META='mycol:int') )
  • FIX: API Driver - Query Builder doesnt replace Placeholder functions on Preview when you entered in Parameter Grid (If you click OK and execute SQL then works fine)
  • FIX: API Driver - Some errors not reported properly - You see : One or more errors occurred
  • FIX: API Driver - Stop throwing error for INSERT - Sequence contains no matching element - When bad column or extra column entered - let it validate on server side rather than strict validation on client side
  • FIX: API Driver - Supplying Parameters dynamically in WITH clause (not defined in EndPoint) may not work for MetaDetectionOrder
  • FIX: API Driver - Using META with @OverrideMode:1 may cuase issue with complex SQL using Function with alias (You may get error - Column [some-column] is used in SELECT list but not defined in META)
  • FIX: API Driver - ValueTemplate not invoked when you use Merge Mode (Static+Dyanmic)
  • FIX: API Driver - WITH Clause overrides may not work well in some cases (e.g. PushToChildEndPoint attribute - Passing Parent EndPoint Param to Child EndPoint Param)
  • FIX: API Driver - You may get misleading error - Sequence contains no matching element - When no metadata returned (Google Sheet Use Case: When sheet is empty with just header)
  • FIX: API Driver, JDBC Bridge Driver - When you have GUID type - Apps like Power BI , Microsoft Fabric throws error - Driver does not support this parameter - on SQLGetInfoW SQL_DRIVER_NAME option
  • FIX: Data Gateway - Save UI not prompted for unsaved add user action
  • FIX: General - Added a new option (filter) in placeholder function FUN_HTTP_READ and FUN_HTTP_READ_BINARY
  • FIX: JDBC Bridge Driver - Added socket.timeout property in JdbcBridge.properties to configure socket timeout. Default is 0 (infinite) for long-running queries. Set a positive value (milliseconds) to enable timeout.
  • FIX: JDBC Bridge Driver - Databases like Redshift JDBC fails to generate SELECT with columns in Preview UI on table dropdown select
  • FIX: JDBC Bridge Driver - Provided Cancel Test connection option - It may hang in some cases so this cancel option helps
  • FIX: JDBC Bridge Driver - Show clear message which Java is installed as default runtime
  • FIX: JSON / XML / CSV Driver - Using META with @OverrideMode:1 may cuase issue with complex SQL using Function with alias (You may get error - Column [some-column] is used in SELECT list but not defined in META)
  • FIX: JSON Driver - Added support for overriding meta for expression columns (e.g. select abs(col1) as mycol WITH(META='mycol:int') )
  • FIX: Salesforce Driver - Stop throwing error for INSERT - Sequence contains no matching element - When bad column or extra column entered - let it validate on server side rather than strict validation on client side