Snap Pack	Snap Pack Build Name	Updates
Transform	423patches7958	Fixes an issue in the JSON Splitter Snap by not logging a `NumberFormatException` error, that is, an error which is logged while converting a string into a numeric value.
Binary	423patches8453	Fixes an issue in the File Writer Snap with the ADL protocol, to perform the correct action when OVERWRITE is selected from the File Action drop-down field.
Google Analytics	423patches8397	Fixes an authorization issue in the Snap Pack by migrating to a verified Google OAuth application.
Binary	423patches8368	Fixes an encryption issue with the File Operation Snap by implementing both SSE-KMS and SSE-S3 supports to the Snap.
JDBC	423patches8027	Fixes a multiple connection issue in the JDBC Snap Pack that occurs when the Auto Detect field is enabled for each execution of the Snap by storing a copy of the database name.
Binary	423patches8368	Fixes an issue in the Binary Snap Pack by removing the plaintext credentials in the file URL from the JCC log messages.
Active Directory LDAP	423patches7454	Adds the Pass through check box in all the Snaps to include pass-through functionality. Select this check box to embed the upstream input documents under the `original` field of the output document along with other records.
Active Directory	423patches8210	Fixes an issue of fetching search records in the Active Directory Search Snap by adding a new field, Limit, to specify the number of search records to fetch from the Active Directory. Your existing Pipelines that use Page Size for limiting records may fail to execute. Hence, modify your Pipelines using the Limit field.
SQL Server	423patches8190	Fixes an issue with SQL Server - Execute to handle SQL statements that begin with special characters.
Binary	423patches8099	Enhances the Snap Pack by upgrading the SMB client library.
Google Directory	423patches7817	Fixes the authorization issue in the Snap Pack by migrating to a verified Google OAuth application.
Binary	423patches7958	Fixes an issue with the File Writer Snap by avoiding overwriting of documents when appending the data to a CSV file in SFTP.
Confluent Kafka	423patches7900	Removes the Confluent prefix from the Snaps and accounts in the Snap Pack. However, the Snap Pack name continues to be Confluent Kafka Snap Pack. Adds Wait For Full Count check box to the Kafka Consumer Snap to determine how a positive value for the Message Count field must be interpreted. Enabled (by default): The Snap continues polling for messages until the specified count is reached. Disabled: If there are fewer messages currently available than the specified count, then the Snap consumes the available messages and terminates. Known Issue The Wait For Full Count check box activates only when you provide a positive integer value in the Message Count field. However, it does not activate when you use an expression for Message Count even if the value evaluates to a positive number. Workaround: To activate this check box, temporarily replace the Message Count expression () with a positive integer, select the desired state for Wait For Full Count, and then restore the original value in the Message Count field. Adds support for writing and reading record headers. The Kafka Producer Snap has a new Headers table to configure the Key, Value, and Serializer for each header to be written. The Kafka Consumer Snap reads any headers present on the records it consumes. It provides two new fields to configure how the header values should be deserialized – Default Header Deserializer and Header Deserializers, for any headers that require a deserializer other than the default. Adds support for writing and reading each record’s timestamp. The Kafka Producer Snap has a new Timestamp field that can be configured to set each record’s timestamp, which is the number of milliseconds since the epoch (00:00:00 UTC on January 1, 1970). This can be set to an expression that evaluates to a long integer, or a string that can be parsed as a long integer, or a date. If you specify no expression, or the value is empty, then the timestamp is set to the current time. The Timestamp field is only relevant if the Kafka topic is configured with `message.timestamp.type` `= CreateTime` (which is the default). For more information, see the official Kafka documentation. The Kafka Consumer Snap has a new check box, Include Timestamp, which by default is disabled for backward compatibility. If enabled, the output for each record includes its timestamp in the metadata. The Kafka Producer Snap has a new check box, Output Records, to determine the format of each output document when configured with an output view. Disabled (by default): The Snap’s output includes only the basic metadata (topic, partition, offset) for each record, along with the original input document. Enabled: Each output document contains a more complete representation of the record produced, including its key, value, headers, and timestamp. The Kafka Consumer Snap has a new field, Output Mode, with two options: One output document per record (the default): Every record received from Kafka has a corresponding output document. One output document per batch: Preserves the batching of records as received from Kafka. Every poll that returns a non-empty set of records results in a single output document containing the list of records as `batch`, `batch_size` and `batch_index`. This mode is especially useful when Auto Commit is disabled and Acknowledge Mode is Wait after each batch of records, depending on the nature of the processing between the Kafka Consumer and the Kafka Acknowledge Snaps. Removes the Add 1 to Offsets check box from the Kafka Consumer Snap. Removes the Account tab from the Kafka Acknowledge Snap, as it no longer needs an account. The Confluent Kafka Snap Pack documentation will be updated along with 4.24 GA, scheduled for .
Transform	423patches7898	Fixes an issue in the In-Memory Lookup Snap to correctly handle the Join path in the format like $['join path']. Fixes an issue in the XSLT Snap, wherein null binary header values are now converted to blank strings when injecting them as parameters in the stylesheet.
Transform	423patches7792	Fixes an issue in the XML Formatter Snap when it fails to convert input JSON data, with the JSON property having a special character as its prefix, to the XML format by sorting the elements.
Binary	423patches7958	Rolls back the recent patch to Binary Snap Pack (File Writer Snap - 423patches7923) that might induce SSL handshake failures/terminations in existing Pipelines.
Salesforce	423patches7888	Fixes the the following Snaps to ensure that they maintain lineage when using in Ultra Pipelines. Salesforce Create Salesforce Delete Salesforce Update Salesforce Upsert Salesforce Subscriber Salesforce Publisher This fix does not affect the bulk action Snaps in this Snap Pack that produce more than one output document for each input document.
Binary	423patches7923	Fixes the SFTP connection failure issue in the File Writer Snap by: Ensuring that the BouncyCastleProvider is the first in the list of providers in the Security object. Upgrading the BouncyCastle version to 1.67. As of April 20, 2021, we recommend that you not use the 423patches7923 build for the File Writer Snap, because it causes connectivity issues with the Snaplex nodes.
Snowflake	423patches7905	Fixes the performance issue in the Snowflake - Bulk Load Snap while using External Staging on Amazon S3.
Binary	423patches7795	Fixes an issue with File Writer Snap by skipping the validation of the SAS URI having write permission, if the SAS URI uses an access policy.
JDBC	423patches7800	Fixes an issue with JDBC account through a Test Query option to establish a database connection upon using Auto detect option for the Database name.
Google Spreadsheet	423patches7848	Enhances the Google Spreadsheet Snap Pack by migrating from v3 to v4 API as Google announces sunsetting the v3 API on June 8, 2021. For more information, see Impact on Migrating Google Spreadsheet Pipelines from v3 to v4.
Marketo	423patches7812	Introduces the Marketo Snap Pack to enable you to automating the process of performing operations to the Asset database and Lead database that manage the potential data for an organization in the marketing industry. Asset Read: Queries the Asset database to retrieve assets using commands. Asset Write: Interacts with the assets using commands and make modifications to the Asset database. Lead Read: Queries the Lead database to retrieve leads using commands. Lead Write: Interacts with the leads using commands and make modifications to the Lead database. Bulk Lead Extract: Retrieves leads in bulk from the Lead database. Bulk Lead Upsert: Inserts/Updates large number of leads in the Lead database.
OpenAPI	423patches7812	Introduces the OpenAPI Snap Pack to enable you to connect to your OpenAPI endpoints. This Snap Pack supports OpenAPI Specification versions 2.0 and 3.0.
SOAP	423patches7441	Enhances the SOAP Execute Snap by including an additional output view. When named debug (all lower-case), the Snap outputs the SOAP request headers, envelope, and the output document that is written to the default output view.
Script	423patches7671	Fixes an issue with the PySpark Snap by removing the dependency on the json-path library, thus avoiding a conflict between the external library version and the SnapLogic json-path.jar.
MySQL	423patches7732	Fixes an issue in the MySQL - Bulk Load Snap to support the following versions: MySQL 8.0.17 MySQL 5.6.34
Microsoft Power BI	main76	Updates the dependencies and documentation links for all the Microsoft Power BI Snaps.
Transform	423patches7753	Fixes an issue with the JSON Splitter Snap's behavior in Ultra Pipelines that prevents processed requests to be acknowledged and removed from the FeedMaster queue, resulting in retries of requests that are already processed successfully.
Binary	423patches7660	Enhances the File Poller Snap by adding a field, Exit on first matches, which when set to true stops the Snap from executing after the first file paths matching the filter are written to the output view. If the field is not configured or is set to false (default value), then the Snap continues to poll the directory until the Polling timeout is reached.
SharePoint Online	main75	Fixes the error view issue in SharePoint Online - Upload File Snap by dragging a new instance of SharePoint Online - Upload File Snap to the canvas, since the existing Snap that is used with a version that contains the bug continues to fail.
Hadoop	423patches7440	Fixes the issue in HDFS Reader Snap by supporting to read and write files larger than 2GB using the ABFS(S) protocol.
SAP HANA	423patches7548	Fixes the batch size issue in SAP HANA - Upsert Snap by using a prepare statement when sending the batch request.
Box	423patches7526	Fixes the intermittent failure in access token refresh for the Box OAuth2 account by adopting the `refreshAccessTokenIfExpired()` method that checks and refreshes the access token within the last minute of its expiry.
SharePoint Online	main74	Fixes the socket timeout issue in the Snap Pack by making the following changes: Modifies the code to return the `ProxyHttpClient` instead of the basic HTTP client and handle the custom `siteName`. Fixes the broken `JUnit` and code for pagination in the SharePoint Online - List Read Items Snap.
Adobe Experience Platform (Deprecated in 4.24 GA)	423patches7447	Fixes the Adobe Experience Platform Execute Snap issue of not passing data correctly to the downstream Snap by creating `Map obj = new LinkedHashMap()`; inside loop. `LinkedHashMap` is a hash table and linked list implementation of the Map interface, with a predictable iteration order.
Splunk	423patches7504	Enhances the Splunk Search Snap by adding a new field, Response Mode, which allows receiving either JSON or XML response from the Splunk server. The default mode is XML, to enable backward compatibility.
SAP	422patches7378	Enhances the SAP Execute Snap to process the structure that contains nested Table Type fields in the output document by recursively parsing them into a Map or a List set.

Browser not supported