The Google Fusion Tables API will not be available after Dec. 3, 2019. Learn more

Column: insert

Requires authorization

Adds a new column to the table. Try it now.


HTTP request



Parameter name Value Description
Path parameters
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
Required Properties
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.
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.



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.