ODBC PowerPack 2.2.1 Released

Announcements ODBC PowerPack
1

Version 2.2.1.10308 [Mar 03, 2026]

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

New Features/Improvements

  • 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 - 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 Token Generation UI, added non-blocking flow, and enhanced process scanning performance

Bug fixes

  • 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 - 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 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