Writer Feature Type Properties: Format Parameters

Specifies how features will be written into the destination worksheet. Supported feature operations are:

• Upsert: Write cell values in a row. Any existing values in the destination cells are overwritten, similar to an Update. Features may optionally include a value for the row number attribute. See the section for the Start Writing At Row parameter for an explanation of the behavior when a feature without a row number is encountered. The worksheet extents are expanded as necessary.
• Update: Update cell values in the row corresponding to the feature. Features must include a value for the row number attribute. Features with a row number beyond the worksheet extents are ignored. This is the only mode natively supported by the Google Sheets API; other feature operations are abstractions on top of it.
• Delete: Blank values are written to the row corresponding to the feature, but only for cells in columns that correspond to an attribute on the feature type. Worksheet extents are not modified, and values present in adjacent rows are not shifted. Features must include a value for the row number attribute.
• fme_db_operation: The feature operation will be determined by the attribute fme_db_operation on each input feature. The value of fme_db_operation will be processed as follows:
• If the value is null, empty, or missing, it will be treated as Upsert.
• The value will next be matched to Upsert, Update, and Delete, case-insensitively.
• If there is no match, the feature will be rejected.
• If there is a match, the matched feature operation will be performed on the feature.

Important: Although features correspond to rows in the worksheet, the feature operation only applies to cells in columns that correspond to an attribute on the feature type.

Note: The fme_db_operation attribute will cause feature rejection when Feature Operation is set to Insert, Update, or Delete. This behavior differs from some older FME versions.

Controls how the feature type handles destination worksheets:

• Use Existing: If the destination worksheet does not exist, the translation will fail.
• Create If Needed: Create destination worksheet if it does not exist.
• Drop and Create: Delete the destination worksheet if it exists, and then re-create it. Note that the created worksheet will always be ordered after the existing worksheets.
• Truncate Existing: If the destination worksheet does not exist, the translation will fail. Otherwise, all cells in the existing worksheet are cleared before writing.

Allows the use of a different attribute for the purpose of specifying the row number in feature operations.

Default: googlesheets_row_number

Permits per-feature-type overriding of the value for the writer-level parameter Use Attribute Names As Column Position.

Influences the writing of the header row that contains field names, and the writing of features in Upsert mode for features that do not have a value for the googlesheets_row_number attribute.

In Upsert mode, when a feature without a value for googlesheets_row_number is encountered, the feature is written to the last empty row that is preceded by a populated row, starting the search from the row specified by this parameter.

This parameter does not influence the expected values of googlesheets_row_number. googlesheets_row_number, if provided, must be an absolute row number greater than or equal to this parameter.

If you do not specify a value for this parameter, it will default to a value of 1.

Determines the first column to which attributes are written.

This parameter is enabled only when the Use Attribute Names as Column Positions parameter is set to No.

If you do not specify a value for this parameter, it will default to a value of 1 or A.