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: insert

Requires authorization

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

Request

HTTP request

POST https://www.googleapis.com/fusiontables/v2/tables/tableId/columns

Parameters

Parameter name Value Description
Path parameters
tableId string Encrypted unique alphanumeric identifier for the table.

Authorization

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

Scope
https://www.googleapis.com/auth/fusiontables

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.
writable
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.

writable

Response

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.