Google Sheets v4 Reader Parameters

Service Connection

About Web Connections

Connections store authentication information.

For general information about web connections, please see Using Web Connections.

For information about managing web services (including authorization credentials such as Client Id and Client Secret), please see Managing Web Services.

Connection

From the Connection parameter in a web service format, you can do one of the following:

  • Select an existing previously defined connection. For information, see the section Reusing a Web Connection in Using Web Connections.
  • Select Add Web Connection to define a new connection. The new connection can be made visible only to the current user, or can be shared among multiple users.
Note  For production use, we recommend users obtain their own Client ID and Client Secret from the web service provider.

Constraints

Spreadsheet Name or URL

Specifies the spreadsheet to read:

  • Spreadsheet Name: The user’s Google Drive is searched for a spreadsheet that exactly matches the given name. Search scope is limited to My Drive. It is an error if more than one match is found.
  • Spreadsheet URL: For example, https://docs.google.com/spreadsheets/d/{spreadsheet_id}/edit. The portion of the URL following the spreadsheet ID is ignored.

Worksheet(s)

Click the Browse button to view a list of worksheets under the selected spreadsheet.

The selected worksheets will be added to the workspace.

Schema Generation

These parameters influence the schema generated for the feature types when they are first added to the workspace. In addition, the values supplied here are copied to the corresponding feature type parameters when the reader is initially added to the workspace.

Field Names Row

Optional

The row number that contains the field names. If not specified, then field names are column letters from Start Column to End Column.

Start Row

Optional

The row number of the first feature. The value must be greater than Field Names Row. If not specified, this is assumed to be either 1 or Field Names Row + 1, whichever is greater.

Start Column

The column from which to start reading and/or mapping field names to user attributes. Must be a value between A and ZZZ.

End Column

The column at which to stop reading and/or mapping field names to user attributes. Must be a value between A and ZZZ. The reader will read up to and including this column.

Value Options

The values supplied here are copied to the corresponding feature type parameters when the reader is initially added to the workspace.

Read Blank Cells As

  • Missing: The attribute is not added to the feature if its value is blank.
  • Null: Blank values are set on the feature with a null value.
  • Empty String: Blank values are set on the feature as an empty string.

Render Values As

  • Formatted Value: Read calculated and formatted values. In this context, this excludes text formatting such as bold and italics.
  • Unformatted Value: Read calculated but unformatted values.
  • Formula: Read uncalculated and unformatted values.

Render Datetimes As

  • Serial Number: Read date, time, datetime, and duration values as a decimal, where the whole number portion represents days after 1899-12-30, and the fractional portion as a fraction of a day.
  • Formatted String: Read date, time, datetime, and duration values as they appear in the web interface.

Schema Attributes

Use this parameter to expose Format Attributes in FME Workbench when you create a workspace:

  • In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
  • In a non-dynamic scenario, this parameter allows you to expose additional attributes on multiple feature types. Click the browse button to view the available format attributes (which are different for each format) for the reader.