Replace Rows

6 variables

5 variables

Replaces rows of an existing table. Current rows remain visible until all replacement rows are ready

Authorization

To use this building block you will have to grant access to at least one of the following scopes:

Manage your Fusion Tables

Input

This building block consumes 6 input parameters

Name	Format	Description
`tableId` Required	`STRING`	Table whose rows will be replaced
`delimiter`	`STRING`	The delimiter used to separate cell values. This can only consist of a single character. Default is ,
`encoding`	`STRING`	The encoding of the content. Default is UTF-8. Use 'auto-detect' if you are unsure of the encoding
`endLine`	`INTEGER`	The index of the line up to which data will be imported. Default is to import the entire file. If endLine is negative, it is an offset from the end of the file; the imported content will exclude the last endLine lines
`isStrict`	`BOOLEAN`	Whether the imported CSV must have the same number of column values for each row. If true, throws an exception if the CSV does not have the same number of columns. If false, rows with fewer column values will be padded with empty values. Default is true
`startLine`	`INTEGER`	The index of the first line from which to start importing, inclusive. Default is 0

= Parameter name
= Format

tableId STRING Required

Table whose rows will be replaced

delimiter STRING

The delimiter used to separate cell values. This can only consist of a single character. Default is ,

encoding STRING

The encoding of the content. Default is UTF-8. Use 'auto-detect' if you are unsure of the encoding

endLine INTEGER

The index of the line up to which data will be imported. Default is to import the entire file. If endLine is negative, it is an offset from the end of the file; the imported content will exclude the last endLine lines

isStrict BOOLEAN

Whether the imported CSV must have the same number of column values for each row. If true, throws an exception if the CSV does not have the same number of columns. If false, rows with fewer column values will be padded with empty values. Default is true

startLine INTEGER

The index of the first line from which to start importing, inclusive. Default is 0

Output

This building block provides 5 output parameters

Name	Format	Description
`kind`	`STRING`	Type of the resource. This is always "fusiontables#task"
`progress`	`STRING`	Task percentage completion
`started`	`BOOLEAN`	false while the table is busy with some other task. true if this background task is currently running
`taskId`	`INTEGER`	Identifier for the task
`type`	`STRING`	Type of background task

= Parameter name
= Format

kind STRING

Type of the resource. This is always "fusiontables#task"

progress STRING

Task percentage completion

started BOOLEAN

false while the table is busy with some other task. true if this background task is currently running

taskId INTEGER

Identifier for the task

type STRING

Type of background task