List

Retrieves a list of columns

3 variables
18 variables

Retrieves a list of columns

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 3 input parameters

  = Parameter name
  = Format

tableId STRING Required

Table whose columns are being listed

maxResults INTEGER

Maximum number of columns to return. Default is 5

pageToken STRING

Continuation token specifying which result page to return

Output

This building block provides 18 output parameters

  = Parameter name
  = Format

items[] OBJECT

Specifies the details of a column in a table

items[].baseColumn OBJECT

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

items[].baseColumn.columnId INTEGER

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

items[].baseColumn.tableIndex INTEGER

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

items[].columnId INTEGER

Identifier for the column

items[].columnJsonSchema STRING

JSON schema for interpreting JSON in this column

items[].columnPropertiesJson STRING

JSON object containing custom column properties

items[].description STRING

Column description

items[].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[].graphPredicate STRING

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

items[].kind STRING

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

items[].name STRING

Name of the column

items[].type STRING

Type of the column

items[].validValues[] STRING

items[].validateData BOOLEAN

If true, data entered via the web application is validated

kind STRING

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

nextPageToken STRING

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

totalItems INTEGER

Total number of columns for the table