1 <html><body> 2 <style> 3 4 body, 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 15 body { 16 font-size: 13px; 17 padding: 1em; 18 } 19 20 h1 { 21 font-size: 26px; 22 margin-bottom: 1em; 23 } 24 25 h2 { 26 font-size: 24px; 27 margin-bottom: 1em; 28 } 29 30 h3 { 31 font-size: 20px; 32 margin-bottom: 1em; 33 margin-top: 1em; 34 } 35 36 pre, code { 37 line-height: 1.5; 38 font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace; 39 } 40 41 pre { 42 margin-top: 0.5em; 43 } 44 45 h1, h2, h3, p { 46 font-family: Arial, sans serif; 47 } 48 49 h1, 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> 79 <p class="firstline">Deletes the specified column.</p> 80 <p class="toc_element"> 81 <code><a href="#get">get(tableId, columnId)</a></code></p> 82 <p class="firstline">Retrieves a specific column by its ID.</p> 83 <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> 101 <pre>Deletes the specified column. 102 103 Args: 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> 111 <pre>Retrieves a specific column by its ID. 112 113 Args: 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 117 Returns: 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) 123 # See W3C Graph-based Data Model. 124 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. 125 "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. 136 # 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 137 "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 148 Args: 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) 156 # See W3C Graph-based Data Model. 157 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. 158 "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. 169 # 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 170 "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 177 Returns: 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) 183 # See W3C Graph-based Data Model. 184 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. 185 "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. 196 # 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 197 "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 208 Args: 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 213 Returns: 214 An object of the form: 215 216 { # Represents a list of columns in a table. 217 "nextPageToken": "A String", # Token used to access the next page of this result. No token is displayed if there are no more pages left. 218 "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) 222 # See W3C Graph-based Data Model. 223 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. 224 "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. 235 # 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 236 "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 ], 242 "kind": "fusiontables#columnList", # The kind of item this is. For a column list, this is always fusiontables#columnList. 243 "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 251 Args: 252 previous_request: The request for the previous page. (required) 253 previous_response: The response from the request for the previous page. (required) 254 255 Returns: 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 265 Args: 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) 274 # See W3C Graph-based Data Model. 275 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. 276 "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. 287 # 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 288 "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 295 Returns: 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) 301 # See W3C Graph-based Data Model. 302 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. 303 "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. 314 # 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 315 "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 326 Args: 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) 335 # See W3C Graph-based Data Model. 336 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. 337 "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. 348 # 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 349 "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 356 Returns: 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) 362 # See W3C Graph-based Data Model. 363 "kind": "fusiontables#column", # The kind of item this is. For a column, this is always fusiontables#column. 364 "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. 375 # 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 376 "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>
