Get Values Batch

GET {{baseUrl}}/v4/spreadsheets/:spreadsheetId/values:batchGet

Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges.

Request Params

Key	Datatype	Required	Description
`ranges`	string
`majorDimension`	string
`valueRenderOption`	string
`dateTimeRenderOption`	string
`access_token`	string		OAuth access token.
`alt`	string		Data format for response.
`callback`	string		JSONP
`fields`	string		Selector specifying which fields to include in a partial response.
`key`	string		API key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.
`oauth_token`	string		OAuth 2.0 token for the current user.
`prettyPrint`	string		Returns response with indentations and line breaks.
`quotaUser`	string		Available to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters.
`upload_protocol`	string		Upload protocol for media (e.g. "raw", "multipart").
`uploadType`	string		Legacy upload protocol for media (e.g. "media", "multipart").
`$.xgafv`	string		V1 error format.

HEADERS

Key	Datatype	Required	Description
`Accept`	string

RESPONSES

status: OK