Fusion Tables API . column

Instance Methods

delete(tableId, columnId)

Deletes the column.

get(tableId, columnId)

Retrieves a specific column by its id.

insert(tableId, body)

Adds a new column to the table.

list(tableId, pageToken=None, maxResults=None)

Retrieves a list of columns.

list_next(previous_request, previous_response)

Retrieves the next page of results.

patch(tableId, columnId, body)

Updates the name or type of an existing column. This method supports patch semantics.

update(tableId, columnId, body)

Updates the name or type of an existing column.

Method Details

delete(tableId, columnId)
Deletes the column.

Args:
  tableId: string, Table from which the column is being deleted. (required)
  columnId: string, Name or identifier for the column being deleted. (required)
get(tableId, columnId)
Retrieves a specific column by its id.

Args:
  tableId: string, Table to which the column belongs. (required)
  columnId: string, Name or identifier for the column that is being requested. (required)

Returns:
  An object of the form:

    { # Specifies the id, name and type of a column in a table.
      "kind": "fusiontables#column", # Type name: a template for an individual column.
      "description": "A String", # Optional column description.
      "baseColumn": { # Optional identifier of the base column. If present, this column is derived from the specified base column.
        "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
        "columnId": 42, # The id of the column in the base table from which this column is derived.
      },
      "columnId": 42, # Identifier for the column.
      "graph_predicate": "A String", # Optional column predicate. Used to map table to graph data model (subject,predicate,object) See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
      "type": "A String", # Required type of the column.
      "name": "A String", # Required name of the column.
    }
insert(tableId, body)
Adds a new column to the table.

Args:
  tableId: string, Table for which a new column is being added. (required)
  body: object, The request body. (required)
    The object takes the form of:

{ # Specifies the id, name and type of a column in a table.
    "kind": "fusiontables#column", # Type name: a template for an individual column.
    "description": "A String", # Optional column description.
    "baseColumn": { # Optional identifier of the base column. If present, this column is derived from the specified base column.
      "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
      "columnId": 42, # The id of the column in the base table from which this column is derived.
    },
    "columnId": 42, # Identifier for the column.
    "graph_predicate": "A String", # Optional column predicate. Used to map table to graph data model (subject,predicate,object) See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
    "type": "A String", # Required type of the column.
    "name": "A String", # Required name of the column.
  }


Returns:
  An object of the form:

    { # Specifies the id, name and type of a column in a table.
      "kind": "fusiontables#column", # Type name: a template for an individual column.
      "description": "A String", # Optional column description.
      "baseColumn": { # Optional identifier of the base column. If present, this column is derived from the specified base column.
        "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
        "columnId": 42, # The id of the column in the base table from which this column is derived.
      },
      "columnId": 42, # Identifier for the column.
      "graph_predicate": "A String", # Optional column predicate. Used to map table to graph data model (subject,predicate,object) See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
      "type": "A String", # Required type of the column.
      "name": "A String", # Required name of the column.
    }
list(tableId, pageToken=None, maxResults=None)
Retrieves a list of columns.

Args:
  tableId: string, Table whose columns are being listed. (required)
  pageToken: string, Continuation token specifying which result page to return. Optional.
  maxResults: integer, Maximum number of columns to return. Optional. Default is 5.

Returns:
  An object of the form:

    { # Represents a list of columns in a table.
    "nextPageToken": "A String", # Token used to access the next page of this result. No token is displayed if there are no more pages left.
    "items": [ # List of all requested columns.
      { # Specifies the id, name and type of a column in a table.
          "kind": "fusiontables#column", # Type name: a template for an individual column.
          "description": "A String", # Optional column description.
          "baseColumn": { # Optional identifier of the base column. If present, this column is derived from the specified base column.
            "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
            "columnId": 42, # The id of the column in the base table from which this column is derived.
          },
          "columnId": 42, # Identifier for the column.
          "graph_predicate": "A String", # Optional column predicate. Used to map table to graph data model (subject,predicate,object) See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
          "type": "A String", # Required type of the column.
          "name": "A String", # Required name of the column.
        },
    ],
    "kind": "fusiontables#columnList", # Type name: a list of all columns.
    "totalItems": 42, # Total number of columns for the table.
  }
list_next(previous_request, previous_response)
Retrieves the next page of results.

Args:
  previous_request: The request for the previous page. (required)
  previous_response: The response from the request for the previous page. (required)

Returns:
  A request object that you can call 'execute()' on to request the next
  page. Returns None if there are no more items in the collection.
    
patch(tableId, columnId, body)
Updates the name or type of an existing column. This method supports patch semantics.

Args:
  tableId: string, Table for which the column is being updated. (required)
  columnId: string, Name or identifier for the column that is being updated. (required)
  body: object, The request body. (required)
    The object takes the form of:

{ # Specifies the id, name and type of a column in a table.
    "kind": "fusiontables#column", # Type name: a template for an individual column.
    "description": "A String", # Optional column description.
    "baseColumn": { # Optional identifier of the base column. If present, this column is derived from the specified base column.
      "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
      "columnId": 42, # The id of the column in the base table from which this column is derived.
    },
    "columnId": 42, # Identifier for the column.
    "graph_predicate": "A String", # Optional column predicate. Used to map table to graph data model (subject,predicate,object) See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
    "type": "A String", # Required type of the column.
    "name": "A String", # Required name of the column.
  }


Returns:
  An object of the form:

    { # Specifies the id, name and type of a column in a table.
      "kind": "fusiontables#column", # Type name: a template for an individual column.
      "description": "A String", # Optional column description.
      "baseColumn": { # Optional identifier of the base column. If present, this column is derived from the specified base column.
        "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
        "columnId": 42, # The id of the column in the base table from which this column is derived.
      },
      "columnId": 42, # Identifier for the column.
      "graph_predicate": "A String", # Optional column predicate. Used to map table to graph data model (subject,predicate,object) See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
      "type": "A String", # Required type of the column.
      "name": "A String", # Required name of the column.
    }
update(tableId, columnId, body)
Updates the name or type of an existing column.

Args:
  tableId: string, Table for which the column is being updated. (required)
  columnId: string, Name or identifier for the column that is being updated. (required)
  body: object, The request body. (required)
    The object takes the form of:

{ # Specifies the id, name and type of a column in a table.
    "kind": "fusiontables#column", # Type name: a template for an individual column.
    "description": "A String", # Optional column description.
    "baseColumn": { # Optional identifier of the base column. If present, this column is derived from the specified base column.
      "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
      "columnId": 42, # The id of the column in the base table from which this column is derived.
    },
    "columnId": 42, # Identifier for the column.
    "graph_predicate": "A String", # Optional column predicate. Used to map table to graph data model (subject,predicate,object) See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
    "type": "A String", # Required type of the column.
    "name": "A String", # Required name of the column.
  }


Returns:
  An object of the form:

    { # Specifies the id, name and type of a column in a table.
      "kind": "fusiontables#column", # Type name: a template for an individual column.
      "description": "A String", # Optional column description.
      "baseColumn": { # Optional identifier of the base column. If present, this column is derived from the specified base column.
        "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
        "columnId": 42, # The id of the column in the base table from which this column is derived.
      },
      "columnId": 42, # Identifier for the column.
      "graph_predicate": "A String", # Optional column predicate. Used to map table to graph data model (subject,predicate,object) See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
      "type": "A String", # Required type of the column.
      "name": "A String", # Required name of the column.
    }