You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
383 lines
29 KiB
383 lines
29 KiB
<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> |