If the spreadsheet or worksheet that you want to read contains one or more leading or trailing spaces, the Worksheet Reader Snap throws an error. Workaround: Enclose the names of the spreadsheet and worksheet in quotes (") and enable expressions for both Spreadsheet and Worksheet fields. For example, "Sheet 1."
If you selectPreserve Data Typesandname the worksheet similar to theGooglespreadsheet column-row range; for example, AB123, then you may receive a bad request error.
Page lookup error: page "Spreadsheets Browser" not found.
Specify the name of the spreadsheet containing the worksheet to be read. It is suggestible based on the base folder.
Default value: [None] Example: My Google Sheet
Worksheet*
N/A
Specify the name of the worksheet to be read. It is suggestible based on the spreadsheet.
Hidden and Protected sheets are not a part of worksheet suggestions. However, you can manually enter the name of the existing worksheet that is hidden or protected to enable the Snap to overwrite based on your account permissions.
Worksheets with hidden range appear in the suggestion list.
Worksheets with protected range do not appear in the suggestion list.
You can view the list of hidden sheets in the Google Sheets UI by clicking Viewand then selecting Hidden Sheets.
You can view the protected ranges in Google Sheets UI by clicking Data and then selecting Protected sheets and ranges.
Default value: None Example: Sheet 1
Header exists
N/A
Select this checkbox if the worksheet's first row is a header.
Default value: Selected
Preserve data types
N/A
This Snap converts all input data types to strings. Select this check box to preserve the data type of the data coming into this Snap.
We recommend that you deselect Preserve data types if the file to be read is large (>50K rows in one sheet), as it makes the Snap read the data faster.
Default value: Not selected
Number of Retries
N/A
Specify the maximum number of retry attempts that the Snap must make to read the worksheet.
Default value: 3
Retry Interval (seconds)
N/A
Specify the time interval in seconds for each retry attempt.
Default value: 1
Connection properties
N/A
Configure the connection properties to specify the read timeout and connection timeouts.
Read timeout in seconds
N/A
Specify the time in seconds. In the event of a connection failure, the Snaps stops trying to read the data after the specified time.
Default value: 180
Connection timeout in seconds
N/A
Specify the time in seconds. In the event of a connection failure, the Snaps stops a connection attempt after the specified time. For example, if the HTTP timeout is set to 30 seconds, and the Snap fails to establish a connection until 30 seconds, the pipeline logs a timeout exception and aborts execution.
Updated and certified against the current SnapLogic Platform release.
November 2023
main23721
Stable
Updated and certified against the current SnapLogic Platform release.
August 2023
main22460
Stable
Updated and certified against the current SnapLogic Platform release.
May 2023
main21015
Stable
Upgraded with the latest SnapLogic Platform release.
February 2023
main19844
Stable
Upgraded with the latest SnapLogic Platform release.
November 2022
main18944
Stable
Upgraded with the latest SnapLogic Platform release.
August 2022
main17386
Stable
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.
4.29
429patches16975
Latest
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.
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.
4.28 Patches
428 patches14755
Latest
Enhanced the Spreadsheet Browser Snap with the Fetch Mode dropdown list. You can fetch:
Spreadsheets and worksheets within that Spreadsheet, or
Only Spreadsheets.
4.28
main14627
Stable
Upgraded with the latest SnapLogic Platform release.
4.27
main12833
Stable
Upgraded with the latest SnapLogic Platform release.
4.26
main11181
Latest
Enhanced the Worksheet WriterSnap to populate the target schema preview with headers and associated data types (when the data is written to an existing worksheet with a valid header) in the upstream Snap.
4.25
main9554
Stable
Upgraded with the latest SnapLogic Platform release.
4.24
main8556
Stable
Upgraded with the latest SnapLogic Platform release.
Upgraded with the latest SnapLogic Platform release.
4.22
main6403
Stable
Upgraded with the latest SnapLogic Platform release.
4.21
snapsmrc542
Stable
Upgraded with the latest SnapLogic Platform release.
4.20
snapsmrc535
Stable
Upgraded with the latest SnapLogic Platform release.
4.19 Patch
google/spreadsheet8333
Latest
Fixed an issue with the Google Worksheet Reader Snap wherein the Snap produces output documents for empty rows.
4.19
snaprsmrc528
Stable
Upgraded with the latest SnapLogic Platform release.
4.18
snapsmrc523
Stable
Upgraded with the latest SnapLogic Platform release.
4.17 Patch
google/spreadsheet7283
Latest
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.
4.17
ALL7402
Latest
Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.
4.17
snapsmrc515
Latest
Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.
4.16 Patch
google/spreadsheet6995
Latest
Fixed an issue wherein the Spreadsheets Browser Snap fails if a spreadsheet name contains / or : in Windows plex.
4.16
snapsmrc508
Stable
Upgraded with the latest SnapLogic Platform release.
4.15 Patch
google/spreadsheet6835
Latest
Added a new property, Parse data, to the Worksheet Writer Snap which helps preserve the date data type.
4.15 Patch
google/spreadsheet6639
Latest
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.
4.15
snapsmrc500
Stable
Upgraded with the latest SnapLogic Platform release.
4.14 Patch
google/spreadsheet5730
Latest
Migrated Google Sheets from API v3 to v4. Implemented retries to overcome defects in Sheets API.
4.14
snapsmrc490
Stable
Upgraded with the latest SnapLogic Platform release.
4.13 Patch
spreadsheet5293
Latest
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.
4.13
snapsmrc486
Stable
Upgraded with the latest SnapLogic Platform release.
4.12
snapsmrc480
Stable
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.
4.11
snapsmrc465
Stable
Upgraded with the latest SnapLogic Platform release.
4.10 Patch
spreadsheet3626
Latest
Addressed an issue where Worksheet Reader failed unexpectedly when validation mode input exceeded limitations.
4.10
snapsmrc414
Stable
Updated the Google Worksheet Writer Snap with Row count property to resolve the ' Data writing error'.
4.9.0 Patch
spreadsheet3104
Latest
Addressed an issue with Google Worksheet writer: Fails with " Data writing error "
4.9
snapsmrc405
Stable
Upgraded with the latest SnapLogic Platform release.
4.8
snapsmrc398
Stable
Upgraded with the latest SnapLogic Platform release.
4.7
snapsmrc382
Stable
Upgraded with the latest SnapLogic Platform release.
4.6
snapsmrc362
Stable
Upgraded with the latest SnapLogic Platform release.
4.5.1
snapsmrc344
Stable
Upgraded with the latest SnapLogic Platform release.
4.5
snapsmrc344
Stable
Enhanced the error view output to include error, reason, and resolution.