{"command":{"effect":"write","timeoutSeconds":30,"inputSchema":{"type":"object","description":"Returns one or more ranges of values that match the specified data filters. For more information, see [Read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). 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.","properties":{"query":{"type":"object","properties":{"$.xgafv":{"description":"V1 error format.","enum":["1","2"],"type":"string"},"fields":{"description":"Selector specifying which fields to include in a partial response.","type":"string"},"prettyPrint":{"default":true,"description":"Returns response with indentations and line breaks.","type":"boolean"}},"required":[],"additionalProperties":false},"path":{"type":"object","properties":{"spreadsheetId":{"description":"The ID of the spreadsheet to retrieve data from.","type":"string"}},"required":["spreadsheetId"],"additionalProperties":false},"body":{"$ref":"#/definitions/BatchGetValuesByDataFilterRequest"}},"required":["path","body"],"additionalProperties":false,"definitions":{"BatchGetValuesByDataFilterRequest":{"description":"The request for retrieving a range of values in a spreadsheet selected by a set of DataFilters.","properties":{"dataFilters":{"description":"The data filters used to match the ranges of values to retrieve. Ranges that match any of the specified data filters are included in the response.","items":{"$ref":"#/definitions/DataFilter"},"type":"array"},"dateTimeRenderOption":{"description":"How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.","enum":["SERIAL_NUMBER","FORMATTED_STRING"],"type":"string"},"majorDimension":{"description":"The major dimension that results should use. For example, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`, then a request that selects that range and sets `majorDimension=ROWS` returns `[[1,2],[3,4]]`, whereas a request that sets `majorDimension=COLUMNS` returns `[[1,3],[2,4]]`.","enum":["DIMENSION_UNSPECIFIED","ROWS","COLUMNS"],"type":"string"},"valueRenderOption":{"description":"How values should be represented in the output. The default render option is FORMATTED_VALUE.","enum":["FORMATTED_VALUE","UNFORMATTED_VALUE","FORMULA"],"type":"string"}},"type":"object"},"DataFilter":{"description":"Filter that describes what data should be selected or returned from a request. For more information, see [Read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata).","properties":{"a1Range":{"description":"Selects data that matches the specified A1 range.","type":"string"},"developerMetadataLookup":{"$ref":"#/definitions/DeveloperMetadataLookup"},"gridRange":{"$ref":"#/definitions/GridRange"}},"type":"object"},"DeveloperMetadataLookup":{"description":"Selects DeveloperMetadata that matches all of the specified fields. For example, if only a metadata ID is specified this considers the DeveloperMetadata with that particular unique ID. If a metadata key is specified, this considers all developer metadata with that key. If a key, visibility, and location type are all specified, this considers all developer metadata with that key and visibility that are associated with a location of that type. In general, this selects all DeveloperMetadata that match the intersection of all the specified fields; any field or combination of fields may be specified.","properties":{"locationMatchingStrategy":{"description":"Determines how this lookup matches the location. If this field is specified as EXACT, only developer metadata associated on the exact location specified is matched. If this field is specified to INTERSECTING, developer metadata associated on intersecting locations is also matched. If left unspecified, this field assumes a default value of INTERSECTING. If this field is specified, a metadataLocation must also be specified.","enum":["DEVELOPER_METADATA_LOCATION_MATCHING_STRATEGY_UNSPECIFIED","EXACT_LOCATION","INTERSECTING_LOCATION"],"type":"string"},"locationType":{"description":"Limits the selected developer metadata to those entries which are associated with locations of the specified type. For example, when this field is specified as ROW this lookup only considers developer metadata associated on rows. If the field is left unspecified, all location types are considered. This field cannot be specified as SPREADSHEET when the locationMatchingStrategy is specified as INTERSECTING or when the metadataLocation is specified as a non-spreadsheet location. Spreadsheet metadata cannot intersect any other developer metadata location. This field also must be left unspecified when the locationMatchingStrategy is specified as EXACT.","enum":["DEVELOPER_METADATA_LOCATION_TYPE_UNSPECIFIED","ROW","COLUMN","SHEET","SPREADSHEET"],"type":"string"},"metadataId":{"description":"Limits the selected developer metadata to that which has a matching DeveloperMetadata.metadata_id.","type":"integer"},"metadataKey":{"description":"Limits the selected developer metadata to that which has a matching DeveloperMetadata.metadata_key.","type":"string"},"metadataLocation":{"$ref":"#/definitions/DeveloperMetadataLocation"},"metadataValue":{"description":"Limits the selected developer metadata to that which has a matching DeveloperMetadata.metadata_value.","type":"string"},"visibility":{"description":"Limits the selected developer metadata to that which has a matching DeveloperMetadata.visibility. If left unspecified, all developer metadata visible to the requesting project is considered.","enum":["DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED","DOCUMENT","PROJECT"],"type":"string"}},"type":"object"},"GridRange":{"description":"A range on a sheet. All indexes are zero-based. Indexes are half open, i.e. the start index is inclusive and the end index is exclusive -- [start_index, end_index). Missing indexes indicate the range is unbounded on that side. For example, if `\"Sheet1\"` is sheet ID 123456, then: `Sheet1!A1:A1 == sheet_id: 123456, start_row_index: 0, end_row_index: 1, start_column_index: 0, end_column_index: 1` `Sheet1!A3:B4 == sheet_id: 123456, start_row_index: 2, end_row_index: 4, start_column_index: 0, end_column_index: 2` `Sheet1!A:B == sheet_id: 123456, start_column_index: 0, end_column_index: 2` `Sheet1!A5:B == sheet_id: 123456, start_row_index: 4, start_column_index: 0, end_column_index: 2` `Sheet1 == sheet_id: 123456` The start index must always be less than or equal to the end index. If the start index equals the end index, then the range is empty. Empty ranges are typically not meaningful and are usually rendered in the UI as `#REF!`.","properties":{"endColumnIndex":{"description":"The end column (exclusive) of the range, or not set if unbounded.","type":"integer"},"endRowIndex":{"description":"The end row (exclusive) of the range, or not set if unbounded.","type":"integer"},"sheetId":{"description":"The sheet this range is on.","type":"integer"},"startColumnIndex":{"description":"The start column (inclusive) of the range, or not set if unbounded.","type":"integer"},"startRowIndex":{"description":"The start row (inclusive) of the range, or not set if unbounded.","type":"integer"}},"type":"object"},"DeveloperMetadataLocation":{"description":"A location where metadata may be associated in a spreadsheet.","properties":{"dimensionRange":{"$ref":"#/definitions/DimensionRange"},"locationType":{"description":"The type of location this object represents. This field is read-only.","enum":["DEVELOPER_METADATA_LOCATION_TYPE_UNSPECIFIED","ROW","COLUMN","SHEET","SPREADSHEET"],"type":"string"},"sheetId":{"description":"The ID of the sheet when metadata is associated with an entire sheet.","type":"integer"},"spreadsheet":{"description":"True when metadata is associated with an entire spreadsheet.","type":"boolean"}},"type":"object"},"DimensionRange":{"description":"A range along a single dimension on a sheet. All indexes are zero-based. Indexes are half open: the start index is inclusive and the end index is exclusive. Missing indexes indicate the range is unbounded on that side.","properties":{"dimension":{"description":"The dimension of the span.","enum":["DIMENSION_UNSPECIFIED","ROWS","COLUMNS"],"type":"string"},"endIndex":{"description":"The end (exclusive) of the span, or not set if unbounded.","type":"integer"},"sheetId":{"description":"The sheet this span is on.","type":"integer"},"startIndex":{"description":"The start (inclusive) of the span, or not set if unbounded.","type":"integer"}},"type":"object"}}},"name":"Returns one or more ranges of values that match the specified data filters","id":"google-sheets.sheets.spreadsheets.values.batchgetbydatafilter","example":{"path":{"spreadsheetId":"example"},"body":{}},"maxRequests":1,"summary":false}}