Key New Features in SnapLogic

Platform:

New Public API endpoints to facilitate integration with your CI/CD tools:
- Create new Project Spaces and Projects to run your tests.
- Manage Permissions in specific Orgs as you promote Pipelines and Assets.
- List Git status of Assets.

API Management:

Expand your API ecosystem to manage, secure, and control third-party and public APIs through the API Management solution.
Secure external APIs with policies for security, traffic management, and more.

Developer Portal:

Improved application development time by testing and sampling custom APIs within the Developer Portal using the “Try it out” feature in the API documentation page.

Snaps and Accounts:

Added Azure Service Bus Snap Pack.
Added Exact Online Snap Pack.
Added Active Directory Remove Member Snap.
Added SharePoint Online - Get Sites Snap.
Added OAuth2 Account support for ServiceNow Snap Pack.
Added OAuth2 Account support for SuccessFactors Snap Pack.
Added OAuth2 Account support for Snowflake Snap Pack.Snowflake Snap Pack.

ELT for Cloud Data Platforms:

Subquery Pushdown Optimization.
Added new ELT Snaps: ELT Coalesce, ELT Conditional Function, ELT Math Function, and ELT SQL Case Expression.
Support for loading data from S3 and Redshift source locations to BigQuery target tables.

SnapLogic Flows:

Added Webhook support for Salesforce and HubSpot.
Added two new endpoints: HubSpot and Jira (source).
Added Auto Data Type Conversion.

Flows is available to you free with your current SnapLogic subscription, but only for a limited time. To get started, register for Flows.

4.28 UAT Delta

This section tracks the changes made during the iterative pushes to the UAT server and the GA release. The following is the release schedule:

UAT 1: Friday, Feb 4, 2022 – Snaplex version: 4.28_rc-11090 - 4.28 RC (Recommended)
GA: Saturday, Feb 12, 2022 – Snaplex version: main-11177 - 4.28 GA (Recommended)

The SnapLogic GA release build on the production server is also deployed on the UAT server.

Important

Per the SnapLogic Release Process, all remaining Snaplex instances across Orgs are auto-upgraded to the recommended version (main-11177 - 4.28 GA) at 9 p.m. PT on Saturday, Mar 19, 2022. Orgs migrated to the 4.28 GA version prior to the auto-upgrade are not impacted.
The Snaplex upgrade process also upgrades the Java version to the latest version. After the upgrade, the Java version of your Cloudplex nodes may not be the same as your FeedMaster nodes. However, this does not impact the operations of your SnapLogic instance. We will be fixing this issue in a subsequent release.
To use the new SnapLogic features and Snaps in the 4.28 release, ensure that your Snaplex nodes are upgraded to the main-11177 - 4.28 GA (Recommended) version.
This 4.28 release includes the patches deployed to SnapLogic after the 4.27 release, as listed in the 4.27 Dot Releases section.

4.28 Dot Releases

SnapLogic Studio

Date of Update	Update

Date of Update	Update
Mar 31, 2022	Removed Last Execution and Last Status in the Execution Overview to improve performance.

Snaps

Use Microsoft Dynamics 365 for Sales Snap Pack in lieu of Microsoft Dynamics CRM Snap Pack

As Microsoft has deprecated its following offerings, the Dynamics CRM Snaps configured with the Dynamics 365 Account For Online or Dynamics 365 Dynamic Account For Online fail with a Ws-Trust authentication error.

The Microsoft Dynamics CRM Snap Pack (CRM) will be deprecated in the upcoming August, 4.30 SnapLogic release after the on-premise support is added in the Microsoft Dynamics 365 for Sales Snap Pack. If you are using the Dynamics 365 Online Accounts for Dynamics CRM Pipelines, we recommend that you immediately update these Pipelines and Accounts with Microsoft Dynamics 365 for Sales that uses the REST-based API (Web API) recommended by Microsoft.

Before you begin your migration, contact your Customer Success Manager (CSM) or SnapLogic Support to subscribe to Microsoft Dynamics 365 for Sales Snap Pack.

Snap Pack	Date of Update	Snap Pack Version	Updates

Snap Pack	Date of Update	Snap Pack Version	Updates
ELT	Apr 20, 2022	428patches15638	Fixed the issue with ELT Merge Into Snap where the Snap erroneously modified the target table column name when it contained the target table name, due to a misinterpretation of the target table name aliases.
Snowflake	Apr 12, 2022	428patches15236	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. On Error: Use this field to select an action to perform when the Snap encounters error in a file. The available actions are: - ABORT_STATEMENT: Aborts the upsert action and displays an error. - CONTINUE: Continues loading the file. The error is displayed in the output document. - SKIP_FILE: Skips upserting the files that contain errors. - SKIP_FILE_error_limit: Skips file when the number of errors in the file exceeds the number specified in the Error Limit field. - *SKIP_FILE_error_percent_limit%: Skips file when the percentage of errors in the file exceeds the percentage specified in the Error Percentage Limit* field. Default value: ABORT_STATEMENT Example: SKIP_FILE Removed the Username field in the following accounts to allow reusing of accounts among different users: Snowflake Azure OAuth2 Account Snowflake S3 OAuth2 Account Snowflake Google Storage OAuth2 Account The following enhancements were done for 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.
Google BigQuery	Apr 12, 2022	428patches15459	Fixed an issue with Google BigQuery Execute Snap, where the Snap displayed `404 Job not found` error when calling a procedure. Fixed an issue with the Google BigQuery Bulk Load (Cloud Storage) Snap where the Snap failed, because the access token expired when it had to wait longer to execute. With this fix, the Snap is reloaded to get refreshed access token.
MySQL	Apr 12, 2022	428patches15101	Fixed an issue with SQL Server - Execute Snap where the Pipeline was failing when there were consecutive execute Snaps with a procedure call, followed by select statements.
SharePoint Online	Apr 6, 2022	428patches (main101)	Fixed the Auto Refresh Token issue in the SharePoint Online Account.
REST	Mar 28, 2022	428patches15172	Fixed an issue that caused REST SSL accounts to fail when the username in the REST SSL Account was null and the Enhanced Encryption level was low, medium, or high.
SQL Server	Mar 25, 2022	428patches14649	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. Option for Unique Identifier Column: This field is applicable only when the Snap returns the unique identifier (GUID) in the output. The unique identifier is stored in the database using an internal format and when it is displayed in the output, it is converted to a string and gets displayed in upper case for HEX characters. Select either of the following options to change the case type. Available options are: - Convert to lower case: Modifies the output string to lower case. - Convert to upper case: Modifies the output string to upper case. Default Value: Convert to lower case Example: Convert to upper case
JWT	Mar 24, 2022	428patches15200	Enhanced the JWT Generate Snap to include the `typ` field in the JWT Header of the JWT token. `{` `"alg": "HS256",` `"typ": "JWT"` `}`
ELT	Mar 24, 2022	428patches15290	Updated ELT SCD2 Snap to address different feature requests and issues raised by multiple customers. These changes provide more flexibility in configuring your SCD2 operations using this Snap. Removed Check for nulls and duplicates in source field and added two dropdown lists - Null Value Behavior and Invalid Row Handling. Refer to the ELT SCD2 scenarios to learn more. Introduced a new Snap ELT Router to enable routing input SQL queries into multiple output views based on the given conditional expressions.
Google Sheets	Mar 24, 2022	428patches14755	Enhanced the Spreadsheet Browser Snap with the Fetch Mode dropdown list to fetch the spreadsheets and worksheets. The Fetch Mode list has the following options: - Spreadsheets and Worksheets: Fetches Spreadsheets and Worksheets within the Spreadsheet. - Spreadsheets: Fetches only the Spreadsheets. Default Value: Spreadsheets and Worksheets Example: Spreadsheets
Email	Mar 24, 2022	428patches14812	Fixed an issue with the Email Sender Snap where SMB files were attached to an e-mail causing the Snaps to fail with a `NullPointer Exception`.
MS Dynamics 365 for Sales	Mar 23, 2022	428patches15219	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.
Hadoop	Mar 23, 2022	428patches15216	Added the AWS S3 Dynamic account for Parquet Reader and Parquet Writer Snaps.
Flow	Mar 22, 2022	428patches15026	Fixed an issue with HTTP Router Snap where the Snap did not work as intended for a GET request that used a Cloud URL when the HTTP Router was the first Snap in the triggered task Pipeline.
Azure SQL	Mar 22, 2022	428patches15164	Fixed an issue with the Azure SQL - Update Snap where the Snap failed with an `Incorrect syntax error` when a column in a table is of NVARCHAR, NCHAR, or NTEXT data type and this column is part of another NVARCHAR, NCHAR, or NTEXT data type column name and the update condition is specified as an expression.
Binary	Mar 17, 2022	428patches14919	Fixed an issue with the Directory Browser Snap where the Snap failed while parsing the value in the Amazon S3 client region. Enhanced the File Writer Snap with the Prevent URL encoding checkbox to manage the URL encoding. - Select this checkbox to prevent the encoding of the file path URL automatically. This allows the Snap to use the file path value as-is. - Deselect this checkbox to automatically encode the characters in the File URL. Fixed an issue with the ZipFile Write Snap where the Snap displayed a null pointer exception when the path in the upstream File Reader Snap started with "../". Fixed an issue in the Binary Snaps (that support SMB file protocol), which displayed an SMB Mount error when trying to connect to Mount Share. Fixed an issue with the File Writer Snap where the Snap did not display an error when an error occurred while writing a file.
Azure SQL	Mar 16, 2022	428patches15114	Fixed an issue with the Azure SQL - Bulk Load Snap where the decimal values lost precision when they were inserted into the database.
Amazon SQS	Mar 10, 2022	428patches14774	Fixed an issue in the SQS Consumer Snap where the Snap took longer time to process the messages when the Client-side buffering checkbox was selected.
Binary	Mar 10, 2022	428patches14736	Fixed an issue in the File Writer, S3 File Writer, and ZipFile Write Snaps where the Snaps failed with `AccessControlListNotSupported` error when using an external AWS account to write to the bucket if it has the `bucket-owner-enforced` setting enabled. With this fix, you can select the None option (the default value), from the AWS Canned ACL dropdown list, indicating that no Canned ACL request is set when writing a new file to prevent the error.
Workday	Mar 4, 2022	428patches14290	Enhanced the Workday Cancel Snap with retry mechanism fields. Number of Retries: The number of attempts the Snap should make to perform the selected operation in case of connection failure or timeout. Retry Interval (seconds): The time interval in seconds between retry attempts.
Kafka	Feb 28, 2022	428patches14904	Fixed an issue with Kafka Snaps where the Snaps failed with null pointer exceptions when logging the cluster information with the controller’s identity not known.
Transform	Feb 25, 2022	428patches14370	Fixed an issue with the XML Generator Snap, where the Snap failed with an invalid `UTF-8 sequence` error when running on the Windows Snaplex.
Splunk	Feb 24, 2022	428patches14332	Upgraded the Splunk library to version 1.6.5.0 to fix an issue with the Splunk Search Snap, where the Snap displayed a `401 Unauthorized access` error despite entering valid credentials.
SalesForce	Feb 24, 2022	428patches14355	Fixed an issue with Salesforce Snaps where the Service Version could not be retrieved from SFDC due to a blocked URL, failing the Snap execution.
Google BigQuery	Feb 23, 2022	428patches14743	Fixed an issue with the Google BigQuery Execute Snap, where the Snap displayed an error when the input data contained a table having the record type column and its value was null. Fixed an issue with the Google BigQuery Write Snap, when the input data contained complex data type columns (such as nested fields) and Create table if not present checkbox was selected.

Platform

As previously announced, SnapLogic has ceased support for Windows Server 2012 on Jan 1, 2022, since this version did not support strong ciphers. Ensure that you upgrade your Groundplex instances to Windows 2016 or 2019.

On Sunday, May 8, 2022 at 9 p.m. PT, we are updating the TLS certificates for the SnapLogic Platform servers (UAT and Elastic). No action is required by customers. Learn more: Updating TLS (SSL) Certificates for SnapLogic

SnapLogic TLS/SSL Digital Certificate Update: We updated the SSL/TLS certificates for the SnapLogic Platform servers (UAT and Elastic) at 9 p.m. PT on Tuesday, May 3, 2022, since the previous certificates were expiring. Customers who need to manually update their trust store to trust the new certificate must do so immediately. Learn more: Updating TLS (SSL) Certificates for SnapLogic

New Features

New and enhanced Public APIs for improved integration with CI/CD tools
- The following new public APIs are now available:
  - POST /assetapi/acl/{project_path} – Grants a user or group access to the specified project.
  - GET /assetapi/acl/{project_path} – Retrieves the privileges of the current user to access the specified project.
  - DELETE /assetapi/acl/{project_path} – Revokes all project access from a user or group.
  - POST /project/{projpath} – Creates a new project or project space.
  - PUT /project/{projpath} – Renames an existing project or project space.
  - GET /repo-status/{projpath} – Determines the status of a project’s GitHub repository.
  - GET /migrate/{status_token} – Determines the status of a migration.
- The following public APIs were modified:
  - GET /activities/{org} has a new optional query parameter: filter_snaplogic_admin_update.

Enhancements

Updated the Snaplex installer to use JRE 11.0.12+7 instead of 11.0.10+9. We have committed to upgrade the version twice a year as part of security compliance. New Groundplex installations will use this version, and Cloudplex installations will get upgraded as part of the version upgrade. Existing Groundplex installations will continue on the current version until the RPM/DEB is manually reinstalled.

Fixed Issues

Fixed the issue in ServiceNow Snaps where Number of Retries was showing empty or blank values.
Fixed 404 errors when selecting 8 Hours or 24 Hours in the Dashboard under the Health tab.
Fixed the missing default value for Skip lines in the CSV Parser Snap settings dialog.

Known Issues

When creating new Projects using the Public API (POST /project/{projpath}), the checkout Public API (POST /project/checkout/{project_path}) is currently unable to create the initial link between the Project and the repository, and the checkout will fail. As a workaround, check out using the UI. Target fix version: 4.28 patch in March.
When committing files to GitHub from SnapLogic, some subdirectories might be inadvertently deleted from the repository, including GitHub Actions workflows in the .github directory. Target fix version: 4.28 patch in March.

February 2022, 4.28 Release Notes