On this Page
Table of Contents | ||||
---|---|---|---|---|
|
Overview
You can use this Snap Worksheet Reader is a Read-type Snap that enables you to read a worksheet in a spreadsheet and write the data to the output view.
Note | ||||
---|---|---|---|---|
| ||||
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 Migrating Google Sheets Pipelines from V3 to V4. |
Prerequisites
A valid Google Spreadsheet account.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Limitations
- If the spreadsheet or worksheet that you want to read contains one or more leading or trailing spaces, the Worksheet Reader Snap throws displays 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 select Preserve Data Types and name the worksheet similar to the Google spreadsheet column-row range; for example, AB123, then you may receive a bad request error.
Multiexcerpt include macro name ME_GS_V3toV4 page Spreadsheets Browser
Known Issue
Multiexcerpt include macro | ||||
---|---|---|---|---|
|
Snap Input and Output
Input/Output | Type of View | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document |
|
| The name of the worksheet to be read, including the base folder and spreadsheet information. |
Output | Document |
|
| The data of the provided worksheet. |
Snap Settings
Field Name | Field |
---|
Type | Description | |
---|---|---|
Label* |
String | Specify |
a unique and meaningful name for the Snap. |
Default Name: |
Worksheet Reader | |
Spreadsheet* |
---|
String/Expression/ |
Suggestion | Specify the name of the spreadsheet containing the worksheet to be read. |
Alternatively, click the Suggestion icon to populate the list of spreadsheets associated to the account and select the required spreadsheet. Default value: [None] | |
Worksheet* |
---|
String/Expression/ |
Suggestion | Specify the name of the worksheet to be read. |
Alternatively, click the Suggestion icon to populate the list of worksheets associated to the account and select the required worksheet.
Default value: None | |||
Header exists |
---|
Checkbox | Select this checkbox if the worksheet's first row is a header. Default value: Selected | |
Preserve data types |
---|
Checkbox | 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.
Default value: |
Deselected | |
Number of Retries |
---|
Integer/ |
Expression | Specify the maximum number of retry attempts that the Snap must make to read the worksheet. Default value: 3 | |
Retry Interval (seconds) |
---|
Integer/ |
Expression | Specify the time interval in seconds for each retry attempt. Default value: 1 | |
Connection properties |
---|
Use this field set to configure the connection properties |
. This field set contains the following fields:
| ||
Read timeout in seconds |
---|
Integer/ |
Expression | 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 |
100 | |
Connection timeout in seconds |
---|
Integer/ |
Expression | 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. Default value: 20 | |
Snap Execution |
---|
Dropdown list |
Default value: Validate & Execute |
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|