April 2023 Release Notes

What's New? 🚀

Features

• Databricks now enables the use of custom locations for storing target tables in 2 modes:

  • The default Databricks File System location for a Databricks workspace (DBFS), which was already supported.
  • In the new and second mode, tables are stored in an external location within the path of {externallocation}/{schema}/{table}.

  

• Action Rivers now support pagination by page for REST Action via request body.
  To enable this feature, create a "page_value" variable in the Variables tab, select the "Paginate By Page" option under Results -> Data, and check the "Update the value of the next page into a page_value variable in every page iteration" box.

  

Sources Updates:

• Hubspot - we have expanded the list of reports by adding 6 new Search reports.
  These reports cover Contacts, Companies, Deals, Line Items, Products, and Tickets.
  

• SuccessFactors now offers 13 additional API endpoints that are linked to the Foundation, Employment Information, Compensation Information, and Personal Information APIs. Additionally, the configuration of Primary Keys has been implemented across all 27 supported endpoints.

  

• AppsFlyer - We have added support for Appsflyer v2 tokens to our system. As per Appsflyer's announcement, v1 token support will be discontinued by the end of April 2023. To accommodate this change, we have updated the authentication method and report URLs.

• The Trade Desk - We have refactored the filtering capabilities of our reports to improve performance and stability.
  The changes made are as follows:
  Campaigns

  • Supported filters: Advertisers
  • Deprecated filters: Partners

  Ad groups

  • Supported filters: Campaigns, Advertisers
  • Deprecated filters: Partners

  Creatives

  • Supported filters: Advertisers
  • Deprecated filters: Partners, Campaigns and Ad Groups

  DMP

  • Supported filters: Advertisers
  • Deprecated filters: Partners

  Audience

  • Supported filters: Advertisers
  • Deprecated filters: Partners

  Audience information

  • Deprecated filters: Partners, Advertisers

  Existing Template

  • Supported filters: Partners, Advertisers, Ad Groups

• SFTP - Our SFTP connector underwent maintenance to enhance its performance and stability. As part of this process, we improved the capabilities of incremental loading and post-pulling operations.

• Facebook Marketing API - We have updated our Facebook Marketing API version from V14 to the latest version, V16.

Kits ⭐

The Bulk River Retry Kit enables you to schedule retries for Rivers that had failed previously in a specific Environment. This kit utilizes the Rivery API and the Rivery Activities API to keep a track of River activities in the Environment and to retry any executions that have failed.

Resolved Issues 🔎

Sources

• Hubspot - Fixed an Issue that was causing null values to be displayed in the "Companies" report when the "Modified Companies" checkbox was selected.

• Zendesk - We updated the "Keep Raw Custom Fields" checkbox to extract custom fields' raw data like when flattening it.
  When selected, raw data is pushed to a raw_custom_fields column without appending field names. So, "Ticket Subcategory - Trust & Safety - Car" is now pushed as-is, not as "Ticket_Subcategory___Trust___Safety___Car".

• Oracle - We have resolved an issue when using the Arabic language in Oracle Rivers.

Rivers

• Logic Rivers - Fixed an issue where the UI displayed the Multi Valued variable's Array without brackets after configuring and saving it.