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

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": [
    string
  ],
  "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.

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

Methods


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