Versions Compared

Old Version 31

changes.mady.by.user Kalpana Malladi

Saved on

compared with

New Version 32

changes.mady.by.user Kalpana Malladi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

...

Support for Ultra Pipelines

Works in Ultra Pipelines.

Limitations

Multiexcerpt macro
nameME_GS_V3toV4
  • Inputs without any format restrictions are accepted when the expression toggle is enabled and a Pipeline parameter is provided for the following fields:
    • Number of Retries
    • Retry Interval
    • Read timeout in seconds
    • Connection timeout in seconds
  • For an expression input, the value is evaluated and accepted if it meets the expression criteria; if not, then the default value is used.
  • You will find the Snap fetching all worksheets in the output, regardless of them being either hidden or protected.

Known Issue

Multiexcerpt macro
nameME_GS_KI

A long-standing bug​ in the Google Sheets endpoint does not allow the use of a colon ':' in the worksheet names; hence, these inputs are not supported.

Snap Views

TypeFormatNumber of ViewsExamples of Upstream and Downstream SnapsDescription
OutputDocument
  • Min:0
  • Max:1
  • None
The name filter to select the desired spreadsheets.
InputDocument
  • Min:1
  • Max:1
  • File Writer
  • Transform
List of spreadsheets available in the provided folder matching the provided name filter. Provides Sheet ID, Sheet name, and Worksheets within.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter while running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab. The available options are:

  • Stop Pipeline Execution: Stops the current pipeline execution when the Snap encounters an error.

  • Discard Error Data and Continue: Ignores the error, discards that record, and continues with the rest of the records.

  • Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

...

Field Name

Field Type

Description


Label*


String

Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.

Default value: Spreadsheets Browser
Example: Spreadsheets Browser

Name filter



String/Expression

Specify the GLOB pattern to look for spreadsheets having name pattern.

Default value: None
Example: Filter1

Fetch Mode

Dropdown list

Choose an option to fetch the Spreadsheets. The available options are:

  • Spreadsheets and Worksheets: Fetches Spreadsheets and Worksheets within the Spreadsheet.

  • Spreadsheets: Fetches only the Spreadsheets.

Default Value: Spreadsheets and Worksheets
Example: Spreadsheets

Number of RetriesNInteger/AExpression

Specify the maximum number of retry attempts that the Snap must make to read the worksheet.

Default value: 3
Example: 2

Retry Interval (seconds)NInteger/AExpression

Specify the time interval in seconds for each retry attempt.

Default value: 1
Example: 2

Snap Execution


N/ADropdown list
Multiexcerpt include macro
nameSnap_Execution_Introduced
pageAnaplan Read

...