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


Specifies the details of a column in a table.

For a list of methods for this resource, see the end of this page.

Resource representations

  "kind": "fusiontables#column",
  "columnId": integer,
  "name": string,
  "type": string,
  "description": string,
  "graphPredicate": string,
  "formatPattern": string,
  "validateData": boolean,
  "validValues": [
  "baseColumn": {
    "tableIndex": integer,
    "columnId": integer
  "columnPropertiesJson": string,
  "columnJsonSchema": string
Property name Value Description Notes
baseColumn object Identifier of the base column. If present, this column is derived from the specified base column.
baseColumn.columnId integer The ID of the column in the base table from which this column is derived.
baseColumn.tableIndex integer Offset to the entry in the list of base tables in the table definition.
columnId integer Identifier for the column.
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
formatPattern string Format pattern.

Acceptable values are:
  • "DT_DATE_MEDIUM": for example Dec 24, 2008
  • "DT_DATE_SHORT": for example 12/24/08
  • "DT_DATE_TIME_MEDIUM": for example Dec 24, 2008 8:30:45 PM
  • "DT_DATE_TIME_SHORT": for example 12/24/08 8:30 PM
  • "DT_DAY_MONTH_2_DIGIT_YEAR": for example 24/12/08
  • "DT_DAY_MONTH_2_DIGIT_YEAR_TIME": for example 24/12/08 20:30
  • "DT_DAY_MONTH_2_DIGIT_YEAR_TIME_MERIDIAN":  for example 24/12/08 8:30 PM
  • "DT_DAY_MONTH_4_DIGIT_YEAR": for example 24/12/2008
  • "DT_DAY_MONTH_4_DIGIT_YEAR_TIME": for example 24/12/2008 20:30
  • "DT_DAY_MONTH_4_DIGIT_YEAR_TIME_MERIDIAN": for example 24/12/2008 8:30 PM
  • "DT_ISO_YEAR_MONTH_DAY": for example 2008-12-24
  • "DT_ISO_YEAR_MONTH_DAY_TIME": for example 2008-12-24 20:30:45
  • "DT_MONTH_DAY_4_DIGIT_YEAR": for example 12/24/2008
  • "DT_TIME_LONG": for example 8:30:45 PM UTC-6
  • "DT_TIME_MEDIUM": for example 8:30:45 PM
  • "DT_TIME_SHORT": for example 8:30 PM
  • "DT_YEAR_ONLY": for example 2008
  • "HIGHLIGHT_UNTYPED_CELLS": Highlight cell data that does not match the data type
  • "NONE":  No formatting (default)
  • "NUMBER_CURRENCY": for example $1234.56
  • "NUMBER_DEFAULT":  for example 1,234.56
  • "NUMBER_INTEGER": for example 1235
  • "NUMBER_NO_SEPARATOR": for example 1234.56
  • "NUMBER_PERCENT": for example 123,456%
  • "NUMBER_SCIENTIFIC": for example 1E3
  • "STRING_EIGHT_LINE_IMAGE":  Displays thumbnail images as tall as eight lines of text
  • "STRING_FOUR_LINE_IMAGE":  Displays thumbnail images as tall as four lines of text
  • "STRING_JSON_TEXT": Allows JSON editing of text in UI
  • "STRING_LINK": Treats cell as a link (must start with http:// or https://)
  • "STRING_ONE_LINE_IMAGE":  Displays thumbnail images as tall as one line of text
  • "STRING_VIDEO_OR_MAP": Display a video or map thumbnail
graphPredicate string Column graph predicate.

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

See W3C Graph-based Data Model.

kind string The kind of item this is. For a column, this is always fusiontables#column.
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.
validValues[] list List of valid values used to validate data and supply a drop-down list of values in the web application.
validateData boolean If true, data entered via the web application is validated.


Deletes the specified column.
Retrieves the specified column's name and type.
Adds a new column to the table.
Retrieves a list of the specified table's columns.
Updates the name or type of an existing column. This method supports patch semantics.
Updates the name or type of an existing column.