Google Sheets · Schema

BasicFilter

The default filter associated with a sheet.

Google WorkspaceProductivitySpreadsheets

Properties

Name Type Description
sortSpecs array The sort order per column.
criteria object The criteria for showing/hiding values per column.
filterSpecs array The filter criteria per column.
View JSON Schema on GitHub

JSON Schema

google-sheets-basic-filter-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "BasicFilter",
  "type": "object",
  "description": "The default filter associated with a sheet.",
  "properties": {
    "sortSpecs": {
      "type": "array",
      "description": "The sort order per column."
    },
    "criteria": {
      "type": "object",
      "description": "The criteria for showing/hiding values per column."
    },
    "filterSpecs": {
      "type": "array",
      "description": "The filter criteria per column."
    }
  }
}