SSIS PowerPack 5.4.0 released

Posted on by
Contents hide
1 Introduction
2 New Features/Improvements
3 Bug fixes

Introduction

This release brings tons of new features and bug fixes. We have added new connectors for FastSpring, Power BI, Zoho SalesIQ and new endpoints for Azure DevOps. It fixes important issues with connectors for Shopify, MongoDB Source, REST API Task, JSON, XML, CSV Source, Web API Destination, and API Connector Framework. To see full release notes click here

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%>
Posted in Announcements.