Api-roll 40: 2016-08-08

discovery/googleapis/sheets__v4.json

Index: discovery/googleapis/sheets__v4.json
diff --git a/discovery/googleapis/sheets__v4.json b/discovery/googleapis/sheets__v4.json
index 4557e934df0aa07674286594623c678ee30d4cd9..df37d1bdf76217171427ac031c7a717ddc7baf40 100644
--- a/discovery/googleapis/sheets__v4.json
+++ b/discovery/googleapis/sheets__v4.json
@@ -211,6 +211,59 @@
             "resources": {
                 "values": {
                     "methods": {
+                        "append": {
+                            "description": "Appends values to a spreadsheet. The input range is used to search for\nexisting data and find a \"table\" within that range. Values will be\nappended to the next row of the table, starting with the first column of\nthe table. See the\n[guide](/sheets/guides/values#appending_values)\nand\n[sample code](/sheets/samples/writing#append_values)\nfor specific details of how tables are detected and data is appended.\n\nThe caller must specify the spreadsheet ID, range, and\na valueInputOption.  The `valueInputOption` only\ncontrols how the input data will be added to the sheet (column-wise or\nrow-wise), it does not influence what cell the data starts being written\nto.",
+                            "httpMethod": "POST",
+                            "id": "sheets.spreadsheets.values.append",
+                            "parameterOrder": [
+                                "spreadsheetId",
+                                "range"
+                            ],
+                            "parameters": {
+                                "valueInputOption": {
+                                    "description": "How the input data should be interpreted.",
+                                    "enum": [
+                                        "INPUT_VALUE_OPTION_UNSPECIFIED",
+                                        "RAW",
+                                        "USER_ENTERED"
+                                    ],
+                                    "location": "query",
+                                    "type": "string"
+                                },
+                                "spreadsheetId": {
+                                    "description": "The ID of the spreadsheet to update.",
+                                    "location": "path",
+                                    "required": true,
+                                    "type": "string"
+                                },
+                                "insertDataOption": {
+                                    "description": "How the input data should be inserted.",
+                                    "enum": [
+                                        "OVERWRITE",
+                                        "INSERT_ROWS"
+                                    ],
+                                    "location": "query",
+                                    "type": "string"
+                                },
+                                "range": {
+                                    "description": "The A1 notation of a range to search for a logical table of data.\nValues will be appended after the last row of the table.",
+                                    "location": "path",
+                                    "required": true,
+                                    "type": "string"
+                                }
+                            },
+                            "path": "v4/spreadsheets/{spreadsheetId}/values/{range}:append",
+                            "request": {
+                                "$ref": "ValueRange"
+                            },
+                            "response": {
+                                "$ref": "AppendValuesResponse"
+                            },
+                            "scopes": [
+                                "https://www.googleapis.com/auth/drive",
+                                "https://www.googleapis.com/auth/spreadsheets"
+                            ]
+                        },
                         "update": {
                             "description": "Sets values in a range of a spreadsheet.\nThe caller must specify the spreadsheet ID, range, and\na valueInputOption.",
                             "httpMethod": "PUT",
@@ -449,7 +502,7 @@
             }
         }
     },
-    "revision": "20160708",
+    "revision": "20160804",
     "rootUrl": "https://sheets.googleapis.com/",
     "schemas": {
         "AddNamedRangeResponse": {
@@ -469,7 +522,7 @@
             "properties": {
                 "protectedRange": {
                     "$ref": "ProtectedRange",
-                    "description": "The protected range to update with the new properties. If a nonzero\nprotectedRangeId is\nspecified, the protected range will use that ID. (It is an error to\nspecify the ID of a protected range that already exists.)"
+                    "description": "The protected range to update with the new properties."
                 },
                 "fields": {
                     "description": "The fields that should be updated.  At least one field must be specified.\nThe root `protectedRange` is implied and should not be specified.\nA single `\"*\"` can be used as short-hand for listing every field.",
@@ -1549,7 +1602,7 @@
             "properties": {
                 "properties": {
                     "$ref": "SheetProperties",
-                    "description": "The properties the new sheet should have.\nAll properties are optional.\nIf a sheetId\nis specified, the sheet will use that ID.\n(It is an error to specify the ID of a sheet that already exists.)"
+                    "description": "The properties the new sheet should have.\nAll properties are optional.\nThe sheetId field is optional; if one is not\nset, an id will be randomly generated. (It is an error to specify the ID\nof a sheet that already exists.)"
                 }
             },
             "type": "object"
@@ -1560,7 +1613,7 @@
             "properties": {
                 "protectedRange": {
                     "$ref": "ProtectedRange",
-                    "description": "The protected range to be added."
+                    "description": "The protected range to be added. The\nprotectedRangeId field is optional; if\none is not set, an id will be randomly generated. (It is an error to\nspecify the ID of a range that already exists.)"
                 }
             },
             "type": "object"
@@ -1580,7 +1633,7 @@
                     "type": "array"
                 },
                 "range": {
-                    "description": "The range the values cover, in A1 notation.\nFor output, this range indicates the entire requested range,\neven though the values will exclude trailing rows and columns.",
+                    "description": "The range the values cover, in A1 notation.\nFor output, this range indicates the entire requested range,\neven though the values will exclude trailing rows and columns.\nWhen appending values, this field represents the range to search for a\ntable, after which values will be appended.",
                     "type": "string"
                 },
                 "majorDimension": {
@@ -1632,6 +1685,25 @@
             },
             "type": "object"
         },
+        "AppendValuesResponse": {
+            "description": "The response when updating a range of values in a spreadsheet.",
+            "id": "AppendValuesResponse",
+            "properties": {
+                "spreadsheetId": {
+                    "description": "The spreadsheet the updates were applied to.",
+                    "type": "string"
+                },
+                "tableRange": {
+                    "description": "The range (in A1 notation) of the table that values are being appended to\n(before the values were appended).\nEmpty if no table was found.",
+                    "type": "string"
+                },
+                "updates": {
+                    "$ref": "UpdateValuesResponse",
+                    "description": "Information about the updates that were applied."
+                }
+            },
+            "type": "object"
+        },
         "CellFormat": {
             "description": "The format of a cell.",
             "id": "CellFormat",
@@ -2602,7 +2674,7 @@
             "properties": {
                 "namedRange": {
                     "$ref": "NamedRange",
-                    "description": "The named range to add. If a non-empty\nnamedRangeId is specified, the named range\nwill use that ID. (It is an error to specify the ID of a named\nrange that already exists.)"
+                    "description": "The named range to add. The namedRangeId\nfield is optional; if one is not set, an id will be randomly generated. (It\nis an error to specify the ID of a range that already exists.)"
                 }
             },
             "type": "object"
@@ -3368,7 +3440,7 @@
             "properties": {
                 "filter": {
                     "$ref": "FilterView",
-                    "description": "The filter to add."
+                    "description": "The filter to add. The filterViewId\nfield is optional; if one is not set, an id will be randomly generated. (It\nis an error to specify the ID of a filter that already exists.)"
                 }
             },
             "type": "object"
@@ -3421,7 +3493,7 @@
             "properties": {
                 "chart": {
                     "$ref": "EmbeddedChart",
-                    "description": "The chart that should be added to the spreadsheet, including the position\nwhere it should be placed."
+                    "description": "The chart that should be added to the spreadsheet, including the position\nwhere it should be placed. The chartId\nfield is optional; if one is not set, an id will be randomly generated. (It\nis an error to specify the ID of a chart that already exists.)"
                 }
             },
             "type": "object"