Fusion Tables API v1

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.

(require gapi/macro)

(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-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-insert [ #:columns columns
#:attribution attribution
#:attributionLink attributionLink
#:baseTableIds baseTableIds
#:isExportable isExportable
#:sql sql
#:name name
#:description description
#:kind kind
#:tableId tableId
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  columns : string? = 'N/A
  attribution : string? = 'N/A
  attributionLink : string? = 'N/A
  baseTableIds : string? = 'N/A
  isExportable : string? = 'N/A
  sql : string? = 'N/A
  name : string? = 'N/A
  description : string? = 'N/A
  kind : string? = 'N/A
  tableId : 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.

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.

description: Optional description assigned to the table.

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

tableId: Encrypted unique alphanumeric identifier for the table.

procedure
(fusiontables-table-patch
#:tableId tableId
[ #:replaceViewDefinition replaceViewDefinition
#:columns columns
#:attribution attribution
#:attributionLink attributionLink
#:baseTableIds baseTableIds
#:isExportable isExportable
#:sql sql
#:name name
#:description description
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  tableId : string?
  replaceViewDefinition : 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
  name : string? = 'N/A
  description : string? = 'N/A
  kind : 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.

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.

description: Optional description assigned to the table.

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

procedure
(fusiontables-table-update
#:tableId tableId
[ #:replaceViewDefinition replaceViewDefinition
#:columns columns
#:attribution attribution
#:attributionLink attributionLink
#:baseTableIds baseTableIds
#:isExportable isExportable
#:sql sql
#:name name
#:description description
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  tableId : string?
  replaceViewDefinition : 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
  name : string? = 'N/A
  description : string? = 'N/A
  kind : 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.

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.

description: Optional description assigned to the table.

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

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.

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 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 #:templateId templateId
#:tableId tableId
[ #:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp]) → jsexpr?
  templateId : 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 template by its id

templateId: Identifier for the template that is being requested

tableId: Table to which the template belongs

procedure
(fusiontables-template-insert
#:tableId tableId
[ #:isDefaultForTable isDefaultForTable
#:automaticColumnNames automaticColumnNames
#:templateId templateId
#:name name
#:body body
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  tableId : string?
  isDefaultForTable : string? = 'N/A
  automaticColumnNames : string? = 'N/A
  templateId : string? = 'N/A
  name : string? = 'N/A
  body : string? = 'N/A
  kind : 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

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.

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.

procedure
(fusiontables-template-patch
#:templateId templateId
#:tableId tableId
[ #:isDefaultForTable isDefaultForTable
#:automaticColumnNames automaticColumnNames
#:name name
#:body body
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  templateId : string?
  tableId : string?
  isDefaultForTable : string? = 'N/A
  automaticColumnNames : string? = 'N/A
  name : string? = 'N/A
  body : string? = 'N/A
  kind : 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.

templateId: Identifier for the template that is being updated

tableId: Table to which the updated template belongs

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.

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.

procedure
(fusiontables-template-update
#:templateId templateId
#:tableId tableId
[ #:isDefaultForTable isDefaultForTable
#:automaticColumnNames automaticColumnNames
#:name name
#:body body
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  templateId : string?
  tableId : string?
  isDefaultForTable : string? = 'N/A
  automaticColumnNames : string? = 'N/A
  name : string? = 'N/A
  body : string? = 'N/A
  kind : 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

templateId: Identifier for the template that is being updated

tableId: Table to which the updated template belongs

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.

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.

procedure
(fusiontables-template-delete #:templateId templateId
#:tableId tableId
[ #:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  templateId : 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 template

templateId: Identifier for the template which is being deleted

tableId: Table from which the template is being deleted

2.4 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
[ #:columnId columnId
#:baseColumn baseColumn
#:name name
#:type type
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  tableId : string?
  columnId : string? = 'N/A
  baseColumn : string? = 'N/A
  name : string? = 'N/A
  type : string? = 'N/A
  kind : 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.

columnId: Identifier for the column.

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

type: Required type of the column.

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

procedure
(fusiontables-column-patch #:columnId columnId
#:tableId tableId
[ #:baseColumn baseColumn
#:name name
#:type type
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp]) → jsexpr?
  columnId : string?
  tableId : string?
  baseColumn : string? = 'N/A
  name : string? = 'N/A
  type : string? = 'N/A
  kind : 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.

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

type: Required type of the column.

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

procedure
(fusiontables-column-update #:columnId columnId
#:tableId tableId
[ #:baseColumn baseColumn
#:name name
#:type type
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  columnId : string?
  tableId : string?
  baseColumn : string? = 'N/A
  name : string? = 'N/A
  type : string? = 'N/A
  kind : 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.

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

type: Required type of the column.

kind: Type name: a template for an individual 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.

2.5 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
[ #:isDefaultForTable isDefaultForTable
#:markerOptions markerOptions
#:polygonOptions polygonOptions
#:polylineOptions polylineOptions
#:styleId styleId
#:name name
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  tableId : string?
  isDefaultForTable : string? = 'N/A
  markerOptions : string? = 'N/A
  polygonOptions : string? = 'N/A
  polylineOptions : string? = 'N/A
  styleId : string? = 'N/A
  name : string? = 'N/A
  kind : 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

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

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.

procedure
(fusiontables-style-patch
#:styleId styleId
#:tableId tableId
[ #:isDefaultForTable isDefaultForTable
#:markerOptions markerOptions
#:polygonOptions polygonOptions
#:polylineOptions polylineOptions
#:name name
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  styleId : string?
  tableId : string?
  isDefaultForTable : string? = 'N/A
  markerOptions : string? = 'N/A
  polygonOptions : string? = 'N/A
  polylineOptions : string? = 'N/A
  name : string? = 'N/A
  kind : 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.

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-update
#:styleId styleId
#:tableId tableId
[ #:isDefaultForTable isDefaultForTable
#:markerOptions markerOptions
#:polygonOptions polygonOptions
#:polylineOptions polylineOptions
#:name name
#:kind kind
#:alt alt
#:fields fields
#:key key
#:oauth_token oauth_token
#:prettyPrint prettyPrint
#:quotaUser quotaUser
#:userIp userIp])
→ jsexpr?
  styleId : string?
  tableId : string?
  isDefaultForTable : string? = 'N/A
  markerOptions : string? = 'N/A
  polygonOptions : string? = 'N/A
  polylineOptions : string? = 'N/A
  name : string? = 'N/A
  kind : 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.

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

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