Page Comparison

In this article

...

• Added SAP S/4HANA Cloud Snap Pack.

• Added OAuth2 Account support for Coupa.

• Added on-premise support Dynamics 365 NLTM Account type for Microsoft Dynamics 365 For Sales and a new Dynamics 365 NTML Account type for this Snap Pack.

• Added REST In-memory OAuth2 Account type for REST Snap Pack.

...

...

...

• Google Sheets:

  • Enhanced the Spreadsheets Browser, Worksheet Reader, and Worksheet Writer Snaps with the Include Shared Drives checkbox.

  • Enhanced the Spreadsheet Browser Snap with the Fetch Mode dropdown list to fetch the spreadsheets and worksheets. You can either fetch spreadsheets and worksheets within the specified Spreadsheet or only spreadsheets.

  • Enhanced the Worksheet Reader and Worksheet Writer Snaps with the Display Spreadsheet ID in Suggestions checkbox.

  • Enhanced the Worksheet Writer Snap with the Write Mode dropdown list to perform the desired write option for the given worksheet. You can either create a new worksheet or append or edit an existing worksheet. You can write new data to the worksheet by specifying a cell reference as the starting point or append data to the worksheet at the last row in the worksheet containing content.

• Hadoop:

  • Added the AWS S3 Dynamic account for Parquet Reader and Parquet Writer Snaps.

  • Enhanced the AWS S3 Account for Hadoop account to include the S3 Region field that allows cross-region or proxied cross-region access to S3 buckets in the Parquet Reader and Parquet Writer Snaps.

• Kafka: Kafka Snap Pack now supports Azure Event Hubs streaming service. Learn more: Azure Event Hubs configuration in Azure portal for Kafka SSL Account.

• MS Dynamics 365 for Sales:

  MS Dynamics 365 For Sales Snaps now supports on-premise installations of MS Dynamics 365.

  • Added a new account type Dynamics 365 NTLM Account that enables to connect to MS Dynamics 365 for Sales Snaps through NTLM authentication.

  • Updates in the MS Dynamics 365 for Sales Create and MS Dynamics 365 for Sales Upsert Snaps:

    • Improved performance by streamlining the process of creating new entities.

    • Fixed an issue where the Content-Length header was incorrectly set when Unicode characters were present in the request.

• OpenAPI:

  • Enhanced the Base URL field in the OpenAPI Snap to support suggestions associated with OpenAPI Specifications.

  • Added Dynamic OAuth2 account that enables OAuth authentication for OpenAPI Snap.

• REST:

  • Added the REST In-memory OAuth2 Account type with Client Credentials Grant Type that supports and stores the access token in memory for reuse until it expires. When the Snap encounters 401 or 403 errors, this account generates a new token after refreshing the cache.

• Slack:

  • Enhanced the Slack - Send Message Snap with User Emails option for the Target Type dropdown list to send messages on Slack app using the user’s email.

• Snowflake

  • Updated the Snowflake - Bulk Upsert Snap for the following:

    • The Snap displayed an incorrect resolution when the length of the value exceeded the value defined in a column.

    • The Snap failed with a NullPointer Exception when no value was provided for Error Limit field and Error percentage limit fields.

    • The Snap displayed an incorrect error message when S3 details were not provided.

    • Added the On Error dropdown list, where you can select an action to perform when the Snap encounters errors in a file.

  • The following enhancements were done for the Snowflake - Bulk Load Snap:

    • The Snap skips AWS account validation if S3 Storage Integration property is provided.

    • The Snap skips the validate command if S3 Storage Integration property is not provided

    • The Snap overrides the storage integration specified in the account settings with the storage integration specified in the Snap settings.

  • Enhanced the Snowflake - Unload Snap to skip AWS account validation if S3 Storage Integration property is provided.

• SQL Server:

  • Enhanced the SQL Server - Bulk Load Snap with the Batch Size field to process records in a batch.

  • Enhanced the SQL Server - Select and SQL Server - Lookup Snaps with Option for Unique Identifier Column that allows you to convert the case to lower or upper while displaying the Unique Identifier output (display) value.

• Teradata:

  • Enhanced the Teradata FastExport Snap with Character Set dropdown list to support encoding of data when you export data from the Teradata database.

• Transform:

  • Fixed an issue with CSV Formatter and CSV Generator Snaps that displayed an incorrect error when one or more header values in the CSV file were missing. This error is now routed to the error view.

  • Fixed an issue with the CSV Parser Snap, where the Snap stopped indefinitely while processing certain inputs.

  • Fixed an issue with the CSV Formatter Snap, where the escape character selected was not used.

  • Updated the CSV library used in the CSV Generator, CSV Parser, and CSV Formatter Snaps. This library update enforces values for each column in a parsed CSV header.

  • Enhanced the XML FormatterSnap with theOutput Character Setfield. Specify or select the character set you want for your binary output. For example, UTF-8 or ISO860.

• Workday:

  • This Snap Pack supports the latest version of Workday APIs (certified up to be compatible with version 37.0).

  • Enhanced the Workday Cancel Snap with Number of Retries and Retry Interval (seconds) fields to support retry mechanism.

...

The Twitter, Facebook, Foursquare Snap Packs are deprecated and are no longer availabledue to no customer usage. Contact support@snaplogic.com, if your existing Pipelines use Snaps from the deprecated Snap Pack.

...

• Introduced a new Snap ELT Router to enable routing input SQL queries into multiple output views based on the given conditional expressions.

• Introduced ELT Cast Function Snap to convert a data type of a column in the input SQL string into other supported data types.

• Introduced ELT String Function Snap to support the various string functions supported by the different databases Snowflake, Redshift, and Azure Synapse.

...