SSIS PowerPack 5.0.1 released

Introduction

This was a minor update release. It fixes important issues with All Components and API Connector. To see full release notes click here

New Features/Improvements

  • NEW: API Connector – Zendesk – Show all custom fields when you query Tickets (Previous approach was limited to 5 fields only)
  • NEW: API Connector – Zendesk – Update Read Tickets (Incremental) endpoint to support functions in Start Time Parameter. Now you can use date time function (i.e. yesterday, monthstart etc) along with static date (i.e. 2021-01-01 or 2021-01-01 23:59:59) to set
  • NEW: API Framework – Allow placeholders in ValueTemplate property for Columns with Dynamic Expand option set to true
  • NEW: Salesforce Connection Manager – Provide an option to supply API Version for Bulk / SOAP API (Right now BULK API version is hardcoded and no way to change, SOAP also same way but work around is there to change Service Type=Other)
  • NEW: Salesforce Connection Manager – Update API Version to 55.0 for SOAP and Bulk API to take advantage of new features

Bug fixes

  • FIX: All Components – Mapping file export does not encode special characters like “&” which cause issue with import same file throwing error – An error occurred while parsing EntityName. Line XX, position YY.
  • FIX: API Connector – Stripe – Update endpoints to for date time as input / output rather than Unix timestamp
  • FIX: API Connector Framework – Some properties like Functions, ValueTemplate, Order, Label etc doesnt work in Param Template
Posted in Announcements.