Added the following Account to the Snap Pack:

Google Sheets - Google Service Account: Connects Google Sheets Snaps with data sources that use Google Service Account.

May 2023

Stable

Upgraded with the latest SnapLogic Platform release.

• The Allow empty rows checkbox in the Worksheet Reader Snap allows you to output empty rows. Select this checkbox to include empty rows between other rows that contain data.

• The Worksheet Writer Snap supports expressions for the Starting Cell Reference field. This Snap also includes a warning about potential overwriting of existing data for the Starting Cell Reference field when writing data in the same range of cells.

• Fixed an issue with the Worksheet Writer Snap where the Snap failed to write data correctly after each batch write. When the Write Mode is Create New Worksheet and Overwrite worksheet if it exists checkbox is selected, the cell data is shifted by five columns to the right after each batch in the resulting worksheet. Now, the data is written correctly in the worksheet.

• Introduced the following Snaps:

  • Google Sheet Subscribe Snap that allows you to subscribe to the specified spreadsheet for notifications of the changes in the Google Sheet.

  • Google Sheet Unsubscribe Snap that allows you to unsubscribe a spreadsheet.

• Enhanced the Spreadsheets Browser, Worksheet Reader, and Worksheet Writer Snaps with the Include Shared Drives checkbox to support working with the Google Shared Drives.

• Enhanced the Worksheet Reader and Worksheet Writer Snaps with the Display Spreadsheet ID in Suggestions checkbox. You can select this checkbox to display both spreadsheet ID and the spreadsheet name in the suggestions. This helps you to choose among the spreadsheets having the same name.

• Enhanced the Worksheet Writer Snap with the Write Mode dropdown list to perform the desired write option for the given worksheet—that is either create a new worksheet or append or edit an existing worksheet. You can write new data to the worksheet by specifying a cell reference as the starting point or append data to the worksheet at the last row in the worksheet containing content.

• Enhanced the Spreadsheet Browser Snap with the Fetch Mode dropdown list. You can fetch:

  • Spreadsheets and worksheets within that Spreadsheet, or

  • Only Spreadsheets.

4.27

main12833

13 Nov 2021 

Stable

Upgraded with the latest SnapLogic Platform release.

Enhanced the Snap Pack by migrating from version 3 to version 4 API as Google announces sunsetting the v3 API on June 8, 2021. For more information, see Migrating Google Spreadsheet Pipelines from V3 to V4.

Fixed an issue with the Google Worksheet Reader Snap wherein the Snap produces output documents for empty rows.

Fixed an issue with the Google Worksheet Writer Snap wherein the No of valid records written field in the output document would count the header row.

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

Fixed an issue wherein the Spreadsheets Browser Snap fails if a spreadsheet name contains / or : in Windows plex.

Added a new property, Parse data, to the Worksheet Writer Snap which helps preserve the date data type.

Added new properties, Preserve data types, Connection properties, Read timeout in seconds, and Connection timeout in seconds, to the Worksheet Reader Snap. These properties let you convert input data types to strings and handle connection timeouts. Also, fixed issues with header count, column count mismatch and rendering of columns with no headers.

Migrated Google Sheets from API v3 to v4. Implemented retries to overcome defects in Sheets API.

Fixed the Google Worksheet Writer Snap that incorrectly displays numeric values as a string in the spreadsheet when writing in batch mode. The spreadsheet now preserves the exact data type of the input value.  

snapsmrc486

snapsmrc480

Added the Batch write property  in Worksheet Writer to enable writing the input documents into the worksheet as a single batch instead of writing the input data one cell at a time.

snapsmrc414

Updated the Google Worksheet Writer Snap with Row count property to resolve the ' Data writing error'.

Addressed an issue with Google Worksheet writer: Fails with " Data writing error "

snapsmrc398

snapsmrc382

snapsmrc344

snapsmrc344

Enhanced the error view output to include error, reason, and resolution.