| <html><body> |
| <style> |
| |
| body, h1, h2, h3, div, span, p, pre, a { |
| margin: 0; |
| padding: 0; |
| border: 0; |
| font-weight: inherit; |
| font-style: inherit; |
| font-size: 100%; |
| font-family: inherit; |
| vertical-align: baseline; |
| } |
| |
| body { |
| font-size: 13px; |
| padding: 1em; |
| } |
| |
| h1 { |
| font-size: 26px; |
| margin-bottom: 1em; |
| } |
| |
| h2 { |
| font-size: 24px; |
| margin-bottom: 1em; |
| } |
| |
| h3 { |
| font-size: 20px; |
| margin-bottom: 1em; |
| margin-top: 1em; |
| } |
| |
| pre, code { |
| line-height: 1.5; |
| font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace; |
| } |
| |
| pre { |
| margin-top: 0.5em; |
| } |
| |
| h1, h2, h3, p { |
| font-family: Arial, sans serif; |
| } |
| |
| h1, h2, h3 { |
| border-bottom: solid #CCC 1px; |
| } |
| |
| .toc_element { |
| margin-top: 0.5em; |
| } |
| |
| .firstline { |
| margin-left: 2 em; |
| } |
| |
| .method { |
| margin-top: 1em; |
| border: solid 1px #CCC; |
| padding: 1em; |
| background: #EEE; |
| } |
| |
| .details { |
| font-weight: bold; |
| font-size: 14px; |
| } |
| |
| </style> |
| |
| <h1><a href="fusiontables_v2.html">Fusion Tables API</a> . <a href="fusiontables_v2.column.html">column</a></h1> |
| <h2>Instance Methods</h2> |
| <p class="toc_element"> |
| <code><a href="#delete">delete(tableId, columnId)</a></code></p> |
| <p class="firstline">Deletes the specified column.</p> |
| <p class="toc_element"> |
| <code><a href="#get">get(tableId, columnId)</a></code></p> |
| <p class="firstline">Retrieves a specific column by its ID.</p> |
| <p class="toc_element"> |
| <code><a href="#insert">insert(tableId, body)</a></code></p> |
| <p class="firstline">Adds a new column to the table.</p> |
| <p class="toc_element"> |
| <code><a href="#list">list(tableId, pageToken=None, maxResults=None)</a></code></p> |
| <p class="firstline">Retrieves a list of columns.</p> |
| <p class="toc_element"> |
| <code><a href="#list_next">list_next(previous_request, previous_response)</a></code></p> |
| <p class="firstline">Retrieves the next page of results.</p> |
| <p class="toc_element"> |
| <code><a href="#patch">patch(tableId, columnId, body)</a></code></p> |
| <p class="firstline">Updates the name or type of an existing column. This method supports patch semantics.</p> |
| <p class="toc_element"> |
| <code><a href="#update">update(tableId, columnId, body)</a></code></p> |
| <p class="firstline">Updates the name or type of an existing column.</p> |
| <h3>Method Details</h3> |
| <div class="method"> |
| <code class="details" id="delete">delete(tableId, columnId)</code> |
| <pre>Deletes the specified column. |
| |
| Args: |
| tableId: string, Table from which the column is being deleted. (required) |
| columnId: string, Name or identifier for the column being deleted. (required) |
| </pre> |
| </div> |
| |
| <div class="method"> |
| <code class="details" id="get">get(tableId, columnId)</code> |
| <pre>Retrieves a specific column by its ID. |
| |
| Args: |
| tableId: string, Table to which the column belongs. (required) |
| columnId: string, Name or identifier for the column that is being requested. (required) |
| |
| Returns: |
| An object of the form: |
| |
| { # Specifies the details of a column in a table. |
| "graphPredicate": "A String", # Column graph predicate. |
| # Used to map table to graph data model (subject,predicate,object) |
| # See W3C Graph-based Data Model. |
| "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. |
| "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application. |
| "A String", |
| ], |
| "description": "A String", # Column description. |
| "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column. |
| "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition. |
| "columnId": 42, # The id of the column in the base table from which this column is derived. |
| }, |
| "name": "A String", # Name of the column. |
| "columnPropertiesJson": "A String", # JSON object containing custom column properties. |
| "formatPattern": "A 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 |
| "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column. |
| "type": "A String", # Type of the column. |
| "validateData": True or False, # If true, data entered via the web application is validated. |
| "columnId": 42, # Identifier for the column. |
| }</pre> |
| </div> |
| |
| <div class="method"> |
| <code class="details" id="insert">insert(tableId, body)</code> |
| <pre>Adds a new column to the table. |
| |
| Args: |
| tableId: string, Table for which a new column is being added. (required) |
| body: object, The request body. (required) |
| The object takes the form of: |
| |
| { # Specifies the details of a column in a table. |
| "graphPredicate": "A String", # Column graph predicate. |
| # Used to map table to graph data model (subject,predicate,object) |
| # See W3C Graph-based Data Model. |
| "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. |
| "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application. |
| "A String", |
| ], |
| "description": "A String", # Column description. |
| "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column. |
| "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition. |
| "columnId": 42, # The id of the column in the base table from which this column is derived. |
| }, |
| "name": "A String", # Name of the column. |
| "columnPropertiesJson": "A String", # JSON object containing custom column properties. |
| "formatPattern": "A 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 |
| "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column. |
| "type": "A String", # Type of the column. |
| "validateData": True or False, # If true, data entered via the web application is validated. |
| "columnId": 42, # Identifier for the column. |
| } |
| |
| |
| Returns: |
| An object of the form: |
| |
| { # Specifies the details of a column in a table. |
| "graphPredicate": "A String", # Column graph predicate. |
| # Used to map table to graph data model (subject,predicate,object) |
| # See W3C Graph-based Data Model. |
| "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. |
| "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application. |
| "A String", |
| ], |
| "description": "A String", # Column description. |
| "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column. |
| "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition. |
| "columnId": 42, # The id of the column in the base table from which this column is derived. |
| }, |
| "name": "A String", # Name of the column. |
| "columnPropertiesJson": "A String", # JSON object containing custom column properties. |
| "formatPattern": "A 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 |
| "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column. |
| "type": "A String", # Type of the column. |
| "validateData": True or False, # If true, data entered via the web application is validated. |
| "columnId": 42, # Identifier for the column. |
| }</pre> |
| </div> |
| |
| <div class="method"> |
| <code class="details" id="list">list(tableId, pageToken=None, maxResults=None)</code> |
| <pre>Retrieves a list of columns. |
| |
| Args: |
| tableId: string, Table whose columns are being listed. (required) |
| pageToken: string, Continuation token specifying which result page to return. |
| maxResults: integer, Maximum number of columns to return. Default is 5. |
| |
| Returns: |
| An object of the form: |
| |
| { # Represents a list of columns in a table. |
| "nextPageToken": "A String", # Token used to access the next page of this result. No token is displayed if there are no more pages left. |
| "items": [ # List of all requested columns. |
| { # Specifies the details of a column in a table. |
| "graphPredicate": "A String", # Column graph predicate. |
| # Used to map table to graph data model (subject,predicate,object) |
| # See W3C Graph-based Data Model. |
| "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. |
| "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application. |
| "A String", |
| ], |
| "description": "A String", # Column description. |
| "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column. |
| "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition. |
| "columnId": 42, # The id of the column in the base table from which this column is derived. |
| }, |
| "name": "A String", # Name of the column. |
| "columnPropertiesJson": "A String", # JSON object containing custom column properties. |
| "formatPattern": "A 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 |
| "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column. |
| "type": "A String", # Type of the column. |
| "validateData": True or False, # If true, data entered via the web application is validated. |
| "columnId": 42, # Identifier for the column. |
| }, |
| ], |
| "kind": "fusiontables#columnList", # The kind of item this is. For a column list, this is always fusiontables#columnList. |
| "totalItems": 42, # Total number of columns for the table. |
| }</pre> |
| </div> |
| |
| <div class="method"> |
| <code class="details" id="list_next">list_next(previous_request, previous_response)</code> |
| <pre>Retrieves the next page of results. |
| |
| Args: |
| previous_request: The request for the previous page. (required) |
| previous_response: The response from the request for the previous page. (required) |
| |
| Returns: |
| A request object that you can call 'execute()' on to request the next |
| page. Returns None if there are no more items in the collection. |
| </pre> |
| </div> |
| |
| <div class="method"> |
| <code class="details" id="patch">patch(tableId, columnId, body)</code> |
| <pre>Updates the name or type of an existing column. This method supports patch semantics. |
| |
| Args: |
| tableId: string, Table for which the column is being updated. (required) |
| columnId: string, Name or identifier for the column that is being updated. (required) |
| body: object, The request body. (required) |
| The object takes the form of: |
| |
| { # Specifies the details of a column in a table. |
| "graphPredicate": "A String", # Column graph predicate. |
| # Used to map table to graph data model (subject,predicate,object) |
| # See W3C Graph-based Data Model. |
| "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. |
| "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application. |
| "A String", |
| ], |
| "description": "A String", # Column description. |
| "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column. |
| "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition. |
| "columnId": 42, # The id of the column in the base table from which this column is derived. |
| }, |
| "name": "A String", # Name of the column. |
| "columnPropertiesJson": "A String", # JSON object containing custom column properties. |
| "formatPattern": "A 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 |
| "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column. |
| "type": "A String", # Type of the column. |
| "validateData": True or False, # If true, data entered via the web application is validated. |
| "columnId": 42, # Identifier for the column. |
| } |
| |
| |
| Returns: |
| An object of the form: |
| |
| { # Specifies the details of a column in a table. |
| "graphPredicate": "A String", # Column graph predicate. |
| # Used to map table to graph data model (subject,predicate,object) |
| # See W3C Graph-based Data Model. |
| "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. |
| "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application. |
| "A String", |
| ], |
| "description": "A String", # Column description. |
| "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column. |
| "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition. |
| "columnId": 42, # The id of the column in the base table from which this column is derived. |
| }, |
| "name": "A String", # Name of the column. |
| "columnPropertiesJson": "A String", # JSON object containing custom column properties. |
| "formatPattern": "A 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 |
| "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column. |
| "type": "A String", # Type of the column. |
| "validateData": True or False, # If true, data entered via the web application is validated. |
| "columnId": 42, # Identifier for the column. |
| }</pre> |
| </div> |
| |
| <div class="method"> |
| <code class="details" id="update">update(tableId, columnId, body)</code> |
| <pre>Updates the name or type of an existing column. |
| |
| Args: |
| tableId: string, Table for which the column is being updated. (required) |
| columnId: string, Name or identifier for the column that is being updated. (required) |
| body: object, The request body. (required) |
| The object takes the form of: |
| |
| { # Specifies the details of a column in a table. |
| "graphPredicate": "A String", # Column graph predicate. |
| # Used to map table to graph data model (subject,predicate,object) |
| # See W3C Graph-based Data Model. |
| "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. |
| "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application. |
| "A String", |
| ], |
| "description": "A String", # Column description. |
| "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column. |
| "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition. |
| "columnId": 42, # The id of the column in the base table from which this column is derived. |
| }, |
| "name": "A String", # Name of the column. |
| "columnPropertiesJson": "A String", # JSON object containing custom column properties. |
| "formatPattern": "A 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 |
| "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column. |
| "type": "A String", # Type of the column. |
| "validateData": True or False, # If true, data entered via the web application is validated. |
| "columnId": 42, # Identifier for the column. |
| } |
| |
| |
| Returns: |
| An object of the form: |
| |
| { # Specifies the details of a column in a table. |
| "graphPredicate": "A String", # Column graph predicate. |
| # Used to map table to graph data model (subject,predicate,object) |
| # See W3C Graph-based Data Model. |
| "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. |
| "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application. |
| "A String", |
| ], |
| "description": "A String", # Column description. |
| "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column. |
| "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition. |
| "columnId": 42, # The id of the column in the base table from which this column is derived. |
| }, |
| "name": "A String", # Name of the column. |
| "columnPropertiesJson": "A String", # JSON object containing custom column properties. |
| "formatPattern": "A 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 |
| "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column. |
| "type": "A String", # Type of the column. |
| "validateData": True or False, # If true, data entered via the web application is validated. |
| "columnId": 42, # Identifier for the column. |
| }</pre> |
| </div> |
| |
| </body></html> |