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

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.

Value Options

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

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.