In this article

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.

4.28 UAT Delta

4.28 Dot Releases

SnapLogic Studio

Snaps

Platform 

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.

API Management

New Features

• Proxies. SnapLogic's new Proxies feature allows you to seamlessly integrate with your custom APIs and third-party APIs by providing API administration, monitoring, and security management within the API Manager.

  Open

  

• Naming restrictions for APIM assets. The following restrictions now apply to the names for API Manager assets (APIs, API versions, Proxies, Proxy Endpoints):

  • Must be unique.

  • Must begin with alphanumeric characters A-Z, a-z, or 0-9.

  • Cannot contain the reserved keyword shared.

  • Cannot contain |, <, >, [, ], {, }, #, ?, /, and \.

  • Must be no more than 256 characters. If the name includes double-byte characters, the maximum length is shorter.

• Deleting API version assets. You can now delete multiple assets associated with an API version at the same time. To do so:

Open

Developer Portal

New Features

• Try It Out. You can now test your APIs in the Developer Portal using the Try it out button. It works with all APIs with only two requirements:

  • The API must include a CORS Restriction policy.

  • The API must be published.

• Subscribe button in the API description. You can now subscribe to a custom API while viewing its description page in the Developer Portal.

Enhancements

• Account and Subscription Management Based on User Role. Only Org Administrators can manage (create, approve, deny, or delete) Developer Portal user accounts and API subscriptions. System Administrators and regular users can only view these users and API subscriptions.

Snaps

New Snaps

Azure Service Bus: A cloud messaging service that connects applications, devices, and services running in Azure Cloud to any other applications or services. This Snap Pack offers the following Snaps:

• ASB Acknowledge: Acknowledges messages from a queue in ASB.

• ASB Producer: Sends messages to a queue or topic in ASB.

• ASB Consumer: Reads messages from a queue or topic in ASB.

Exact Online: Allows companies to speed up their business process and automation for payroll, expenses, and other accounting workflows. This Snap Pack offers the following Snaps:

• Exact Online Read: Reads and retrieves data objects from the Exact Online instance.

• Exact Online Create: Creates data objects in the Exact Online instance.

• Exact Online Update: Updates a data object in the Exact Online instance.

• Exact Online Delete: Deletes a data object in the Exact Online instance.

Active Directory: Added the Active Directory Remove Member Snap that enables you to remove an existing member from a specified group in Active Directory.

SharePoint Online: Added the SharePoint Online - Get Sites Snap that enables you to get the list of sites specific to the logged-in user from the SharePoint Online site.

Snap Enhancements

• Binary

  • Enhanced the File Operation Snap to support Azure Data Lake Storage (ADLS) Gen2 protocol for moving and copying files in the Azure Blob File System (ABFS).

  • Fixed an issue with the File Poller Snap to enhance the performance of the polling operations that allow the Snap to poll the files without stopping.

  • Enhanced the S3 File Writer Snap with the Suggest fully-qualified file names checkbox that allows you to use fully-qualified file names in the File name Suggestions list for gov cloud instances.

  • Enhanced the File Writer, S3 File Writer, and ZipFile Write Snaps with the AWS Canned ACL (Access Control List) permission mode that enables you to use Canned ACLs when creating the S3 Object. This feature allows you to grant full access of the object to the S3 bucket owner.
    
    

• Database Delete Snaps

  • Updated the label for Delete Condition to Delete Condition (Truncates Table if empty) in the following Snaps:

    • Snowflake Delete

    • SAP HANA Delete

    • MySQL Delete

    • Redshift Delete

    • Oracle Delete

    • PostgreSQL Delete

    • SQL Server Delete

    • Vertica Delete
      
      

• Flow: Enhanced the Filter Snap with the Null-safe access checkbox. Select this checkbox to consider the valid values in the filter expression and remove the missing or empty data instead of treating them as null.
  
  

• JDBC

  • Enhanced the following Snaps to support DML (Data Manipulation Language) operations (
CREATE, ALTER, INSERT, and SELECT) when using AWS Athena database.

    • Generic JDBC - Execute

    • Generic JDBC - Insert

    • Generic JDBC - Select
      
      

• Marketo Snap Pack: Enhanced the Bulk Lead Extract and Bulk Lead Upsert Snaps with retry mechanism fields to set a time limit to complete the processing of operations:

  • Timeout (seconds)

  • Number of Retries

  • Retry Interval (seconds)
    
    

• ML Data Preparation: Enhanced the Type Converter Snap with the Fail safe upon execution checkbox. Select this checkbox to enable the Snap to convert data with valid data types, while ignoring invalid data types.
  
  

• Oracle

  • Enhanced the Oracle - Update Snap to accept values in the Number of Retries and Retry Interval (seconds) fields from Pipeline parameters only. 

  • Enhanced the