SSIS PowerPack 5.4.0 Released

Version 5.4.0.10208 [Feb 28, 2024]

New Features/Improvements

  • NEW: API Connector - SharePoint - Modify get_main_site uses endpoint to use SiteId parameter so Test connection doesn't fail due to default root site usage
  • NEW: API Connector - Azure DevOps - Add new endpoints get_queries and get_workitems_by_query_id to fetch result from predefined query by its id
  • NEW: API Connector - ElasticSearch - Add Anonymous / Windows Authentication (No UserId/ Password)
  • NEW: API Connector - FastSpring - New connector to read / write data in FastSpring (Accounts, Orders, OrderItems, Products, Subscriptions, Quotes and more)
  • NEW: API Connector - Google BigQuery - Add Project and Dataset dropdown for easy selection on connection screen
  • NEW: API Connector - Power BI - New connector to read / write Power BI Datasets, Query using DAX
  • NEW: API Connector - Shopify - Add Insert, Update and Delete operations for Product, ProductVariant
  • NEW: API Connector - Shopify - Add new tables Locations, InventoryItems, InventoryLevels, Payouts
  • NEW: API Connector - Shopify - Allow Product Add, Update, Delete
  • NEW: API Connector - Shopify - By default include all orders (rather than just Open orders) to show POS orders
  • NEW: API Connector - Zendesk - Added API call delay property NextUrlWaitInMs to avoid error 429 (too many requests) during Pagination
  • NEW: API Connector - Zendesk - Added CRUD operations (Insert, Update, Delete and Upsert) for Users and Organizations table. For Users table you can do Upsert in Bulk mode
  • NEW: API Connector - Zendesk - Change Domain Label to Sub Domain to avoid confusion
  • NEW: API Connector - Zoho SalesIQ - New connector to read data from Zoho Chat System (SalesIQ) - Read Chats, Operators, Feedbacks, Reports and more
  • NEW: API Connector Framework - Add an option CacheClearFor to trigger cache invalidation for specific endpoints when this endpoint is called
  • NEW: API Connector Framework - Allow <Column Name="my_array_name[].id" along with DotAsPath to produce SingleDataset input (e.g. nested Array as input without using LayoutMap)
  • NEW: API Connector Framework - Allow row column values in ValueTemplate for Input/Output Columns (i.e. Calculated Column Scenario) - Example <Column Name="Display" ValueTemplate="<<[$parent.first$] [$parent.last$],FUN_TRIM>>" ... >
  • NEW: API Connectors - Zendesk - Allow bulk update for Users / Organization table
  • NEW: Export XML / JSON Task - Update notes on replacement rules so its clear how encode value is applied after custom replacement rules are invoked
  • NEW: General - Improve license validation speed, add Subscription Id in UI
  • NEW: General - Stop redirect when Connector UI displays Help URL
  • NEW: Google Analytics Connection Manager - Add option for PKCE Code Verifier in Auth / Token requests
  • NEW: OAuth Connection Manager - Add option to pass PKCE Code Verifier (RFC 7636) for extra security
  • NEW: Salesforce Connection Manager - Add option for support PKCE Code Verifier in Auth / Token requests

Bug fixes

  • FIX: Add support to add new fields in MongoDB, Azure, DynamoDB records
  • FIX: Advanced File System Task - Allow/show Flat File connection option in Connection drop down
  • FIX: API Connector - Shopify - Product and ProductVariant table shows wrong datatypes
  • FIX: API Connector Framework - Allow brackets and other special character as column name for [$parent.column_name$] placeholder
  • FIX: API Connector Framework - AllowParamBindForLayoutMap and MultiSelectTemplate doesn't work with ValueTemplate
  • FIX: API Connector Framework - Endpoint flagged as AllowParamBindForLayoutMap=true not visible in EndPoint list on UI
  • FIX: API Connector Framework - Larger than 64MB file upload hangs (or timeout) - SharePoint, OneDrive, Google Drive Connector upload issue
  • FIX: API Connector Framework - Multiple Template Usage can cause issue if you do not set EndPoint Properties in first Template
  • FIX: API Connector Framework - ValueTemplate invokes DirectPlaceholder function in wrong order (i.e. its called before {$value$} and [$param$] )
  • FIX: INTERNAL-GetRenewKeyForSub is called due to expired key sitting in license folder
  • FIX: MongoDB Source - COMExceptions not logged with actual message
  • FIX: REST API Task, JSON, XML, CSV Source, Web API Destination - POST request with 301 redirect + authorization doesnt work well (Body is not added back after redirect)
  • FIX: Salesforce Source - Metadata detection may fails in some cases when you have Subquery
  • FIX: Template Transform - Date Format with escape sequence (') not allowed e.g. <%mydatecolumn, yyyy-MM-dd HH:mm:ss G'M'Tzzzz%>