Key New Features

• Introducing new SAP S/4HANA Cloud Snap Pack.
• Added OAuth2 Account support for Coupa.
• Added on-premises support 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.

New Snaps

Enhancements

• Azure Active Directory:
  Note: Microsoft is deprecating its Azure Active Directory Graph APIs in the near future and migrating to Microsoft Graph APIs. Hence, SnapLogic has migrated from Azure AD Graph APIs to Microsoft Graph APIs for the Azure Active Directory Snaps.
  Warning: Breaking Change:

  • If you have any existing Pipelines that use the accounts authenticated with the old URL (OAuth2), then you must update them using the new URLs (v2.0) for calling APIs and modify the existing accounts to use the Microsoft Graph APIs.
    • OAuth2 Endpoint: https://login.microsoftonline.com/2060aafa-89d9-423d-9514-eac46338ec05/oauth2/v2.0/authorize
    • OAuth2 Token: https://login.microsoftonline.com/2060aafa-89d9-423d-9514-eac46338ec05/oauth2/v2.0/token
  • If you have not configured Scope in the Auth endpoint config field set in your existing accounts, then you must set the default Scope as https://graph.microsoft.com/.default offline_access in the field set, else the Snap fails.

  Learn more about Azure Active Directory OAuth2 account.

• Azure SQL:
  • Enhanced the Azure SQL Account and Azure SQL Active Directory Account with the Disable connection pooling checkbox that allows you to manage session states sharing.
• Binary:
  • Enhanced the File Writer Snap with the Prevent URL encoding checkbox to manage the URL encoding.
  • Enhanced the following Snaps and Accounts that use SnapLogic File System (SLFS) to display Lint warnings in Pipelines when using incorrect file paths to read and write files. We recommend that you use the File Upload icon () to specify the file path.
    • File Writer
    • File Reader
    • File Delete
    • HDFS Reader
    • HDFS Writer
    • HDFS ZipFile Reader
    • HDFS ZipFile Writer
    • S3 File Writer
    • S3 File Reader
    • ORC Reader
    • ORC Writer
    • ZipFile Read
    • ZipFile Write
    • Google Service Account
    • Two-Factor Auth Account
• Box:
  • Enhanced the Box Write Snap with the Write empty file checkbox that allows you to write an empty file when the incoming binary document has empty data.
• Coupa:
  • Added a new account type Coupa OAuth2 that enables OAuth2 authentication for all Coupa Snaps.
  • Enhanced the Coupa Create and Coupa Update Snaps with the minimum number of output views to zero.
  Warning: The Coupa Account will be deprecated after 4.29 GA, as Coupa will discontinue the support of the API-based authentication in their upcoming September 2022 Release (R34). We recommend that you migrate your existing Pipelines configured with Coupa Account to Coupa OAuth2 Account immediately. Learn more: Coupa API Keys Deprecation
• Google Sheets:
  • Enhanced the Spreadsheets Browser, Worksheet Reader, and Worksheet Writer Snaps with the Include Shared Drives checkbox to support working with the Google Shared Drives.
  • Enhanced the Worksheet Reader and Worksheet Writer Snaps with the Display Spreadsheet ID in Suggestions checkbox. You can select this checkbox to display both spreadsheet ID and the spreadsheet name in the suggestions. This helps you to choose among the spreadsheets having the same name.
  • Enhanced the Worksheet Writer Snap with the Write Mode dropdown list to perform the desired write option for the given worksheet—that is 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.
  • Enhanced the Spreadsheets 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.
• Hadoop:
  • Added the AWS S3 Dynamic account for the 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.
• JDBC:
  • Enhanced the Generic Database Account in the JDBC Snap pack to include Netsuite as an option for the Database name field to connect to the NetSuite database. While configuring the account, if you select Netsuite or Autodetect (if the Snap detects the target database as NetSuite) then the Limit rows field in the Generic JDBC - Select is ignored.
• 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 Snaps through NTLM authentication.
  • Updates in the Dynamics 365 for Sales Create and 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 Snap encounters 401 or 403 errors, this account generates a new token after refreshing the cache.
• Slack:
  • Enhanced the Send Message Snap with User Emails option for the Target Type dropdown list to send messages on the 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 optimizes AWS account configuration by skipping account validation if the S3 Storage Integration field value is 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 Formatter Snap with the Output Character Set field. You can 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 to be compatible with version 37.0).
  • Enhanced the Workday Cancel Snap with Number of Retries and Retry Interval (seconds) fields to support the retry mechanism.

Changes in Behavior

• The CSV Formatter Snap now allows an empty value for the Escape Character field if no escape character is used in the input CSV data. Earlier, this Snap used a \ (forward slash) in the input when the Escape Character field was left empty causing an invalid data error.
• The expected output for the MongoDB - Update Snap is modified due to the upgrade of the Spring Core framework version and the matchedDocuments definition is introduced.
  • Earlier, updateOfExisting would be true if matchedDocuments was greater than 0.
  • Now, updateOfExisting is true if updatedDocuments is greater than 0.
• The Snowflake - Execute and Snowflake - Select Snaps now write the output value as-is for FLOAT or DOUBLE datatype columns if these columns have the value as NaN (Not a Number). Earlier, the Snaps displayed an exception error when the FLOAT or DOUBLE datatype column has the value as NaN. This behavior is not backward compatible.
• The Salesforce Subscriber Snap now stops and reports the error immediately when it encounters the daily limit exceeded error. Earlier, Snap reported an error and stopped only at the next resubscribe attempt when it encountered the daily limit exceeded error.
• The Dynamics 365 For Sales Update and Dynamics 365 for Sales Upsert Snaps now write the error to the error view and do not write to the output view when the Snaps encountered an error.

Known Issues

• Worksheet Reader: When you provide a spreadsheet ID to fetch data, and if a spreadsheet with that ID already exists as a spreadsheet name, the Snap fails to fetch the data, instead it fetches the data of the spreadsheet whose name matches with the spreadsheet ID.
  Tip: If you want to fetch the data of the specified spreadsheet ID, ensure that you specify the spreadsheet name of that spreadsheet ID or both (spreadsheet name with spreadsheet ID).
• Worksheet Writer: When you provide a spreadsheet ID to append or insert data, and if a spreadsheet with the same ID already exists as the spreadsheet name, the Snap fails to append or insert the data for the specified spreadsheet ID and creates a new worksheet for the spreadsheet name
  Tip: Ensure that you specify a unique spreadsheet name or spreadsheet name with spreadsheet ID.

Deprecated

• The Twitter, Facebook, Foursquare Snap Packs are deprecated and are no longer available. Contact support@snaplogic.com, if your existing Pipelines use Snaps from the deprecated Snap Pack.
• The Coupa Account will be deprecated after 4.29 GA, as Coupa will discontinue the support of the API-based authentication in their upcoming September 2022 Release (R34).

Dot Releases