discovery/googleapis/sheets__v4.json - Issue 2571553005: Api-roll 43: 2016-12-13

Unified Diff: discovery/googleapis/sheets__v4.json

Issue 2571553005: Api-roll 43: 2016-12-13 (Closed)

Patch Set: Created 4 years ago

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Jump to:

View side-by-side diff with in-line comments

Index: discovery/googleapis/sheets__v4.json

diff --git a/discovery/googleapis/sheets__v4.json b/discovery/googleapis/sheets__v4.json

index 5dc9c4ebb6bad49a16a5cc8d4ef646d4969fa0ed..ebaa7129ba2453cca06f617796924f8bf40e3aaa 100644

--- a/discovery/googleapis/sheets__v4.json

+++ b/discovery/googleapis/sheets__v4.json

@@ -266,7 +266,7 @@

"type": "string"

"valueRenderOption": {

- "description": "How values should be represented in the output.",

+ "description": "How values should be represented in the output.\nThe default render option is ValueRenderOption.FORMATTED_VALUE.",

"enum": [

"FORMATTED_VALUE",

"UNFORMATTED_VALUE",

@@ -276,7 +276,7 @@

"type": "string"

"dateTimeRenderOption": {

- "description": "How dates, times, and durations should be represented in the output.\nThis is ignored if value_render_option is\nFORMATTED_VALUE.",

+ "description": "How dates, times, and durations should be represented in the output.\nThis is ignored if value_render_option is\nFORMATTED_VALUE.\nThe default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].",

"enum": [

"SERIAL_NUMBER",

"FORMATTED_STRING"

@@ -349,7 +349,7 @@

"type": "string"

"valueRenderOption": {

- "description": "How values should be represented in the output.",

+ "description": "How values should be represented in the output.\nThe default render option is ValueRenderOption.FORMATTED_VALUE.",

"enum": [

"FORMATTED_VALUE",

"UNFORMATTED_VALUE",

@@ -359,7 +359,7 @@

"type": "string"

"dateTimeRenderOption": {

- "description": "How dates, times, and durations should be represented in the output.\nThis is ignored if value_render_option is\nFORMATTED_VALUE.",

"enum": [

"SERIAL_NUMBER",

"FORMATTED_STRING"

@@ -404,6 +404,16 @@

"range"

"parameters": {

+ "responseValueRenderOption": {

+ "description": "Determines how values in the response should be rendered.\nThe default render option is ValueRenderOption.FORMATTED_VALUE.",

+ "enum": [

+ "FORMATTED_VALUE",

+ "UNFORMATTED_VALUE",

+ "FORMULA"

+ ],

+ "location": "query",

+ "type": "string"

+ },

"valueInputOption": {

"description": "How the input data should be interpreted.",

"enum": [

@@ -414,12 +424,32 @@

"location": "query",

"type": "string"

+ "responseDateTimeRenderOption": {

+ "description": "Determines how dates, times, and durations in the response should be\nrendered. This is ignored if response_value_render_option is\nFORMATTED_VALUE.\nThe default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].",

+ "enum": [

+ "SERIAL_NUMBER",

+ "FORMATTED_STRING"

+ ],

+ "location": "query",

+ "type": "string"

+ },

+ "includeValuesInResponse": {

+ "description": "Determines if the update response should include the values\nof the cells that were appended. By default, responses\ndo not include the updated values.",

+ "location": "query",

+ "type": "boolean"

+ },

"spreadsheetId": {

"description": "The ID of the spreadsheet to update.",

"location": "path",

"required": true,

"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"

+ },

"insertDataOption": {

"description": "How the input data should be inserted.",

"enum": [

@@ -428,12 +458,6 @@

"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",

@@ -457,6 +481,16 @@

"range"

"parameters": {

+ "responseValueRenderOption": {

+ "description": "Determines how values in the response should be rendered.\nThe default render option is ValueRenderOption.FORMATTED_VALUE.",

+ "enum": [

+ "FORMATTED_VALUE",

+ "UNFORMATTED_VALUE",

+ "FORMULA"

+ ],

+ "location": "query",

+ "type": "string"

+ },

"valueInputOption": {

"description": "How the input data should be interpreted.",

"enum": [

@@ -467,6 +501,20 @@

"location": "query",

"type": "string"

+ "responseDateTimeRenderOption": {

+ "enum": [

+ "SERIAL_NUMBER",

+ "FORMATTED_STRING"

+ ],

+ "location": "query",

+ "type": "string"

+ },

+ "includeValuesInResponse": {

+ "description": "Determines if the update response should include the values\nof the cells that were updated. By default, responses\ndo not include the updated values.\nIf the range to write was larger than than the range actually written,\nthe response will include all values in the requested range (excluding\ntrailing empty rows and columns).",

+ "location": "query",

+ "type": "boolean"

+ },

"spreadsheetId": {

"description": "The ID of the spreadsheet to update.",

"location": "path",

@@ -563,7 +611,7 @@

}

- "revision": "20161021",

+ "revision": "20161209",

"rootUrl": "https://sheets.googleapis.com/",

"schemas": {

"AddNamedRangeResponse": {

@@ -867,15 +915,24 @@

"description": "The response when updating a range of values in a spreadsheet.",

"id": "UpdateValuesResponse",

"properties": {

- "updatedRange": {

- "description": "The range (in A1 notation) that updates were applied to.",

- "type": "string"

- },

"updatedColumns": {

"description": "The number of columns where at least one cell in the column was updated.",

"format": "int32",

"type": "integer"

+ "updatedCells": {

+ "description": "The number of cells updated.",

+ "format": "int32",

+ "type": "integer"

+ },

+ "updatedData": {

+ "$ref": "ValueRange",

+ "description": "The values of the cells after updates were applied.\nThis is only included if the request's `includeValuesInResponse` field\nwas `true`."

+ },

+ "updatedRange": {

+ "description": "The range (in A1 notation) that updates were applied to.",

+ "type": "string"

+ },

"spreadsheetId": {

"description": "The spreadsheet the updates were applied to.",

"type": "string"

@@ -884,11 +941,6 @@

"description": "The number of rows where at least one cell in the row was updated.",

"format": "int32",

"type": "integer"

- },

- "updatedCells": {

- "description": "The number of cells updated.",

- "format": "int32",

- "type": "integer"

}

"type": "object"

@@ -1530,6 +1582,36 @@

"$ref": "ValueRange"

"type": "array"

+ },

+ "responseValueRenderOption": {

+ "description": "Determines how values in the response should be rendered.\nThe default render option is ValueRenderOption.FORMATTED_VALUE.",

+ "enum": [

+ "FORMATTED_VALUE",

+ "UNFORMATTED_VALUE",

+ "FORMULA"

+ ],

+ "enumDescriptions": [

+ "Values will be calculated & formatted in the reply according to the\ncell's formatting. Formatting is based on the spreadsheet's locale,\nnot the requesting user's locale.\nFor example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency,\nthen `A2` would return `\"$1.23\"`.",

+ "Values will be calculated, but not formatted in the reply.\nFor example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency,\nthen `A2` would return the number `1.23`.",

+ "Values will not be calculated. The reply will include the formulas.\nFor example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency,\nthen A2 would return `\"=A1\"`."

+ ],

+ "type": "string"

+ },

+ "responseDateTimeRenderOption": {

+ "enum": [

+ "SERIAL_NUMBER",

+ "FORMATTED_STRING"

+ ],

+ "enumDescriptions": [

+ "Instructs date, time, datetime, and duration fields to be output\nas doubles in \"serial number\" format, as popularized by Lotus 1-2-3.\nDays are counted from December 31st 1899 and are incremented by 1,\nand times are fractions of a day. For example, January 1st 1900 at noon\nwould be 1.5, 1 because it's 1 day offset from December 31st 1899,\nand .5 because noon is half a day. February 1st 1900 at 3pm would\nbe 32.625. This correctly treats the year 1900 as not a leap year.",

+ "Instructs date, time, datetime, and duration fields to be output\nas strings in their given number format (which is dependent\non the spreadsheet locale)."

+ ],

+ "type": "string"

+ },

+ "includeValuesInResponse": {

+ "description": "Determines if the update response should include the values\nof the cells that were updated. By default, responses\ndo not include the updated values. The `updatedData` field within\neach of the BatchUpdateValuesResponse.responses will contain\nthe updated values. If the range to write was larger than than the range\nactually written, the response will include all values in the requested\nrange (excluding trailing empty rows and columns).",

+ "type": "boolean"

}

"type": "object"

@@ -2114,12 +2196,27 @@

"description": "The request for updating any aspect of a spreadsheet.",

"id": "BatchUpdateSpreadsheetRequest",

"properties": {

+ "includeSpreadsheetInResponse": {

+ "description": "Determines if the update response should include the spreadsheet\nresource.",

+ "type": "boolean"

+ },

"requests": {

"description": "A list of updates to apply to the spreadsheet.",

"items": {

"$ref": "Request"

"type": "array"

+ },

+ "responseRanges": {

+ "description": "Limits the ranges included in the response spreadsheet.\nMeaningful only if include_spreadsheet_response is 'true'.",

+ "items": {

+ "type": "string"

+ },

+ "type": "array"

+ },

+ "responseIncludeGridData": {

+ "description": "True if grid data should be returned. Meaningful only if\nif include_spreadsheet_response is 'true'.\nThis parameter is ignored if a field mask was set in the request.",

+ "type": "boolean"

}

"type": "object"

@@ -2133,7 +2230,7 @@

"type": "string"

"index": {

- "description": "The index of the sheet within the spreadsheet.\nWhen adding or updating sheet properties, if this field\nis excluded then the sheet will be added or moved to the end\nof the sheet list.",

+ "description": "The index of the sheet within the spreadsheet.\nWhen adding or updating sheet properties, if this field\nis excluded then the sheet will be added or moved to the end\nof the sheet list. When updating sheet indices or inserting\nsheets, movement is considered in \"before the move\" indexes.\nFor example, if there were 3 sheets (S1, S2, S3) in order to\nmove S1 ahead of S2 the index would have to be set to 2. A sheet\nindex update request will be ignored if the requested index is\nidentical to the sheets current index or if the requested new\nindex is equal to the current sheet index + 1.",

"format": "int32",

"type": "integer"

@@ -2575,6 +2672,10 @@

"$ref": "SpreadsheetProperties",

"description": "Overall properties of a spreadsheet."

+ "spreadsheetUrl": {

+ "description": "The url of the spreadsheet.\nThis field is read-only.",

+ "type": "string"

+ },

"sheets": {

"description": "The sheets that are part of a spreadsheet.",

"items": {

@@ -3412,6 +3513,10 @@

"description": "The spreadsheet the updates were applied to.",

"type": "string"

+ "updatedSpreadsheet": {

+ "$ref": "Spreadsheet",

+ "description": "The spreadsheet after updates were applied. This is only set if\n[BatchUpdateSpreadsheetRequest.include_spreadsheet_in_response] is `true`."

+ },

"replies": {

"description": "The reply of the updates. This maps 1:1 with the updates, although\nreplies to some requests may be empty.",

"items": {

« no previous file with comments | « discovery/googleapis/servicemanagement__v1.json ('k') | discovery/googleapis/siteVerification__v1.json » ('j') | no next file with comments »