Gitiles
Code Review Sign In
gerrit-public.fairphone.software / platform / external / python / google-api-python-client / e633be11dbb412e5030b5afca31111fa4074dff1 / . / docs / dyn / fusiontables_v2.table.html
blob: 9be0397784778fd1570b0f5023faf8a6bcfdf36f [file] [log] [blame]
Craig Citroe633be12015-03-02 13:40:36 -0800[diff] [blame^]1<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.table.html">table</a></h1>
76<h2>Instance Methods</h2>
77<p class="toc_element">
78 <code><a href="#copy">copy(tableId, copyPresentation=None)</a></code></p>
79<p class="firstline">Copies a table.</p>
80<p class="toc_element">
81 <code><a href="#delete">delete(tableId)</a></code></p>
82<p class="firstline">Deletes a table.</p>
83<p class="toc_element">
84 <code><a href="#get">get(tableId)</a></code></p>
85<p class="firstline">Retrieves a specific table by its id.</p>
86<p class="toc_element">
87 <code><a href="#importRows">importRows(tableId, media_body=None, startLine=None, isStrict=None, encoding=None, delimiter=None, endLine=None)</a></code></p>
88<p class="firstline">Import more rows into a table.</p>
89<p class="toc_element">
90 <code><a href="#importTable">importTable(name, media_body=None, encoding=None, delimiter=None)</a></code></p>
91<p class="firstline">Import a new table.</p>
92<p class="toc_element">
93 <code><a href="#insert">insert(body)</a></code></p>
94<p class="firstline">Creates a new table.</p>
95<p class="toc_element">
96 <code><a href="#list">list(pageToken=None, maxResults=None)</a></code></p>
97<p class="firstline">Retrieves a list of tables a user owns.</p>
98<p class="toc_element">
99 <code><a href="#list_next">list_next(previous_request, previous_response)</a></code></p>
100<p class="firstline">Retrieves the next page of results.</p>
101<p class="toc_element">
102 <code><a href="#patch">patch(tableId, body, replaceViewDefinition=None)</a></code></p>
103<p class="firstline">Updates an existing table. Unless explicitly requested, only the name, description, and attribution will be updated. This method supports patch semantics.</p>
104<p class="toc_element">
105 <code><a href="#replaceRows">replaceRows(tableId, media_body=None, startLine=None, isStrict=None, encoding=None, delimiter=None, endLine=None)</a></code></p>
106<p class="firstline">Replaces rows of an existing table. Current rows remain visible until all replacement rows are ready.</p>
107<p class="toc_element">
108 <code><a href="#update">update(tableId, body, replaceViewDefinition=None)</a></code></p>
109<p class="firstline">Updates an existing table. Unless explicitly requested, only the name, description, and attribution will be updated.</p>
110<h3>Method Details</h3>
111<div class="method">
112 <code class="details" id="copy">copy(tableId, copyPresentation=None)</code>
113 <pre>Copies a table.
114
115Args:
116 tableId: string, ID of the table that is being copied. (required)
117 copyPresentation: boolean, Whether to also copy tabs, styles, and templates. Default is false.
118
119Returns:
120 An object of the form:
121
122 { # Represents a table.
123 "tablePropertiesJsonSchema": "A String", # JSON schema for validating the JSON table properties.
124 "kind": "fusiontables#table", # Type name: a template for an individual table.
125 "attribution": "A String", # Attribution assigned to the table.
126 "description": "A String", # Description assigned to the table.
127 "columnPropertiesJsonSchema": "A String", # Default JSON schema for validating all JSON column properties.
128 "isExportable": True or False, # Variable for whether table is exportable.
129 "baseTableIds": [ # Base table identifier if this table is a view or merged table.
130 "A String",
131 ],
132 "tablePropertiesJson": "A String", # JSON object containing custom table properties.
133 "attributionLink": "A String", # Optional link for attribution.
134 "sql": "A String", # SQL that encodes the table definition for derived tables.
135 "tableId": "A String", # Encrypted unique alphanumeric identifier for the table.
136 "columns": [ # Columns in the table.
137 { # Specifies the details of a column in a table.
138 "graphPredicate": "A String", # Column graph predicate.
139 # Used to map table to graph data model (subject,predicate,object)
140 # See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
141 "kind": "fusiontables#column", # Type name: a template for an individual column.
142 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
143 "A String",
144 ],
145 "description": "A String", # Column description.
146 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
147 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
148 "columnId": 42, # The id of the column in the base table from which this column is derived.
149 },
150 "name": "A String", # Name of the column.
151 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
152 "formatPattern": "A String", # Format pattern.
153 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
154 "type": "A String", # Type of the column.
155 "validateData": True or False, # If true, data entered via the web application is validated.
156 "columnId": 42, # Identifier for the column.
157 },
158 ],
159 "name": "A String", # Name assigned to a table.
160 }</pre>
161</div>
162
163<div class="method">
164 <code class="details" id="delete">delete(tableId)</code>
165 <pre>Deletes a table.
166
167Args:
168 tableId: string, ID of the table that is being deleted. (required)
169</pre>
170</div>
171
172<div class="method">
173 <code class="details" id="get">get(tableId)</code>
174 <pre>Retrieves a specific table by its id.
175
176Args:
177 tableId: string, Identifier(ID) for the table being requested. (required)
178
179Returns:
180 An object of the form:
181
182 { # Represents a table.
183 "tablePropertiesJsonSchema": "A String", # JSON schema for validating the JSON table properties.
184 "kind": "fusiontables#table", # Type name: a template for an individual table.
185 "attribution": "A String", # Attribution assigned to the table.
186 "description": "A String", # Description assigned to the table.
187 "columnPropertiesJsonSchema": "A String", # Default JSON schema for validating all JSON column properties.
188 "isExportable": True or False, # Variable for whether table is exportable.
189 "baseTableIds": [ # Base table identifier if this table is a view or merged table.
190 "A String",
191 ],
192 "tablePropertiesJson": "A String", # JSON object containing custom table properties.
193 "attributionLink": "A String", # Optional link for attribution.
194 "sql": "A String", # SQL that encodes the table definition for derived tables.
195 "tableId": "A String", # Encrypted unique alphanumeric identifier for the table.
196 "columns": [ # Columns in the table.
197 { # Specifies the details of a column in a table.
198 "graphPredicate": "A String", # Column graph predicate.
199 # Used to map table to graph data model (subject,predicate,object)
200 # See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
201 "kind": "fusiontables#column", # Type name: a template for an individual column.
202 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
203 "A String",
204 ],
205 "description": "A String", # Column description.
206 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
207 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
208 "columnId": 42, # The id of the column in the base table from which this column is derived.
209 },
210 "name": "A String", # Name of the column.
211 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
212 "formatPattern": "A String", # Format pattern.
213 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
214 "type": "A String", # Type of the column.
215 "validateData": True or False, # If true, data entered via the web application is validated.
216 "columnId": 42, # Identifier for the column.
217 },
218 ],
219 "name": "A String", # Name assigned to a table.
220 }</pre>
221</div>
222
223<div class="method">
224 <code class="details" id="importRows">importRows(tableId, media_body=None, startLine=None, isStrict=None, encoding=None, delimiter=None, endLine=None)</code>
225 <pre>Import more rows into a table.
226
227Args:
228 tableId: string, The table into which new rows are being imported. (required)
229 media_body: string, The filename of the media request body, or an instance of a MediaUpload object.
230 startLine: integer, The index of the first line from which to start importing, inclusive. Default is 0.
231 isStrict: boolean, Whether the CSV must have the same number of values for each row. If false, rows with fewer values will be padded with empty values. Default is true.
232 encoding: string, The encoding of the content. Default is UTF-8. Use 'auto-detect' if you are unsure of the encoding.
233 delimiter: string, The delimiter used to separate cell values. This can only consist of a single character. Default is ','.
234 endLine: integer, The index of the last line from which to start importing, exclusive. Thus, the number of imported lines is endLine - startLine. If this parameter is not provided, the file will be imported until the last line of the file. If endLine is negative, then the imported content will exclude the last endLine lines. That is, if endline is negative, no line will be imported whose index is greater than N + endLine where N is the number of lines in the file, and the number of imported lines will be N + endLine - startLine.
235
236Returns:
237 An object of the form:
238
239 { # Represents an import request.
240 "numRowsReceived": "A String", # The number of rows received from the import request.
241 "kind": "fusiontables#import", # Type name: a template for an import request.
242 }</pre>
243</div>
244
245<div class="method">
246 <code class="details" id="importTable">importTable(name, media_body=None, encoding=None, delimiter=None)</code>
247 <pre>Import a new table.
248
249Args:
250 name: string, The name to be assigned to the new table. (required)
251 media_body: string, The filename of the media request body, or an instance of a MediaUpload object.
252 encoding: string, The encoding of the content. Default is UTF-8. Use 'auto-detect' if you are unsure of the encoding.
253 delimiter: string, The delimiter used to separate cell values. This can only consist of a single character. Default is ','.
254
255Returns:
256 An object of the form:
257
258 { # Represents a table.
259 "tablePropertiesJsonSchema": "A String", # JSON schema for validating the JSON table properties.
260 "kind": "fusiontables#table", # Type name: a template for an individual table.
261 "attribution": "A String", # Attribution assigned to the table.
262 "description": "A String", # Description assigned to the table.
263 "columnPropertiesJsonSchema": "A String", # Default JSON schema for validating all JSON column properties.
264 "isExportable": True or False, # Variable for whether table is exportable.
265 "baseTableIds": [ # Base table identifier if this table is a view or merged table.
266 "A String",
267 ],
268 "tablePropertiesJson": "A String", # JSON object containing custom table properties.
269 "attributionLink": "A String", # Optional link for attribution.
270 "sql": "A String", # SQL that encodes the table definition for derived tables.
271 "tableId": "A String", # Encrypted unique alphanumeric identifier for the table.
272 "columns": [ # Columns in the table.
273 { # Specifies the details of a column in a table.
274 "graphPredicate": "A String", # Column graph predicate.
275 # Used to map table to graph data model (subject,predicate,object)
276 # See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
277 "kind": "fusiontables#column", # Type name: a template for an individual column.
278 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
279 "A String",
280 ],
281 "description": "A String", # Column description.
282 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
283 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
284 "columnId": 42, # The id of the column in the base table from which this column is derived.
285 },
286 "name": "A String", # Name of the column.
287 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
288 "formatPattern": "A String", # Format pattern.
289 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
290 "type": "A String", # Type of the column.
291 "validateData": True or False, # If true, data entered via the web application is validated.
292 "columnId": 42, # Identifier for the column.
293 },
294 ],
295 "name": "A String", # Name assigned to a table.
296 }</pre>
297</div>
298
299<div class="method">
300 <code class="details" id="insert">insert(body)</code>
301 <pre>Creates a new table.
302
303Args:
304 body: object, The request body. (required)
305 The object takes the form of:
306
307{ # Represents a table.
308 "tablePropertiesJsonSchema": "A String", # JSON schema for validating the JSON table properties.
309 "kind": "fusiontables#table", # Type name: a template for an individual table.
310 "attribution": "A String", # Attribution assigned to the table.
311 "description": "A String", # Description assigned to the table.
312 "columnPropertiesJsonSchema": "A String", # Default JSON schema for validating all JSON column properties.
313 "isExportable": True or False, # Variable for whether table is exportable.
314 "baseTableIds": [ # Base table identifier if this table is a view or merged table.
315 "A String",
316 ],
317 "tablePropertiesJson": "A String", # JSON object containing custom table properties.
318 "attributionLink": "A String", # Optional link for attribution.
319 "sql": "A String", # SQL that encodes the table definition for derived tables.
320 "tableId": "A String", # Encrypted unique alphanumeric identifier for the table.
321 "columns": [ # Columns in the table.
322 { # Specifies the details of a column in a table.
323 "graphPredicate": "A String", # Column graph predicate.
324 # Used to map table to graph data model (subject,predicate,object)
325 # See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
326 "kind": "fusiontables#column", # Type name: a template for an individual column.
327 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
328 "A String",
329 ],
330 "description": "A String", # Column description.
331 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
332 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
333 "columnId": 42, # The id of the column in the base table from which this column is derived.
334 },
335 "name": "A String", # Name of the column.
336 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
337 "formatPattern": "A String", # Format pattern.
338 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
339 "type": "A String", # Type of the column.
340 "validateData": True or False, # If true, data entered via the web application is validated.
341 "columnId": 42, # Identifier for the column.
342 },
343 ],
344 "name": "A String", # Name assigned to a table.
345 }
346
347
348Returns:
349 An object of the form:
350
351 { # Represents a table.
352 "tablePropertiesJsonSchema": "A String", # JSON schema for validating the JSON table properties.
353 "kind": "fusiontables#table", # Type name: a template for an individual table.
354 "attribution": "A String", # Attribution assigned to the table.
355 "description": "A String", # Description assigned to the table.
356 "columnPropertiesJsonSchema": "A String", # Default JSON schema for validating all JSON column properties.
357 "isExportable": True or False, # Variable for whether table is exportable.
358 "baseTableIds": [ # Base table identifier if this table is a view or merged table.
359 "A String",
360 ],
361 "tablePropertiesJson": "A String", # JSON object containing custom table properties.
362 "attributionLink": "A String", # Optional link for attribution.
363 "sql": "A String", # SQL that encodes the table definition for derived tables.
364 "tableId": "A String", # Encrypted unique alphanumeric identifier for the table.
365 "columns": [ # Columns in the table.
366 { # Specifies the details of a column in a table.
367 "graphPredicate": "A String", # Column graph predicate.
368 # Used to map table to graph data model (subject,predicate,object)
369 # See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
370 "kind": "fusiontables#column", # Type name: a template for an individual column.
371 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
372 "A String",
373 ],
374 "description": "A String", # Column description.
375 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
376 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
377 "columnId": 42, # The id of the column in the base table from which this column is derived.
378 },
379 "name": "A String", # Name of the column.
380 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
381 "formatPattern": "A String", # Format pattern.
382 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
383 "type": "A String", # Type of the column.
384 "validateData": True or False, # If true, data entered via the web application is validated.
385 "columnId": 42, # Identifier for the column.
386 },
387 ],
388 "name": "A String", # Name assigned to a table.
389 }</pre>
390</div>
391
392<div class="method">
393 <code class="details" id="list">list(pageToken=None, maxResults=None)</code>
394 <pre>Retrieves a list of tables a user owns.
395
396Args:
397 pageToken: string, Continuation token specifying which result page to return. Optional.
398 maxResults: integer, Maximum number of styles to return. Optional. Default is 5.
399
400Returns:
401 An object of the form:
402
403 { # Represents a list of tables.
404 "nextPageToken": "A String", # Token used to access the next page of this result. No token is displayed if there are no more tokens left.
405 "items": [ # List of all requested tables.
406 { # Represents a table.
407 "tablePropertiesJsonSchema": "A String", # JSON schema for validating the JSON table properties.
408 "kind": "fusiontables#table", # Type name: a template for an individual table.
409 "attribution": "A String", # Attribution assigned to the table.
410 "description": "A String", # Description assigned to the table.
411 "columnPropertiesJsonSchema": "A String", # Default JSON schema for validating all JSON column properties.
412 "isExportable": True or False, # Variable for whether table is exportable.
413 "baseTableIds": [ # Base table identifier if this table is a view or merged table.
414 "A String",
415 ],
416 "tablePropertiesJson": "A String", # JSON object containing custom table properties.
417 "attributionLink": "A String", # Optional link for attribution.
418 "sql": "A String", # SQL that encodes the table definition for derived tables.
419 "tableId": "A String", # Encrypted unique alphanumeric identifier for the table.
420 "columns": [ # Columns in the table.
421 { # Specifies the details of a column in a table.
422 "graphPredicate": "A String", # Column graph predicate.
423 # Used to map table to graph data model (subject,predicate,object)
424 # See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
425 "kind": "fusiontables#column", # Type name: a template for an individual column.
426 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
427 "A String",
428 ],
429 "description": "A String", # Column description.
430 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
431 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
432 "columnId": 42, # The id of the column in the base table from which this column is derived.
433 },
434 "name": "A String", # Name of the column.
435 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
436 "formatPattern": "A String", # Format pattern.
437 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
438 "type": "A String", # Type of the column.
439 "validateData": True or False, # If true, data entered via the web application is validated.
440 "columnId": 42, # Identifier for the column.
441 },
442 ],
443 "name": "A String", # Name assigned to a table.
444 },
445 ],
446 "kind": "fusiontables#tableList", # Type name: a list of all tables.
447 }</pre>
448</div>
449
450<div class="method">
451 <code class="details" id="list_next">list_next(previous_request, previous_response)</code>
452 <pre>Retrieves the next page of results.
453
454Args:
455 previous_request: The request for the previous page. (required)
456 previous_response: The response from the request for the previous page. (required)
457
458Returns:
459 A request object that you can call 'execute()' on to request the next
460 page. Returns None if there are no more items in the collection.
461 </pre>
462</div>
463
464<div class="method">
465 <code class="details" id="patch">patch(tableId, body, replaceViewDefinition=None)</code>
466 <pre>Updates an existing table. Unless explicitly requested, only the name, description, and attribution will be updated. This method supports patch semantics.
467
468Args:
469 tableId: string, ID of the table that is being updated. (required)
470 body: object, The request body. (required)
471 The object takes the form of:
472
473{ # Represents a table.
474 "tablePropertiesJsonSchema": "A String", # JSON schema for validating the JSON table properties.
475 "kind": "fusiontables#table", # Type name: a template for an individual table.
476 "attribution": "A String", # Attribution assigned to the table.
477 "description": "A String", # Description assigned to the table.
478 "columnPropertiesJsonSchema": "A String", # Default JSON schema for validating all JSON column properties.
479 "isExportable": True or False, # Variable for whether table is exportable.
480 "baseTableIds": [ # Base table identifier if this table is a view or merged table.
481 "A String",
482 ],
483 "tablePropertiesJson": "A String", # JSON object containing custom table properties.
484 "attributionLink": "A String", # Optional link for attribution.
485 "sql": "A String", # SQL that encodes the table definition for derived tables.
486 "tableId": "A String", # Encrypted unique alphanumeric identifier for the table.
487 "columns": [ # Columns in the table.
488 { # Specifies the details of a column in a table.
489 "graphPredicate": "A String", # Column graph predicate.
490 # Used to map table to graph data model (subject,predicate,object)
491 # See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
492 "kind": "fusiontables#column", # Type name: a template for an individual column.
493 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
494 "A String",
495 ],
496 "description": "A String", # Column description.
497 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
498 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
499 "columnId": 42, # The id of the column in the base table from which this column is derived.
500 },
501 "name": "A String", # Name of the column.
502 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
503 "formatPattern": "A String", # Format pattern.
504 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
505 "type": "A String", # Type of the column.
506 "validateData": True or False, # If true, data entered via the web application is validated.
507 "columnId": 42, # Identifier for the column.
508 },
509 ],
510 "name": "A String", # Name assigned to a table.
511 }
512
513 replaceViewDefinition: boolean, Should the view definition also be updated? The specified view definition replaces the existing one. Only a view can be updated with a new definition.
514
515Returns:
516 An object of the form:
517
518 { # Represents a table.
519 "tablePropertiesJsonSchema": "A String", # JSON schema for validating the JSON table properties.
520 "kind": "fusiontables#table", # Type name: a template for an individual table.
521 "attribution": "A String", # Attribution assigned to the table.
522 "description": "A String", # Description assigned to the table.
523 "columnPropertiesJsonSchema": "A String", # Default JSON schema for validating all JSON column properties.
524 "isExportable": True or False, # Variable for whether table is exportable.
525 "baseTableIds": [ # Base table identifier if this table is a view or merged table.
526 "A String",
527 ],
528 "tablePropertiesJson": "A String", # JSON object containing custom table properties.
529 "attributionLink": "A String", # Optional link for attribution.
530 "sql": "A String", # SQL that encodes the table definition for derived tables.
531 "tableId": "A String", # Encrypted unique alphanumeric identifier for the table.
532 "columns": [ # Columns in the table.
533 { # Specifies the details of a column in a table.
534 "graphPredicate": "A String", # Column graph predicate.
535 # Used to map table to graph data model (subject,predicate,object)
536 # See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
537 "kind": "fusiontables#column", # Type name: a template for an individual column.
538 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
539 "A String",
540 ],
541 "description": "A String", # Column description.
542 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
543 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
544 "columnId": 42, # The id of the column in the base table from which this column is derived.
545 },
546 "name": "A String", # Name of the column.
547 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
548 "formatPattern": "A String", # Format pattern.
549 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
550 "type": "A String", # Type of the column.
551 "validateData": True or False, # If true, data entered via the web application is validated.
552 "columnId": 42, # Identifier for the column.
553 },
554 ],
555 "name": "A String", # Name assigned to a table.
556 }</pre>
557</div>
558
559<div class="method">
560 <code class="details" id="replaceRows">replaceRows(tableId, media_body=None, startLine=None, isStrict=None, encoding=None, delimiter=None, endLine=None)</code>
561 <pre>Replaces rows of an existing table. Current rows remain visible until all replacement rows are ready.
562
563Args:
564 tableId: string, Table whose rows will be replaced. (required)
565 media_body: string, The filename of the media request body, or an instance of a MediaUpload object.
566 startLine: integer, The index of the first line from which to start importing, inclusive. Default is 0.
567 isStrict: boolean, Whether the CSV must have the same number of column values for each row. If true, throws an exception if the CSV does not not have the same number of columns. If false, rows with fewer column values will be padded with empty values. Default is true.
568 encoding: string, The encoding of the content. Default is UTF-8. Use 'auto-detect' if you are unsure of the encoding.
569 delimiter: string, The delimiter used to separate cell values. This can only consist of a single character. Default is ','.
570 endLine: integer, The index of the last line to import, exclusive. 'endLine - startLine' rows will be imported. Default is to import through the end of the file. If endLine is negative, it is an offset from the end of the file; the imported content will exclude the last endLine lines.
571
572Returns:
573 An object of the form:
574
575 { # A background task on a table, initiated for time and or resource consuming operations such as a column type change or delete all rows operation.
576 "started": True or False, # True if the task is in progress, its progress indicator will indicated where it is, and it can't be deleted.
577 "progress": "A String", # Task percentage completion.
578 "kind": "fusiontables#task", # Type name: a template for an individual task.
579 "type": "A String", # The type of task being executed in the background.
580 "taskId": "A String", # Identifier for the task.
581 }</pre>
582</div>
583
584<div class="method">
585 <code class="details" id="update">update(tableId, body, replaceViewDefinition=None)</code>
586 <pre>Updates an existing table. Unless explicitly requested, only the name, description, and attribution will be updated.
587
588Args:
589 tableId: string, ID of the table that is being updated. (required)
590 body: object, The request body. (required)
591 The object takes the form of:
592
593{ # Represents a table.
594 "tablePropertiesJsonSchema": "A String", # JSON schema for validating the JSON table properties.
595 "kind": "fusiontables#table", # Type name: a template for an individual table.
596 "attribution": "A String", # Attribution assigned to the table.
597 "description": "A String", # Description assigned to the table.
598 "columnPropertiesJsonSchema": "A String", # Default JSON schema for validating all JSON column properties.
599 "isExportable": True or False, # Variable for whether table is exportable.
600 "baseTableIds": [ # Base table identifier if this table is a view or merged table.
601 "A String",
602 ],
603 "tablePropertiesJson": "A String", # JSON object containing custom table properties.
604 "attributionLink": "A String", # Optional link for attribution.
605 "sql": "A String", # SQL that encodes the table definition for derived tables.
606 "tableId": "A String", # Encrypted unique alphanumeric identifier for the table.
607 "columns": [ # Columns in the table.
608 { # Specifies the details of a column in a table.
609 "graphPredicate": "A String", # Column graph predicate.
610 # Used to map table to graph data model (subject,predicate,object)
611 # See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
612 "kind": "fusiontables#column", # Type name: a template for an individual column.
613 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
614 "A String",
615 ],
616 "description": "A String", # Column description.
617 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
618 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
619 "columnId": 42, # The id of the column in the base table from which this column is derived.
620 },
621 "name": "A String", # Name of the column.
622 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
623 "formatPattern": "A String", # Format pattern.
624 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
625 "type": "A String", # Type of the column.
626 "validateData": True or False, # If true, data entered via the web application is validated.
627 "columnId": 42, # Identifier for the column.
628 },
629 ],
630 "name": "A String", # Name assigned to a table.
631 }
632
633 replaceViewDefinition: boolean, Should the view definition also be updated? The specified view definition replaces the existing one. Only a view can be updated with a new definition.
634
635Returns:
636 An object of the form:
637
638 { # Represents a table.
639 "tablePropertiesJsonSchema": "A String", # JSON schema for validating the JSON table properties.
640 "kind": "fusiontables#table", # Type name: a template for an individual table.
641 "attribution": "A String", # Attribution assigned to the table.
642 "description": "A String", # Description assigned to the table.
643 "columnPropertiesJsonSchema": "A String", # Default JSON schema for validating all JSON column properties.
644 "isExportable": True or False, # Variable for whether table is exportable.
645 "baseTableIds": [ # Base table identifier if this table is a view or merged table.
646 "A String",
647 ],
648 "tablePropertiesJson": "A String", # JSON object containing custom table properties.
649 "attributionLink": "A String", # Optional link for attribution.
650 "sql": "A String", # SQL that encodes the table definition for derived tables.
651 "tableId": "A String", # Encrypted unique alphanumeric identifier for the table.
652 "columns": [ # Columns in the table.
653 { # Specifies the details of a column in a table.
654 "graphPredicate": "A String", # Column graph predicate.
655 # Used to map table to graph data model (subject,predicate,object)
656 # See http://www.w3.org/TR/2014/REC-rdf11-concepts-20140225/#data-model
657 "kind": "fusiontables#column", # Type name: a template for an individual column.
658 "validValues": [ # List of valid values used to validate data and supply a drop-down list of values in the web application.
659 "A String",
660 ],
661 "description": "A String", # Column description.
662 "baseColumn": { # Identifier of the base column. If present, this column is derived from the specified base column.
663 "tableIndex": 42, # Offset to the entry in the list of base tables in the table definition.
664 "columnId": 42, # The id of the column in the base table from which this column is derived.
665 },
666 "name": "A String", # Name of the column.
667 "columnPropertiesJson": "A String", # JSON object containing custom column properties.
668 "formatPattern": "A String", # Format pattern.
669 "columnJsonSchema": "A String", # JSON schema for interpreting JSON in this column.
670 "type": "A String", # Type of the column.
671 "validateData": True or False, # If true, data entered via the web application is validated.
672 "columnId": 42, # Identifier for the column.
673 },
674 ],
675 "name": "A String", # Name assigned to a table.
676 }</pre>
677</div>
678
679</body></html>