1 API Parameters
_
2 Resources
2.1 table
fusiontables-table-list
fusiontables-table-get
fusiontables-table-insert
fusiontables-table-patch
fusiontables-table-copy
fusiontables-table-delete
fusiontables-table-update
2.2 import
fusiontables-import-insert
2.3 query
fusiontables-query-sql
fusiontables-query-sql Get
2.4 template
fusiontables-template-list
fusiontables-template-get
fusiontables-template-insert
fusiontables-template-patch
fusiontables-template-delete
fusiontables-template-update
2.5 column
fusiontables-column-list
fusiontables-column-get
fusiontables-column-insert
fusiontables-column-patch
fusiontables-column-delete
fusiontables-column-update
2.6 style
fusiontables-style-list
fusiontables-style-get
fusiontables-style-insert
fusiontables-style-patch
fusiontables-style-delete
fusiontables-style-update
Version: 5.3

Fusion Tables API v1

This documentation has been automatically generated using information supplied by the Google API Discovery service.

API for working with Fusion Tables data. Google documentation.

    1 API Parameters

    2 Resources

      2.1 table

      2.2 import

      2.3 query

      2.4 template

      2.5 column

      2.6 style

(require-gapi-doc fusiontables.v1.js)

1 API Parameters

The following optional keyword arguments may be passed to all functions for this web service:

procedure

(_ [#:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A

This is not actually a function. This is just using Scribble’s defproc form to list the optional keyword arguments that may be passed to all functions for this service.

alt: Data format for the response.

fields: Selector specifying which fields to include in a partial response.

key: API key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.

oauth_token: OAuth 2.0 token for the current user.

prettyPrint: Returns response with indentations and line breaks.

quotaUser: Available to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters. Overrides userIp if both are provided.

userIp: IP address of the site where the request originates. Use this if you want to enforce per-user limits.

2 Resources

2.1 table

procedure

(fusiontables-table-list [#:maxResults maxResults    
  #:pageToken pageToken    
  #:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  maxResults : string? = 'N/A
  pageToken : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Retrieves a list of tables a user owns.

maxResults: Maximum number of styles to return. Optional. Default is 5.

pageToken: Continuation token specifying which result page to return. Optional.

procedure

(fusiontables-table-get #:tableId tableId    
  [#:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  tableId : string?
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Retrieves a specific table by its id.

tableId: Identifier(ID) for the table being requested.

procedure

(fusiontables-table-insert [#:name name 
  #:description description 
  #:kind kind 
  #:columns columns 
  #:tableId tableId 
  #:attribution attribution 
  #:attributionLink attributionLink 
  #:baseTableIds baseTableIds 
  #:isExportable isExportable 
  #:sql sql 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  name : string? = 'N/A
  description : string? = 'N/A
  kind : string? = 'N/A
  columns : string? = 'N/A
  tableId : string? = 'N/A
  attribution : string? = 'N/A
  attributionLink : string? = 'N/A
  baseTableIds : string? = 'N/A
  isExportable : string? = 'N/A
  sql : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Creates a new table.

name: Name assigned to a table.

description: Optional description assigned to the table.

kind: Type name: a template for an individual table.

columns: Columns in the table.

tableId: Encrypted unique alphanumeric identifier for the table.

attribution: Optional attribution assigned to the table.

attributionLink: Optional link for attribution.

baseTableIds: Optional base table identifier if this table is a view or merged table.

isExportable: Variable for whether table is exportable.

sql: Optional sql that encodes the table definition for derived tables.

procedure

(fusiontables-table-patch 
  #:tableId tableId 
  [#:replaceViewDefinition replaceViewDefinition 
  #:name name 
  #:description description 
  #:kind kind 
  #:columns columns 
  #:attribution attribution 
  #:attributionLink attributionLink 
  #:baseTableIds baseTableIds 
  #:isExportable isExportable 
  #:sql sql 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  tableId : string?
  replaceViewDefinition : string? = 'N/A
  name : string? = 'N/A
  description : string? = 'N/A
  kind : string? = 'N/A
  columns : string? = 'N/A
  attribution : string? = 'N/A
  attributionLink : string? = 'N/A
  baseTableIds : string? = 'N/A
  isExportable : string? = 'N/A
  sql : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Updates an existing table. Unless explicitly requested, only the name, description, and attribution will be updated. This method supports patch semantics.

tableId: ID of the table that is being updated.

replaceViewDefinition: Should the view definition also be updated? The specified view definition replaces the existing one. Only a view can be updated with a new definition.

name: Name assigned to a table.

description: Optional description assigned to the table.

kind: Type name: a template for an individual table.

columns: Columns in the table.

attribution: Optional attribution assigned to the table.

attributionLink: Optional link for attribution.

baseTableIds: Optional base table identifier if this table is a view or merged table.

isExportable: Variable for whether table is exportable.

sql: Optional sql that encodes the table definition for derived tables.

procedure

(fusiontables-table-copy #:tableId tableId    
  [#:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  tableId : string?
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Copies a table.

tableId: ID of the table that is being copied.

procedure

(fusiontables-table-delete #:tableId tableId    
  [#:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  tableId : string?
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Deletes a table.

tableId: ID of the table that is being deleted.

procedure

(fusiontables-table-update 
  #:tableId tableId 
  [#:replaceViewDefinition replaceViewDefinition 
  #:name name 
  #:description description 
  #:kind kind 
  #:columns columns 
  #:attribution attribution 
  #:attributionLink attributionLink 
  #:baseTableIds baseTableIds 
  #:isExportable isExportable 
  #:sql sql 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  tableId : string?
  replaceViewDefinition : string? = 'N/A
  name : string? = 'N/A
  description : string? = 'N/A
  kind : string? = 'N/A
  columns : string? = 'N/A
  attribution : string? = 'N/A
  attributionLink : string? = 'N/A
  baseTableIds : string? = 'N/A
  isExportable : string? = 'N/A
  sql : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Updates an existing table. Unless explicitly requested, only the name, description, and attribution will be updated.

tableId: ID of the table that is being updated.

replaceViewDefinition: Should the view definition also be updated? The specified view definition replaces the existing one. Only a view can be updated with a new definition.

name: Name assigned to a table.

description: Optional description assigned to the table.

kind: Type name: a template for an individual table.

columns: Columns in the table.

attribution: Optional attribution assigned to the table.

attributionLink: Optional link for attribution.

baseTableIds: Optional base table identifier if this table is a view or merged table.

isExportable: Variable for whether table is exportable.

sql: Optional sql that encodes the table definition for derived tables.

2.2 import

procedure

(fusiontables-import-insert #:tableId tableId 
  [#:delimiter delimiter 
  #:encoding encoding 
  #:endLine endLine 
  #:isStrict isStrict 
  #:startLine startLine 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  tableId : string?
  delimiter : string? = 'N/A
  encoding : string? = 'N/A
  endLine : string? = 'N/A
  isStrict : string? = 'N/A
  startLine : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Import more rows into a table.

tableId: The table into which new rows are being imported.

delimiter: The delimiter used to separate cell values. Default is ’,’.

encoding: The encoding of the content. Default is UTF-8.

endLine: The index of the last line from which to start importing, exclusive. Thus, the number of imported lines is endLine - startLine. If this parameter is not provided, the file will be imported until the last line of the file. If endLine is negative, then it is equivalent to N + endLine, where N is the number of lines in the file.

isStrict: Whether the CSV will be parsed strictly or not. Default is true.

startLine: The index of the first line from which to start importing, inclusive. Default is 0.

2.3 query

procedure

(fusiontables-query-sql #:sql sql    
  [#:hdrs hdrs    
  #:typed typed    
  #:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  sql : string?
  hdrs : string? = 'N/A
  typed : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Executes an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement.

sql: An SQL SELECT/SHOW/DESCRIBE/INSERT/UPDATE/DELETE/CREATE statement.

hdrs: Should column names be included (in the first row)?. Default is true.

typed: Should typed values be returned in the (JSON) response – numbers for numeric values and parsed geometries for KML values? Default is true.

procedure

(fusiontables-query-sqlGet #:sql sql    
  [#:hdrs hdrs    
  #:typed typed    
  #:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  sql : string?
  hdrs : string? = 'N/A
  typed : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Executes an SQL SELECT/SHOW/DESCRIBE statement.

sql: An SQL SELECT/SHOW/DESCRIBE statement.

hdrs: Should column names be included (in the first row)?. Default is true.

typed: Should typed values be returned in the (JSON) response – numbers for numeric values and parsed geometries for KML values? Default is true.

2.4 template

procedure

(fusiontables-template-list #:tableId tableId 
  [#:maxResults maxResults 
  #:pageToken pageToken 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  tableId : string?
  maxResults : string? = 'N/A
  pageToken : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Retrieves a list of templates.

tableId: Identifier for the table whose templates are being requested

maxResults: Maximum number of templates to return. Optional. Default is 5.

pageToken: Continuation token specifying which results page to return. Optional.

procedure

(fusiontables-template-get #:tableId tableId    
  #:templateId templateId    
  [#:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  tableId : string?
  templateId : string?
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Retrieves a specific template by its id

tableId: Table to which the template belongs

templateId: Identifier for the template that is being requested

procedure

(fusiontables-template-insert 
  #:tableId tableId 
  [#:name name 
  #:body body 
  #:kind kind 
  #:isDefaultForTable isDefaultForTable 
  #:automaticColumnNames automaticColumnNames 
  #:templateId templateId 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  tableId : string?
  name : string? = 'N/A
  body : string? = 'N/A
  kind : string? = 'N/A
  isDefaultForTable : string? = 'N/A
  automaticColumnNames : string? = 'N/A
  templateId : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Creates a new template for the table.

tableId: Table for which a new template is being created

name: Optional name assigned to a template.

body: Body of the template. It contains HTML with {column_name} to insert values from a particular column. The body is sanitized to remove certain tags, e.g., script. Only one of body or automaticColumns can be specified.

kind: Type name: a template for the info window contents. The template can either include an HTML body or a list of columns from which the template is computed automatically.

isDefaultForTable: Is this the default template for the table.

automaticColumnNames: List of columns from which the template is to be automatically constructed. Only one of body or automaticColumns can be specified.

templateId: Identifier for the template, unique within the context of a particular table.

procedure

(fusiontables-template-patch 
  #:tableId tableId 
  #:templateId templateId 
  [#:name name 
  #:body body 
  #:kind kind 
  #:isDefaultForTable isDefaultForTable 
  #:automaticColumnNames automaticColumnNames 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  tableId : string?
  templateId : string?
  name : string? = 'N/A
  body : string? = 'N/A
  kind : string? = 'N/A
  isDefaultForTable : string? = 'N/A
  automaticColumnNames : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Updates an existing template. This method supports patch semantics.

tableId: Table to which the updated template belongs

templateId: Identifier for the template that is being updated

name: Optional name assigned to a template.

body: Body of the template. It contains HTML with {column_name} to insert values from a particular column. The body is sanitized to remove certain tags, e.g., script. Only one of body or automaticColumns can be specified.

kind: Type name: a template for the info window contents. The template can either include an HTML body or a list of columns from which the template is computed automatically.

isDefaultForTable: Is this the default template for the table.

automaticColumnNames: List of columns from which the template is to be automatically constructed. Only one of body or automaticColumns can be specified.

procedure

(fusiontables-template-delete #:tableId tableId 
  #:templateId templateId 
  [#:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  tableId : string?
  templateId : string?
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Deletes a template

tableId: Table from which the template is being deleted

templateId: Identifier for the template which is being deleted

procedure

(fusiontables-template-update 
  #:tableId tableId 
  #:templateId templateId 
  [#:name name 
  #:body body 
  #:kind kind 
  #:isDefaultForTable isDefaultForTable 
  #:automaticColumnNames automaticColumnNames 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  tableId : string?
  templateId : string?
  name : string? = 'N/A
  body : string? = 'N/A
  kind : string? = 'N/A
  isDefaultForTable : string? = 'N/A
  automaticColumnNames : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Updates an existing template

tableId: Table to which the updated template belongs

templateId: Identifier for the template that is being updated

name: Optional name assigned to a template.

body: Body of the template. It contains HTML with {column_name} to insert values from a particular column. The body is sanitized to remove certain tags, e.g., script. Only one of body or automaticColumns can be specified.

kind: Type name: a template for the info window contents. The template can either include an HTML body or a list of columns from which the template is computed automatically.

isDefaultForTable: Is this the default template for the table.

automaticColumnNames: List of columns from which the template is to be automatically constructed. Only one of body or automaticColumns can be specified.

2.5 column

procedure

(fusiontables-column-list #:tableId tableId    
  [#:maxResults maxResults    
  #:pageToken pageToken    
  #:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  tableId : string?
  maxResults : string? = 'N/A
  pageToken : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Retrieves a list of columns.

tableId: Table whose columns are being listed.

maxResults: Maximum number of columns to return. Optional. Default is 5.

pageToken: Continuation token specifying which result page to return. Optional.

procedure

(fusiontables-column-get #:columnId columnId    
  #:tableId tableId    
  [#:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  columnId : string?
  tableId : string?
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Retrieves a specific column by its id.

columnId: Name or identifier for the column that is being requested.

tableId: Table to which the column belongs.

procedure

(fusiontables-column-insert #:tableId tableId 
  [#:name name 
  #:type type 
  #:kind kind 
  #:columnId columnId 
  #:baseColumn baseColumn 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  tableId : string?
  name : string? = 'N/A
  type : string? = 'N/A
  kind : string? = 'N/A
  columnId : string? = 'N/A
  baseColumn : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Adds a new column to the table.

tableId: Table for which a new column is being added.

name: Required name of the column.

type: Required type of the column.

kind: Type name: a template for an individual column.

columnId: Identifier for the column.

baseColumn: Optional identifier of the base column. If present, this column is derived from the specified base column.

procedure

(fusiontables-column-patch #:columnId columnId    
  #:tableId tableId    
  [#:name name    
  #:type type    
  #:kind kind    
  #:baseColumn baseColumn    
  #:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  columnId : string?
  tableId : string?
  name : string? = 'N/A
  type : string? = 'N/A
  kind : string? = 'N/A
  baseColumn : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Updates the name or type of an existing column. This method supports patch semantics.

columnId: Name or identifier for the column that is being updated.

tableId: Table for which the column is being updated.

name: Required name of the column.

type: Required type of the column.

kind: Type name: a template for an individual column.

baseColumn: Optional identifier of the base column. If present, this column is derived from the specified base column.

procedure

(fusiontables-column-delete #:columnId columnId 
  #:tableId tableId 
  [#:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  columnId : string?
  tableId : string?
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Deletes the column.

columnId: Name or identifier for the column being deleted.

tableId: Table from which the column is being deleted.

procedure

(fusiontables-column-update #:columnId columnId 
  #:tableId tableId 
  [#:name name 
  #:type type 
  #:kind kind 
  #:baseColumn baseColumn 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  columnId : string?
  tableId : string?
  name : string? = 'N/A
  type : string? = 'N/A
  kind : string? = 'N/A
  baseColumn : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Updates the name or type of an existing column.

columnId: Name or identifier for the column that is being updated.

tableId: Table for which the column is being updated.

name: Required name of the column.

type: Required type of the column.

kind: Type name: a template for an individual column.

baseColumn: Optional identifier of the base column. If present, this column is derived from the specified base column.

2.6 style

procedure

(fusiontables-style-list #:tableId tableId    
  [#:maxResults maxResults    
  #:pageToken pageToken    
  #:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  tableId : string?
  maxResults : string? = 'N/A
  pageToken : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Retrieves a list of styles.

tableId: Table whose styles are being listed

maxResults: Maximum number of styles to return. Optional. Default is 5.

pageToken: Continuation token specifying which result page to return. Optional.

procedure

(fusiontables-style-get #:styleId styleId    
  #:tableId tableId    
  [#:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  styleId : string?
  tableId : string?
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Gets a specific style.

styleId: Identifier (integer) for a specific style in a table

tableId: Table to which the requested style belongs

procedure

(fusiontables-style-insert 
  #:tableId tableId 
  [#:name name 
  #:kind kind 
  #:isDefaultForTable isDefaultForTable 
  #:markerOptions markerOptions 
  #:polygonOptions polygonOptions 
  #:polylineOptions polylineOptions 
  #:styleId styleId 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  tableId : string?
  name : string? = 'N/A
  kind : string? = 'N/A
  isDefaultForTable : string? = 'N/A
  markerOptions : string? = 'N/A
  polygonOptions : string? = 'N/A
  polylineOptions : string? = 'N/A
  styleId : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Adds a new style for the table.

tableId: Table for which a new style is being added

name: Optional name for the style setting.

kind: Type name: an individual style setting. A StyleSetting contains the style defintions for points, lines, and polygons in a table. Since a table can have any one or all of them, a style definition can have point, line and polygon style definitions.

isDefaultForTable: Is this the default style for the table.

markerOptions: Style definition for points in the table.

polygonOptions: Style definition for polygons in the table.

polylineOptions: Style definition for lines in the table.

styleId: Identifier for the style setting (unique only within tables).

procedure

(fusiontables-style-patch 
  #:styleId styleId 
  #:tableId tableId 
  [#:name name 
  #:kind kind 
  #:isDefaultForTable isDefaultForTable 
  #:markerOptions markerOptions 
  #:polygonOptions polygonOptions 
  #:polylineOptions polylineOptions 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  styleId : string?
  tableId : string?
  name : string? = 'N/A
  kind : string? = 'N/A
  isDefaultForTable : string? = 'N/A
  markerOptions : string? = 'N/A
  polygonOptions : string? = 'N/A
  polylineOptions : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Updates an existing style. This method supports patch semantics.

styleId: Identifier (within a table) for the style being updated.

tableId: Table whose style is being updated.

name: Optional name for the style setting.

kind: Type name: an individual style setting. A StyleSetting contains the style defintions for points, lines, and polygons in a table. Since a table can have any one or all of them, a style definition can have point, line and polygon style definitions.

isDefaultForTable: Is this the default style for the table.

markerOptions: Style definition for points in the table.

polygonOptions: Style definition for polygons in the table.

polylineOptions: Style definition for lines in the table.

procedure

(fusiontables-style-delete #:styleId styleId    
  #:tableId tableId    
  [#:alt alt    
  #:fields fields    
  #:key key    
  #:oauth_token oauth_token    
  #:prettyPrint prettyPrint    
  #:quotaUser quotaUser    
  #:userIp userIp])  jsexpr?
  styleId : string?
  tableId : string?
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Deletes a style.

styleId: Identifier (within a table) for the style being deleted

tableId: Table from which the style is being deleted

procedure

(fusiontables-style-update 
  #:styleId styleId 
  #:tableId tableId 
  [#:name name 
  #:kind kind 
  #:isDefaultForTable isDefaultForTable 
  #:markerOptions markerOptions 
  #:polygonOptions polygonOptions 
  #:polylineOptions polylineOptions 
  #:alt alt 
  #:fields fields 
  #:key key 
  #:oauth_token oauth_token 
  #:prettyPrint prettyPrint 
  #:quotaUser quotaUser 
  #:userIp userIp]) 
  jsexpr?
  styleId : string?
  tableId : string?
  name : string? = 'N/A
  kind : string? = 'N/A
  isDefaultForTable : string? = 'N/A
  markerOptions : string? = 'N/A
  polygonOptions : string? = 'N/A
  polylineOptions : string? = 'N/A
  alt : string? = 'N/A
  fields : string? = 'N/A
  key : string? = (api-key)
  oauth_token : string? = 'N/A
  prettyPrint : string? = 'N/A
  quotaUser : string? = 'N/A
  userIp : string? = 'N/A
Updates an existing style.

styleId: Identifier (within a table) for the style being updated.

tableId: Table whose style is being updated.

name: Optional name for the style setting.

kind: Type name: an individual style setting. A StyleSetting contains the style defintions for points, lines, and polygons in a table. Since a table can have any one or all of them, a style definition can have point, line and polygon style definitions.

isDefaultForTable: Is this the default style for the table.

markerOptions: Style definition for points in the table.

polygonOptions: Style definition for polygons in the table.

polylineOptions: Style definition for lines in the table.