List

Retrieves a list of tables a user owns

2 variables
30 variables

Retrieves a list of tables a user owns

Authorization

To use this building block you will have to grant access to at least one of the following scopes:

  • Manage your Fusion Tables
  • View your Fusion Tables

Input

This building block consumes 2 input parameters

  = Parameter name
  = Format

maxResults INTEGER

Maximum number of tables to return. Default is 5

pageToken STRING

Continuation token specifying which result page to return

Output

This building block provides 30 output parameters

  = Parameter name
  = Format

items[] OBJECT

Represents a table

items[].attribution STRING

Attribution assigned to the table

items[].attributionLink STRING

Optional link for attribution

items[].baseTableIds[] STRING

items[].columnPropertiesJsonSchema STRING

Default JSON schema for validating all JSON column properties

items[].columns[] OBJECT

Specifies the details of a column in a table

items[].columns[].baseColumn OBJECT

Identifier of the base column. If present, this column is derived from the specified base column

items[].columns[].baseColumn.columnId INTEGER

The id of the column in the base table from which this column is derived

items[].columns[].baseColumn.tableIndex INTEGER

Offset to the entry in the list of base tables in the table definition

items[].columns[].columnId INTEGER

Identifier for the column

items[].columns[].columnJsonSchema STRING

JSON schema for interpreting JSON in this column

items[].columns[].columnPropertiesJson STRING

JSON object containing custom column properties

items[].columns[].description STRING

Column description

items[].columns[].formatPattern STRING

Format pattern. Acceptable values are DT_DATE_MEDIUMe.g Dec 24, 2008 DT_DATE_SHORTfor example 12/24/08 DT_DATE_TIME_MEDIUMfor example Dec 24, 2008 8:30:45 PM DT_DATE_TIME_SHORTfor example 12/24/08 8:30 PM DT_DAY_MONTH_2_DIGIT_YEARfor example 24/12/08 DT_DAY_MONTH_2_DIGIT_YEAR_TIMEfor example 24/12/08 20:30 DT_DAY_MONTH_2_DIGIT_YEAR_TIME_MERIDIANfor example 24/12/08 8:30 PM DT_DAY_MONTH_4_DIGIT_YEARfor example 24/12/2008 DT_DAY_MONTH_4_DIGIT_YEAR_TIMEfor example 24/12/2008 20:30 DT_DAY_MONTH_4_DIGIT_YEAR_TIME_MERIDIANfor example 24/12/2008 8:30 PM DT_ISO_YEAR_MONTH_DAYfor example 2008-12-24 DT_ISO_YEAR_MONTH_DAY_TIMEfor example 2008-12-24 20:30:45 DT_MONTH_DAY_4_DIGIT_YEARfor example 12/24/2008 DT_TIME_LONGfor example 8:30:45 PM UTC-6 DT_TIME_MEDIUMfor example 8:30:45 PM DT_TIME_SHORTfor example 8:30 PM DT_YEAR_ONLYfor example 2008 HIGHLIGHT_UNTYPED_CELLSHighlight cell data that does not match the data type NONENo formatting (default) NUMBER_CURRENCYfor example $1234.56 NUMBER_DEFAULTfor example 1,234.56 NUMBER_INTEGERfor example 1235 NUMBER_NO_SEPARATORfor example 1234.56 NUMBER_PERCENTfor example 123,456% NUMBER_SCIENTIFICfor example 1E3 STRING_EIGHT_LINE_IMAGEDisplays thumbnail images as tall as eight lines of text STRING_FOUR_LINE_IMAGEDisplays thumbnail images as tall as four lines of text STRING_JSON_TEXTAllows editing of text as JSON in UI STRING_JSON_LISTAllows editing of text as a JSON list in UI STRING_LINKTreats cell as a link (must start with http:// or https://) STRING_ONE_LINE_IMAGEDisplays thumbnail images as tall as one line of text STRING_VIDEO_OR_MAPDisplay a video or map thumbnail

items[].columns[].graphPredicate STRING

Column graph predicate. Used to map table to graph data model (subject,predicate,object) See W3C Graph-based Data Model

items[].columns[].kind STRING

The kind of item this is. For a column, this is always fusiontables#column

items[].columns[].name STRING

Name of the column

items[].columns[].type STRING

Type of the column

items[].columns[].validValues[] STRING

items[].columns[].validateData BOOLEAN

If true, data entered via the web application is validated

items[].description STRING

Description assigned to the table

items[].isExportable BOOLEAN

Variable for whether table is exportable

items[].kind STRING

The kind of item this is. For a table, this is always fusiontables#table

items[].name STRING

Name assigned to a table

items[].sql STRING

SQL that encodes the table definition for derived tables

items[].tableId STRING

Encrypted unique alphanumeric identifier for the table

items[].tablePropertiesJson STRING

JSON object containing custom table properties

items[].tablePropertiesJsonSchema STRING

JSON schema for validating the JSON table properties

kind STRING

The kind of item this is. For table list, this is always fusiontables#tableList

nextPageToken STRING

Token used to access the next page of this result. No token is displayed if there are no more pages left