how to read a syntax diagram

Paul tallpaul at gmail.com
Sun May 27 17:19:15 EDT 2018


oops, please ignore the bit before "update(spreadsheetId=*, range=*, ..."

On Sun, May 27, 2018 at 9:17 PM, Paul <tallpaul at gmail.com> wrote:

> hi,
>    I'm using the Google Sheets API (the client library rather than the
> RESTful interface) and I'm confused about the meaning of the syntax
> diagrams.  This is from
> https://developers.google.com/resources/api-libraries/
> documentation/sheets/v4/python/latest/sheets_v4.spreadsheets.values.html#
> update
>
> efaults to ROWS.
>   }
>
> update(spreadsheetId=*, range=*, body=*, valueInputOption=None,
> x__xgafv=None, responseValueRenderOption=None,
> includeValuesInResponse=None, responseDateTimeRenderOption=None)
>
> Sets values in a range of a spreadsheet.
> The caller must specify the spreadsheet ID, range, and
> a valueInputOption.
>
> Args:
>   spreadsheetId: string, The ID of the spreadsheet to update. (required)
>   range: string, The A1 notation of the values to update. (required)
>   body: object, The request body. (required)
>     The object takes the form of:
>
> { # Data within a range of the spreadsheet.
>   "range": "A String", # The range the values cover, in A1 notation.
>       # For output, this range indicates the entire requested range,
>       # even though the values will exclude trailing rows and columns.
>       # When appending values, this field represents the range to search for a
>       # table, after which values will be appended.
>   "values": [ # The data that was read or to be written.  This is an array of arrays,
>       # the outer array representing all the data and each inner array
>       # representing a major dimension. Each item in the inner array
>       # corresponds with one cell.
>       #
>       # For output, empty trailing rows and columns will not be included.
>       #
>       # For input, supported value types are: bool, string, and double.
>       # Null values will be skipped.
>       # To set a cell to an empty value, set the string value to an empty string.
>     [
>       "",
>     ],
>   ],
>   "majorDimension": "A String", # The major dimension of the values.
>       #
>       # For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
>       # then requesting `range=A1:B2,majorDimension=ROWS` will return
>       # `[[1,2],[3,4]]`,
>       # whereas requesting `range=A1:B2,majorDimension=COLUMNS` will return
>       # `[[1,3],[2,4]]`.
>       #
>       # For input, with `range=A1:B2,majorDimension=ROWS` then `[[1,2],[3,4]]`
>       # will set `A1=1,B1=2,A2=3,B2=4`. With `range=A1:B2,majorDimension=COLUMNS`
>       # then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
>       #
>       # When writing, if this field is not set, it defaults to ROWS.
> }
>
>   valueInputOption: string, How the input data should be interpreted....// I CUT IT OFF, HERE
>
>
> My specific questions are:
>    1) is this standard (python?) syntax notation?  I haven't found a key
> to this form of documentation.
>    1)  What does  '=*' mean?
>    2)  What does '=None' mean?    [my guess is that this means "no default
> value"].
>    3)  Note that it says that range is required.  Through trial, I see
> that *one* of the 'range' specifications is required.  I.E., I can specify
> 'range' outside body, or 'range' as part of body, or both, but I must have
> 'range' someplace.   This is a bit confusing to me ( as opposed to my usual
> understanding of "required").  Also, what does range mean, in these two
> different spots, and what does it mean if two different values of range are
> specified?
>
> thanks
>   Paul Czyzewski
>



More information about the Python-list mailing list