Fusion Tables API v1
This documentation has been automatically generated using information supplied by the Google API Discovery service.
1 API Parameters
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.
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
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
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
tableId: Identifier(ID) for the table being requested.
procedure
→ 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
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
→ 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
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
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
tableId: ID of the table that is being deleted.
procedure
→ 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
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
→ 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
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
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
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
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
→ 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
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
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
tableId: Table to which the template belongs
templateId: Identifier for the template that is being requested
procedure
→ 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
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
→ 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
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
→ 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
tableId: Table from which the template is being deleted
templateId: Identifier for the template which is being deleted
procedure
→ 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
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
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
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
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
columnId: Name or identifier for the column that is being requested.
tableId: Table to which the column belongs.
procedure
→ 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
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
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
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
columnId: Name or identifier for the column being deleted.
tableId: Table from which the column is being deleted.
procedure
→ 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
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
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
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
styleId: Identifier (integer) for a specific style in a table
tableId: Table to which the requested style belongs
procedure
→ 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
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
→ 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
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
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
styleId: Identifier (within a table) for the style being deleted
tableId: Table from which the style is being deleted
procedure
→ 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
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.