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.


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": [
  "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


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