The Google Fusion Tables API v1 has been deprecated as of May 3rd, 2016. The API will continue to work until August 1st, 2017, and will shut down on that date. A migration guide is available outlining the steps to take to migrate to v2.

Table

Represents a table consisting of data arranged in rows and columns.

For a list of methods for this resource, see the end of this page.

Resource representations

Represents a table.

{
  "kind": "fusiontables#table",
  "tableId": string,
  "name": string,
  "columns": [
    column Resource
  ],
  "description": string,
  "isExportable": boolean,
  "attribution": string,
  "attributionLink": string,
  "baseTableIds": [
    string
  ],
  "sql": string,
  "tablePropertiesJson": string,
  "tablePropertiesJsonSchema": string,
  "columnPropertiesJsonSchema": string
}
Property name Value Description Notes
attribution string Attribution assigned to the table. writable
baseTableIds[] list Base table identifier if this table is a view or merged table.
columnPropertiesJsonSchema string Default JSON schema for validating all JSON column properties. writable
columns[] list Columns in the table. writable
description string Description assigned to the table. writable
isExportable boolean Variable for whether table is exportable. writable
kind string The kind of item this is. For table, this is always fusiontables#table.
name string Name assigned to a table. writable
sql string SQL that encodes the table definition for derived tables.
tableId string Encrypted unique alphanumeric identifier for the table.
tablePropertiesJson string JSON object containing custom table properties. writable
tablePropertiesJsonSchema string JSON schema for validating the JSON table properties. writable

Methods

copy
Copies a table.
delete
Deletes a table.
get
Retrieves a specific table by its ID.
importRows
Imports more rows into a table.
importTable
Imports a new table.
insert
Creates a new table.
list
Retrieves a list of tables a user owns.
patch
Updates an existing table. Unless explicitly requested, only the name, description, and attribution will be updated. This method supports patch semantics.
replaceRows
Replaces rows of an existing table. Current rows remain visible until all replacement rows are ready.
update
Updates an existing table.