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.

Column: update

Requires authorization

Updates the name or type of an existing column. Try it now.


HTTP request



Parameter name Value Description
Path parameters
columnId string Identifier for the column to be updated.
tableId string Encrypted unique alphanumeric identifier for the table.


This request requires authorization with the following scope (read more about authentication and authorization).


Request body

In the request body, supply a Column resource with the following properties:

Property name Value Description Notes
Optional Properties
columnJsonSchema string JSON schema for interpreting JSON in this column. writable
columnPropertiesJson string JSON object containing custom column properties. writable
description string Column description. writable
graphPredicate string Column graph predicate.

Used to map table to graph data model (subject,predicate,object)

See W3C Graph-based Data Model.

name string Name of the column. writable
type string Required type of the column.

Acceptable values are:
  • "DATETIME": Date, time, or both.
  • "LOCATION": Place, address, latitude-longitude pair, or KML.
  • "NUMBER": Integer or decimal number.
  • "STRING":  The default type.


If successful, this method returns a Column resource in the response body.

Try it!

Use the APIs Explorer below to call this method on live data and see the response. Alternatively, try the standalone Explorer.