Google Fusion Tables API

API Reference

This API reference is organized by resource type. Each resource type has one or more data representations and one or more methods.

Resource types

  1. Table
  2. Column
  3. Template
  4. Style
  5. Query

Table

For Table Resource details, see the resource representation page.

Method HTTP request Description
URIs relative to https://www.googleapis.com/fusiontables/v1, unless otherwise noted
copy POST  /tables/tableId/copy Copies a table.
delete DELETE  /tables/tableId Deletes a table.
get GET  /tables/tableId Retrieves a specific table by its ID.
importRows POST
https://www.googleapis.com/upload/fusiontables/v1/tables/tableId/import

and
POST  /tables/tableId/import
Import more rows into a table.
importTable POST
https://www.googleapis.com/upload/fusiontables/v1/tables/import

and
POST  /tables/import
Import a new table.

Required query parameters: name

insert POST  /tables Creates a new table.
list GET  /tables Retrieves a list of tables a user owns.
patch PATCH  /tables/tableId Updates an existing table. Unless explicitly requested, only the name, description, and attribution will be updated. This method supports patch semantics.
update PUT  /tables/tableId Updates an existing table.

Column

For Column Resource details, see the resource representation page.

Method HTTP request Description
URIs relative to https://www.googleapis.com/fusiontables/v1, unless otherwise noted
delete DELETE  /tables/tableId/columns/columnId Deletes the column.
get GET  /tables/tableId/columns/columnId Retrieves the specified column's name and type.
insert POST  /tables/tableId/columns Adds a new column to the table.
list GET  /tables/tableId/columns Retrieves a list of the specified table's columns.
patch PATCH  /tables/tableId/columns/columnId Updates the name or type of an existing column. This method supports patch semantics.
update PUT  /tables/tableId/columns/columnId Updates the name or type of an existing column.

Template

For Template Resource details, see the resource representation page.

Method HTTP request Description
URIs relative to https://www.googleapis.com/fusiontables/v1, unless otherwise noted
delete DELETE  /tables/tableId/templates/templateId Deletes a template.
get GET  /tables/tableId/templates/templateId Retrieves a specific template by its ID.
insert POST  /tables/tableId/templates Creates a new template for the table.
list GET  /tables/tableId/templates Retrieves a list of templates for a given table.
patch PATCH  /tables/tableId/templates/templateId Updates an existing template. This method supports patch semantics.
update PUT  /tables/tableId/templates/templateId Updates an existing template.

Style

For Style Resource details, see the resource representation page.

Method HTTP request Description
URIs relative to https://www.googleapis.com/fusiontables/v1, unless otherwise noted
delete DELETE  /tables/tableId/styles/styleId Deletes a style.
get GET  /tables/tableId/styles/styleId Gets a specific style from a given table.
insert POST  /tables/tableId/styles Adds a new style for the table.
list GET  /tables/tableId/styles Retrieves a list of styles from a given table.
patch PATCH  /tables/tableId/styles/styleId Updates an existing style. This method supports patch semantics.
update PUT  /tables/tableId/styles/styleId Updates an existing style.

Query

For Query Resource details, see the resource representation page.

Method HTTP request Description
URIs relative to https://www.googleapis.com/fusiontables/v1, unless otherwise noted
sql POST  /query Executes an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement.

Required query parameters: sql

sqlGet GET  /query Executes an SQL SELECT/SHOW/DESCRIBE statement.

Required query parameters: sql

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.