In this article
Table of Contents | ||||
---|---|---|---|---|
|
Key New Features in SnapLogic
Platform:
New Public API endpoints to facilitate integration with your CI/CD tools:
...
In this article
Table of Contents | ||||
---|---|---|---|---|
|
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.
...
Expand |
---|
This section tracks the changes made during the iterative pushes to the UAT server and the GA release. The following is the release schedule:
The SnapLogic GA release build on the production server is also deployed on the UAT server. |
Info |
---|
Important
|
...
Date of Update | Update |
---|---|
| 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
...
. |
Snaps
Note |
---|
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 The Microsoft Dynamics CRM Snap Pack (CRM) will be deprecated in the upcoming August, 4.30 SnapLogic release, as it uses Microsoft’s SOAP-based API (Organization Service), which is deprecated. If your existing Pipelines contain the CRM Snaps configured with the Dynamics 365 Account For Online or Dynamics 365 Dynamic Account For Online, then the Snaps will fail with Before you begin your migration, contact your Customer Support Manager (CSM) or SnapLogic Support to subscribe to Microsoft Dynamics 365 for Sales Snaps that use REST-based API (Web API) recommended by Microsoft. Snap Pack. |
Snap Pack | Date of Update | Snap Pack Version | Updates | |||||
---|---|---|---|---|---|---|---|---|
| 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. | ||||||
| 428patches15236 |
| ||||||
| 428patches15459 |
| ||||||
| 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. | ||||||
| 428patches (main101) | Fixed the Auto Refresh Token issue in the SharePoint Online Account. | ||||||
| 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. | ||||||
| 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.
| ||||||
| 428patches15200 | Enhanced the JWT Generate Snap to include the
| ||||||
| 428patches15290 |
| ||||||
| 428patches14755 | Enhanced the Spreadsheet Browser Snap with the Fetch Mode dropdown list to fetch the spreadsheets and worksheets.
| ||||||
| 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 | ||||||
| 428patches15219 | Updates in the MS Dynamics 365 for Sales Create and MS Dynamics 365 for Sales Upsert Snaps:
| ||||||
| 428patches15216 | Added the AWS S3 Dynamic account for Parquet Reader and Parquet Writer for Parquet Reader and /wiki/spaces/SD/pages/1438227 Snaps. | ||||||
| 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. | ||||||
| 428patches15164 | Fixed an issue with the Azure SQL - Update Snap where the Snap failed with an | ||||||
| 428patches14919 |
| ||||||
| 428patches15114 | Fixed an issue with the Azure SQL - Bulk Load Snap where the decimal values lost precision when they were inserted into the database. | ||||||
| 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. | ||||||
| 428patches14736 | Fixed an issue in the File Writer, S3 File Writer, and ZipFile Write Snaps where the Snaps failed with | ||||||
| 428patches14290 | Enhanced the Workday Cancel Snap with retry mechanism fields.
| ||||||
| 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. | ||||||
| 428patches14370 | Fixed an issue with the XML Generator Snap, where the Snap failed with an invalid | ||||||
| 428patches14332 | Upgraded the Splunk library to version 1.6.5.0 to fix an issue with the Splunk SearchSearch Snap, where the Snap displayed a | ||||||
| 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. | ||||||
| 428patches14743 |
401 Unauthorized access error despite entering valid credentials. | ||||||
| 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. | ||||||
| 428patches14743 |
|
Platform
...
|
Platform
As previously announced, SnapLogic has ceased support for Windows Server 2012 on , since this version did not support strong ciphers. Ensure that you upgrade your Groundplex instances to Windows 2016 or 2019.
Info |
---|
On Sunday, 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 |
Info |
---|
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, , 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
.
...
Enhanced all the expression-enabled fields in ELT Snaps to display suggestions from the Input Schema (emanating from the upstream Snaps) in addition to the existing standard SQL expressions and functions list.
Enhanced the ELT Aggregate Snap to support:
HAVING clause within GROUP BY clause, when the WHERE clause cannot be used.
GROUP BY ROLLUP.
New aggregate functions for DLP: ANY, SOME, KURTOSIS, and STDDEV.
Enhanced the ELT Load Snap to support loading data into BigQuery targets from S3 buckets and Redshift CDW. These load operations use the BigQuery Data Transfer Service (DTS) client libraries and are carried out in asynchronous mode.
Enhanced the ELT Database Account to support these operations.
Enhanced the ELT Load and ELT Insert Select Snaps with a new fieldset Table Options List to support defining the Table Options for creating a new table in your target CDW.
Enhanced the ELT Select Snap to support Common Table Expression (CTE)-based SQL queries that contain a WITH clause inside the SQL Query Editor field, when your target CDW is Azure Synapse.
Known Issues
When using the ELT SCD2 Snap to load your source data into a Redshift target instance, the Snap fails if you use constant values such as ‘2022-01-01’ or SQL expressions such as GETDATE() and current_time() that evaluate to constant values instead of the target table column names in the Target Table Sort Fields.
[This issue is fixed in 428patches15290] When any of the functions in the ELT Math Function Snap encounters an infinity value—while converting the data type of double values to big decimal—the Snap fails during validation with the error
Character I is neither a decimal digit number, decimal point, nor "e" notation exponential mark
.
...
Added Webhook support for the Salesforce and HubSpot endpoints. Webhooks enable users to receive notifications (events) when they happen. You can configure events within the Salesforce or HubSpot endpoints and a notification will be sent to SnapLogic when the event occurs.
Added two object types for the Marketo endpoint: Get Lead by List Name and Get Campaign by Name.
Added two new endpoints:
HubSpot: The HubSpot endpoint connects to the CRM platform for marketing, sales, content management, and customer service.
Jira (source): The Jira source endpoint connects to Jira’s agile project management software.
You can now import/export a Flow from one project space to another.
...