blob: 1c7319c186a96a4c3ee8ac527eab2233a95d1374 [file] [log] [blame]
Craig Citroe633be12015-03-02 13:40:36 -08001<html><body>
2<style>
3
4body, h1, h2, h3, div, span, p, pre, a {
5 margin: 0;
6 padding: 0;
7 border: 0;
8 font-weight: inherit;
9 font-style: inherit;
10 font-size: 100%;
11 font-family: inherit;
12 vertical-align: baseline;
13}
14
15body {
16 font-size: 13px;
17 padding: 1em;
18}
19
20h1 {
21 font-size: 26px;
22 margin-bottom: 1em;
23}
24
25h2 {
26 font-size: 24px;
27 margin-bottom: 1em;
28}
29
30h3 {
31 font-size: 20px;
32 margin-bottom: 1em;
33 margin-top: 1em;
34}
35
36pre, code {
37 line-height: 1.5;
38 font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace;
39}
40
41pre {
42 margin-top: 0.5em;
43}
44
45h1, h2, h3, p {
46 font-family: Arial, sans serif;
47}
48
49h1, h2, h3 {
50 border-bottom: solid #CCC 1px;
51}
52
53.toc_element {
54 margin-top: 0.5em;
55}
56
57.firstline {
58 margin-left: 2 em;
59}
60
61.method {
62 margin-top: 1em;
63 border: solid 1px #CCC;
64 padding: 1em;
65 background: #EEE;
66}
67
68.details {
69 font-weight: bold;
70 font-size: 14px;
71}
72
73</style>
74
75<h1><a href="fusiontables_v2.html">Fusion Tables API</a> . <a href="fusiontables_v2.column.html">column</a></h1>
76<h2>Instance Methods</h2>
77<p class="toc_element">
78 <code><a href="#delete">delete(tableId, columnId)</a></code></p>
Nathaniel Manista4f877e52015-06-15 16:44:50 +000079<p class="firstline">Deletes the specified column.</p>
Craig Citroe633be12015-03-02 13:40:36 -080080<p class="toc_element">
81 <code><a href="#get">get(tableId, columnId)</a></code></p>
Nathaniel Manista4f877e52015-06-15 16:44:50 +000082<p class="firstline">Retrieves a specific column by its ID.</p>
Craig Citroe633be12015-03-02 13:40:36 -080083<p class="toc_element">
84 <code><a href="#insert">insert(tableId, body)</a></code></p>
85<p class="firstline">Adds a new column to the table.</p>
86<p class="toc_element">
87 <code><a href="#list">list(tableId, pageToken=None, maxResults=None)</a></code></p>
88<p class="firstline">Retrieves a list of columns.</p>
89<p class="toc_element">
90 <code><a href="#list_next">list_next(previous_request, previous_response)</a></code></p>
91<p class="firstline">Retrieves the next page of results.</p>
92<p class="toc_element">
93 <code><a href="#patch">patch(tableId, columnId, body)</a></code></p>
94<p class="firstline">Updates the name or type of an existing column. This method supports patch semantics.</p>
95<p class="toc_element">
96 <code><a href="#update">update(tableId, columnId, body)</a></code></p>
97<p class="firstline">Updates the name or type of an existing column.</p>
98<h3>Method Details</h3>
99<div class="method">
100 <code class="details" id="delete">delete(tableId, columnId)</code>
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000101 <pre>Deletes the specified column.
Craig Citroe633be12015-03-02 13:40:36 -0800102
103Args:
104 tableId: string, Table from which the column is being deleted. (required)
105 columnId: string, Name or identifier for the column being deleted. (required)
106</pre>
107</div>
108
109<div class="method">
110 <code class="details" id="get">get(tableId, columnId)</code>
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000111 <pre>Retrieves a specific column by its ID.
Craig Citroe633be12015-03-02 13:40:36 -0800112
113Args:
114 tableId: string, Table to which the column belongs. (required)
115 columnId: string, Name or identifier for the column that is being requested. (required)
116
117Returns:
118 An object of the form:
119
120 { # Specifies the details of a column in a table.
121 "graphPredicate": "A String", # Column graph predicate.
122 # Used to map table to graph data model (subject,predicate,object)
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000123 # See W3C Graph-based Data Model.
124 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column.
Craig Citroe633be12015-03-02 13:40:36 -0800125 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
126 "A String",
127 ],
128 "description": "A String", # Column description.
129 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
130 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
131 "columnId": 42, # The id of the column in the base table from which this column is derived.
132 },
133 "name": "A String", # Name of the column.
134 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
135 "formatPattern": "A String", # Format pattern.
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000136 # 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 JSON editing of text 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
Craig Citroe633be12015-03-02 13:40:36 -0800137 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
138 "type": "A String", # Type of the column.
139 "validateData": True or False, # If true, data entered via the web application is validated.
140 "columnId": 42, # Identifier for the column.
141 }</pre>
142</div>
143
144<div class="method">
145 <code class="details" id="insert">insert(tableId, body)</code>
146 <pre>Adds a new column to the table.
147
148Args:
149 tableId: string, Table for which a new column is being added. (required)
150 body: object, The request body. (required)
151 The object takes the form of:
152
153{ # Specifies the details of a column in a table.
154 "graphPredicate": "A String", # Column graph predicate.
155 # Used to map table to graph data model (subject,predicate,object)
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000156 # See W3C Graph-based Data Model.
157 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column.
Craig Citroe633be12015-03-02 13:40:36 -0800158 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
159 "A String",
160 ],
161 "description": "A String", # Column description.
162 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
163 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
164 "columnId": 42, # The id of the column in the base table from which this column is derived.
165 },
166 "name": "A String", # Name of the column.
167 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
168 "formatPattern": "A String", # Format pattern.
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000169 # 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 JSON editing of text 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
Craig Citroe633be12015-03-02 13:40:36 -0800170 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
171 "type": "A String", # Type of the column.
172 "validateData": True or False, # If true, data entered via the web application is validated.
173 "columnId": 42, # Identifier for the column.
174 }
175
176
177Returns:
178 An object of the form:
179
180 { # Specifies the details of a column in a table.
181 "graphPredicate": "A String", # Column graph predicate.
182 # Used to map table to graph data model (subject,predicate,object)
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000183 # See W3C Graph-based Data Model.
184 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column.
Craig Citroe633be12015-03-02 13:40:36 -0800185 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
186 "A String",
187 ],
188 "description": "A String", # Column description.
189 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
190 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
191 "columnId": 42, # The id of the column in the base table from which this column is derived.
192 },
193 "name": "A String", # Name of the column.
194 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
195 "formatPattern": "A String", # Format pattern.
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000196 # 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 JSON editing of text 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
Craig Citroe633be12015-03-02 13:40:36 -0800197 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
198 "type": "A String", # Type of the column.
199 "validateData": True or False, # If true, data entered via the web application is validated.
200 "columnId": 42, # Identifier for the column.
201 }</pre>
202</div>
203
204<div class="method">
205 <code class="details" id="list">list(tableId, pageToken=None, maxResults=None)</code>
206 <pre>Retrieves a list of columns.
207
208Args:
209 tableId: string, Table whose columns are being listed. (required)
210 pageToken: string, Continuation token specifying which result page to return.
211 maxResults: integer, Maximum number of columns to return. Default is 5.
212
213Returns:
214 An object of the form:
215
216 { # Represents a list of columns in a table.
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000217 "nextPageToken": "A String", # Token used to access the next page of this result. No token is displayed if there are no more pages left.
Craig Citroe633be12015-03-02 13:40:36 -0800218 "items": [ # List of all requested columns.
219 { # Specifies the details of a column in a table.
220 "graphPredicate": "A String", # Column graph predicate.
221 # Used to map table to graph data model (subject,predicate,object)
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000222 # See W3C Graph-based Data Model.
223 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column.
Craig Citroe633be12015-03-02 13:40:36 -0800224 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
225 "A String",
226 ],
227 "description": "A String", # Column description.
228 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
229 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
230 "columnId": 42, # The id of the column in the base table from which this column is derived.
231 },
232 "name": "A String", # Name of the column.
233 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
234 "formatPattern": "A String", # Format pattern.
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000235 # 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 JSON editing of text 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
Craig Citroe633be12015-03-02 13:40:36 -0800236 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
237 "type": "A String", # Type of the column.
238 "validateData": True or False, # If true, data entered via the web application is validated.
239 "columnId": 42, # Identifier for the column.
240 },
241 ],
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000242 "kind": "fusiontables#columnList", # The kind of item this is. For a column list, this is always fusiontables#columnList.
Craig Citroe633be12015-03-02 13:40:36 -0800243 "totalItems": 42, # Total number of columns for the table.
244 }</pre>
245</div>
246
247<div class="method">
248 <code class="details" id="list_next">list_next(previous_request, previous_response)</code>
249 <pre>Retrieves the next page of results.
250
251Args:
252 previous_request: The request for the previous page. (required)
253 previous_response: The response from the request for the previous page. (required)
254
255Returns:
256 A request object that you can call 'execute()' on to request the next
257 page. Returns None if there are no more items in the collection.
258 </pre>
259</div>
260
261<div class="method">
262 <code class="details" id="patch">patch(tableId, columnId, body)</code>
263 <pre>Updates the name or type of an existing column. This method supports patch semantics.
264
265Args:
266 tableId: string, Table for which the column is being updated. (required)
267 columnId: string, Name or identifier for the column that is being updated. (required)
268 body: object, The request body. (required)
269 The object takes the form of:
270
271{ # Specifies the details of a column in a table.
272 "graphPredicate": "A String", # Column graph predicate.
273 # Used to map table to graph data model (subject,predicate,object)
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000274 # See W3C Graph-based Data Model.
275 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column.
Craig Citroe633be12015-03-02 13:40:36 -0800276 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
277 "A String",
278 ],
279 "description": "A String", # Column description.
280 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
281 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
282 "columnId": 42, # The id of the column in the base table from which this column is derived.
283 },
284 "name": "A String", # Name of the column.
285 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
286 "formatPattern": "A String", # Format pattern.
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000287 # 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 JSON editing of text 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
Craig Citroe633be12015-03-02 13:40:36 -0800288 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
289 "type": "A String", # Type of the column.
290 "validateData": True or False, # If true, data entered via the web application is validated.
291 "columnId": 42, # Identifier for the column.
292 }
293
294
295Returns:
296 An object of the form:
297
298 { # Specifies the details of a column in a table.
299 "graphPredicate": "A String", # Column graph predicate.
300 # Used to map table to graph data model (subject,predicate,object)
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000301 # See W3C Graph-based Data Model.
302 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column.
Craig Citroe633be12015-03-02 13:40:36 -0800303 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
304 "A String",
305 ],
306 "description": "A String", # Column description.
307 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
308 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
309 "columnId": 42, # The id of the column in the base table from which this column is derived.
310 },
311 "name": "A String", # Name of the column.
312 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
313 "formatPattern": "A String", # Format pattern.
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000314 # 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 JSON editing of text 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
Craig Citroe633be12015-03-02 13:40:36 -0800315 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
316 "type": "A String", # Type of the column.
317 "validateData": True or False, # If true, data entered via the web application is validated.
318 "columnId": 42, # Identifier for the column.
319 }</pre>
320</div>
321
322<div class="method">
323 <code class="details" id="update">update(tableId, columnId, body)</code>
324 <pre>Updates the name or type of an existing column.
325
326Args:
327 tableId: string, Table for which the column is being updated. (required)
328 columnId: string, Name or identifier for the column that is being updated. (required)
329 body: object, The request body. (required)
330 The object takes the form of:
331
332{ # Specifies the details of a column in a table.
333 "graphPredicate": "A String", # Column graph predicate.
334 # Used to map table to graph data model (subject,predicate,object)
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000335 # See W3C Graph-based Data Model.
336 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column.
Craig Citroe633be12015-03-02 13:40:36 -0800337 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
338 "A String",
339 ],
340 "description": "A String", # Column description.
341 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
342 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
343 "columnId": 42, # The id of the column in the base table from which this column is derived.
344 },
345 "name": "A String", # Name of the column.
346 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
347 "formatPattern": "A String", # Format pattern.
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000348 # 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 JSON editing of text 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
Craig Citroe633be12015-03-02 13:40:36 -0800349 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
350 "type": "A String", # Type of the column.
351 "validateData": True or False, # If true, data entered via the web application is validated.
352 "columnId": 42, # Identifier for the column.
353 }
354
355
356Returns:
357 An object of the form:
358
359 { # Specifies the details of a column in a table.
360 "graphPredicate": "A String", # Column graph predicate.
361 # Used to map table to graph data model (subject,predicate,object)
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000362 # See W3C Graph-based Data Model.
363 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column.
Craig Citroe633be12015-03-02 13:40:36 -0800364 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
365 "A String",
366 ],
367 "description": "A String", # Column description.
368 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
369 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
370 "columnId": 42, # The id of the column in the base table from which this column is derived.
371 },
372 "name": "A String", # Name of the column.
373 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
374 "formatPattern": "A String", # Format pattern.
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000375 # 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 JSON editing of text 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
Craig Citroe633be12015-03-02 13:40:36 -0800376 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
377 "type": "A String", # Type of the column.
378 "validateData": True or False, # If true, data entered via the web application is validated.
379 "columnId": 42, # Identifier for the column.
380 }</pre>
381</div>
382
383</body></html>