Get Values By Data Filter
POST {{baseUrl}}/v4/spreadsheets/:spreadsheetId/values:batchGetByDataFilter
Returns one or more ranges of values that match the specified data filters. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges that match any of the data filters in the request will be returned.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
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. |
Request Body
{"dataFilters"=>[{"a1Range"=>"eiusmod anim enim culpa", "developerMetadataLookup"=>{"locationMatchingStrategy"=>"INTERSECTING_LOCATION", "locationType"=>"SPREADSHEET", "metadataId"=>-64798951, "metadataKey"=>"sint minim commodo", "metadataLocation"=>{"dimensionRange"=>{"dimension"=>"ROWS", "endIndex"=>34518543, "sheetId"=>68337575, "startIndex"=>91706381}, "locationType"=>"ROW", "sheetId"=>-33783740, "spreadsheet"=>true}, "metadataValue"=>"sunt", "visibility"=>"DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED"}, "gridRange"=>{"endColumnIndex"=>-96821047, "endRowIndex"=>-9277805, "sheetId"=>7522437, "startColumnIndex"=>85603635, "startRowIndex"=>-31384652}}, {"a1Range"=>"sunt irure dolor", "developerMetadataLookup"=>{"locationMatchingStrategy"=>"DEVELOPER_METADATA_LOCATION_MATCHING_STRATEGY_UNSPECIFIED", "locationType"=>"SHEET", "metadataId"=>26360577, "metadataKey"=>"in minim nulla aliquip laboris", "metadataLocation"=>{"dimensionRange"=>{"dimension"=>"COLUMNS", "endIndex"=>-14426665, "sheetId"=>88787400, "startIndex"=>-98846780}, "locationType"=>"COLUMN", "sheetId"=>-14062757, "spreadsheet"=>true}, "metadataValue"=>"proident au", "visibility"=>"DOCUMENT"}, "gridRange"=>{"endColumnIndex"=>-11696202, "endRowIndex"=>-87528654, "sheetId"=>32991035, "startColumnIndex"=>-95148112, "startRowIndex"=>-72465558}}], "dateTimeRenderOption"=>"FORMATTED_STRING", "majorDimension"=>"DIMENSION_UNSPECIFIED", "valueRenderOption"=>"FORMULA"}
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK