[ Highlights ] [ Dot Releases - Snaps ] [ API Management ] [ AutoSync ] [ Monitor ] [ Platform ] [ Snaps ] [ SnapGPT ] [ Documentation Enhancements ]

Highlights

The SnapLogic®January 2024 Release includes the following:

API Management

API, API Version, Proxy, and Proxy Endpoint names are now editable

AutoSync

Interface enhancements in the data pipeline wizard and card view

Monitor

From the Execution overview, open a pipeline in Designer to view the pipeline runtime with color-coded Snaps to identify warnings and failures

Platform

Groundplexes can now run on Windows Server 2022
Added a user interface option to the Git menu to allow the user to untrack a project

Snaps

Microsoft Dynamics 365 Finance and SCM Snap Pack: Added the following Snaps:
- Dynamics 365 Finance and SCM Bulk Import: Bulk imports the data associated with the selected entity in the Microsoft Dynamics 365 Finance and SCM application
- Dynamics 365 Finance and SCM Bulk Export: Bulk exports the data associated with a selected entity from the Microsoft Dynamics 365 Finance and SCM application
NetSuite REST Snap Pack: Added the following Snaps:
- NetSuite REST Create: Creates records using the NetSuite REST API
- NetSuite REST Update: Updates records using the NetSuite REST API through the Internal ID
- NetSuite REST Delete: Deletes records using the NetSuite REST API through the Internal ID
Workday: Added the WorkdayQL Snap, which connects with the Workday Query Language (WQL) endpoints
Amazon S3: Added support for Amazon S3 Express One Zone

SnapGPT

Supports pipeline parameters in mapping and expression generation
Generates multiple expressions instead of one
Analyzes pipelines and suggest ways to improve your pipelines
Remembers previous questions and answers in the current conversation

Dot Releases - Snaps

Snap Pack	Date of Update	Snap Pack Version	Updates
NetSuite REST	07 Feb 2024	435patches24944	Added the following Snap in the NetSuite REST Snap Pack: NetSuite REST Upsert: Creates and updates records using the NetSuite REST API through the External ID. Fixed an issue with the NetSuite REST Search Snap that encountered a `java.lang.StackOverflowError` error when the Page size was not set to the default value.
Marketo	06 Feb 2024	435patches24804	Fixed an issue with the Marketo Bulk Extract Snap where the timeout was not disabled when the Timeout setting was set to 0.
JDBC	06 Feb 2024	435patches24781	The database connection error message in the Generic Database Account is improved for clarity and readability.
Snowflake	05 Feb 2024	435patches24865	Fixed an issue across the Snowflake Snaps that populated all suggestions for the Schema and Table Names existing in the configured Snowflake Account. Now, the Snaps only populate suggestions related to the database configured in the Account.
Copybook	05 Feb 2024	main167	Fixed an issue with the COBOL Copybook Formatter Snap to ensure that output data is written as a single binary output.
API Suite	02 Feb 2024	435patches25047	Fixed an issue that caused the HTTP Client Snap to fail when the Basic Authentication account password contained special characters.
Azure OpenAI LLM HTML Utilities LLM Utilities OpenAI LLM Pinecone	31 Jan 2024	435patches24967	Introduced the following Snap Packs: Azure OpenAI LLM Snap Pack, which contains the following Snaps and Account: Azure OpenAI Chat Completions: Generates chat completions using the specified model and model parameters. Azure OpenAI Embedder: Generates an embedding vector based on the provided input data. Azure OpenAI Prompt Generator: Generates the augmented user prompt as per the specified prompt template using mustache template formatting. Azure OpenAI API Key Account: Authenticates with Azure OpenAI's APIs using the specified API key for secure and authorized access. HTML Utilities Snap Pack, which contains the following Snaps: HTML Parser: Parses the HTML content into the text format. Markdown Parser: Parses the Markdown content into the text format. HTML to Markdown Converter: Converts the HTML content into Markdown format. HTML Parser: Parses the HTML content to text format. Markdown Parser: Parses the Markdown content to text format. HTML to Markdown Converter: Converts the HTML content to Markdown format LLM Utilities Snap Pack, which contains the following Snap: Chunker: Creates customized chunks of knowledge context with defined properties. OpenAI LLM Snap Pack, which contains the following Snaps and Account: OpenAI Chat Completions: Generates chat completions using the specified model and model parameters. OpenAI Embedder: Generates an embedding vector based on the provided input data. OpenAI Prompt Generator: Generates the augmented user prompt as per the specified prompt template using mustache template formatting. OpenAI API Key Account: Authenticates with OpenAI's APIs using the specified API key for secure and authorized access. Pinecone Snap Pack, which contains the following Snaps and Account: Pinecone Query: Queries records in the Pinecone database, retrieves the top matching vectors close to a given vector, and outputs the corresponding metadata for those vectors. Pinecone Upsert: Processes the vector from the input document and writes the data and the associated metadata in the specified index name and namespace. Pinecone Account: Authenticates with Pinecone APIs using the API key.
Workday	31 Jan 2024	435patches24944	Fixed an issue with Workday REST Snap where the input schema of the Snap did not populate in the upstream Mapper Snap.
HubSpot	30 Jan 2024	main166	Added the following new Bulk Snaps to the HubSpot Snap Pack: Hubspot Bulk Create: Creates data objects in bulk in the HubSpot HubSpot Bulk Read: Retrieves data objects in bulk from HubSpot. Hubspot Bulk Update: Updates the specified data objects in bulk in HubSpot. Hubspot Bulk Delete: Deletes the specified data objects in bulk in HubSpot.
Transform	30 Jan 2024	435patches24802	Fixed an issue with the Excel Parser Snap that caused a null pointer exception when the input data was an Excel file that did not contain a `StylesTable`.
Oracle	30 Jan 2024	435patches24769	Fixed an issue with the Oracle Snap Pack that required the i18n extensions to be present when the Oracle database instance was in a specific language.
Salesforce	24 Jan 2024	435patches24747	Fixed an issue that caused the input stream to not close properly, which resulted in stale connections.
API Suite	23 Jan 2024	435patches24708	Added support for the SSL OAuth2 Account. The HTTP Client and GraphQL Client Snaps now support accessing usernames and passwords from the Basic Authentication account. The HTTP Client Snap also has this capability for the Digest Authentication, NTLM, SSL, and Google Service accounts. Enhanced the API Suite OAuth2 Account with the Send client data as Basic Auth header checkbox to pass the client data as a part of the Basic Authentication header when generating a token.
ServiceNow	23 Jan 2024	435patches24712	The Batch Size field is now relabeled as Page size in the ServiceNow Query and ServiceNow Insert Snaps.
Binary	22 Jan 2024	435patches24525	Fixed an issue with the File Poller Snap that caused it to poll recursively for files in the root directory of the S3 bucket.
Oracle	19 Jan 2024	435patches24445	Enhanced the Oracle-Execute, Oracle-Select, and Oracle-Lookup Snaps with a Column-specific timestamp precision checkbox to represent column-specific timestamp precision for the string data type. The Oracle-Insert, Oracle-Update, and Oracle-Bulkload Snaps now support up to nanosecond precision for the string data type.

API Management

Enhancements

You can now rename or edit an unpublished API, API Version, Proxy, and Proxy Endpoint to align with your company standards and best practices to ensure an efficient operation.
The API Dashboard now displays the Remote Address field in the API request details table to showcase the client IP of the API invoker. Learn more about API Insights.

Fixed Issues

Fixed an issue where the Triggered Task for an APIM URL did not return any data when the expected behavior was an Asset does not exist message.
Fixed an issue where, if you created an API from an existing Project and selected a few assets in some but not all asset categories, then the resulting API version would not have any assets.

Known Issues

We do not support Azure AD for the OAuth 2.0 Client Credentials policy because Azure AD does not provide an introspection endpoint.
Workaround: Use the JWT credentials OAuth2 policy to authenticate with Azure AD.

AutoSync

Enhancements

The transformation screen preview now shows the schemas for empty tables:
Edit a data pipeline by double-clicking the card.
Improved screen for handling naming conflicts:

Fixed Issues and Behavior Changes

The data pipeline wizard Replace empty values screen no longer shows non-nullable columns.
Data pipeline wizard transformation screens, Filter columns and Replace empty values, now display the schema for tables and objects that have no data.
For the Salesforce endpoint in integrations using Incremental load, AutoSync uses one of the following timestamp fields for the last updated column. It selects the field in this order of priority: SystemModStamp, LastModifiedDate, CreatedDate, LoginTime.

Monitor

Feature

From the Execution overview screen Actions column, open a pipeline in Designer to view the color-coded Snaps and identify warnings and failures.

Platform

Features

Groundplexes can now run on Windows Server 2022.
Added a user interface option to the Git menu to untrack a project space or a project, which removes the Git metadata.

Enhancements

Accounts with Secrets expressions now validate successfully.
In Environments configured to expire passwords, users now receive an email reminder to reset their password before it expires.

Known Issues

When you click the Quick Tour links for Designer, Manager, and Dashboard, the redirect results in an HTTP 404 error.
The end time of the Scheduled Task, when selected under Date/Time, can erroneously be set earlier than the Start time.

Fixed Issues

Fixed an issue where, if you set up but did not start the OpenTelemetry service, the system logged the following error:

SEVERE: Failed to export metrics. The request could not be executed. Full error message: Failed to connect to /0.0.0.0:xxx.

Behavior Changes

For specific Orgs, the Dashboard tab redirects to the Monitor.

Snaps

note

The Snaps mentioned in this section are deployed on the Latest distribution type. To access the updated Snap Packs, an Org admin must select the Snap Pack version in Manager > Snap Packs.

Upcoming

Starting with the Aug 2024 (4.38) release, only Snap Pack versions from the previous two platform releases will be available. For example, for the August release, only 4.37 (May 2024) and 4.36 (Feb 2024) will be available. If your Org is configured with earlier Snap Pack versions, you must upgrade to the latest supported version by the August 2024 release. Learn more about the Upcoming Policy Change for Snap Pack Versions.

New Snaps

Microsoft Dynamics 365 Finance and SCM Snap Pack: Added the following Snaps:
- Dynamics 365 Finance and SCM Bulk Import: Bulk imports the data associated with the selected entity in the Microsoft Dynamics 365 Finance and SCM application.
- Dynamics 365 Finance and SCM Bulk Export: Bulk exports the data associated with a selected entity from the Microsoft Dynamics 365 Finance and SCM application.
NetSuite REST Snap Pack: Added the following Snaps:
- NetSuite REST Create: Creates records using the NetSuite REST API.
- NetSuite REST Update: Updates records using the NetSuite REST API through the Internal ID.
- NetSuite REST Delete: Deletes records using the NetSuite REST API through the Internal ID.
Workday Snap Pack: Added the WorkdayQL Snap, which connects with the Workday Query Language (WQL) endpoints.

Enhancements

Amazon S3: Added support for Amazon S3 Express One Zone.
Marketo:
- Added the Include export ID checkbox in the Bulk Extract Snap to support the display of the export ID in the output.
- Enhanced the Bulk Lead Extract Snap to add the export ID to the output document.
NetSuite REST SuiteQL, NetSuite REST Read, and NetSuite REST Search Snaps: Removed the Retry settings and Timeout options field sets.
Salesforce: Enhanced the performance of the Salesforce Bulk Query Snap with a new Maximum threads field. Use this field to download query results simultaneously in multiple threads.

SnapGPT

Supports pipeline parameters in mapping and expression generation
Generates multiple expressions instead of one
Analyzes pipelines and suggest ways to improve your pipelines
Remembers previous questions and answers in the current conversation

Documentation Enhancements

Improvements

Try It Out functionality for your API now includes a troubleshooting section to easily resolve errors.
Updated the example to showcase the configuration of the OAuth 2.0 Client Credentials policy.

New Articles

Learn how to load data from one data warehouse to another with the Snowflake Use Case.
Learn how to integrate an ERP application with CRM solutions with the NetSuite REST Use Case.