FilterView

A filter view.

Google WorkspaceProductivitySpreadsheets

Properties

Name	Type	Description
filterViewId	integer	The ID of the filter view.
title	string	The name of the filter view.
namedRangeId	string	The named range this filter view is backed by, if any.
sortSpecs	array	The sort order per column.
criteria	object	The criteria for showing/hiding values per column.
filterSpecs	array	The filter criteria for showing/hiding values per column.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "FilterView",
  "type": "object",
  "description": "A filter view.",
  "properties": {
    "filterViewId": {
      "type": "integer",
      "description": "The ID of the filter view."
    },
    "title": {
      "type": "string",
      "description": "The name of the filter view."
    },
    "namedRangeId": {
      "type": "string",
      "description": "The named range this filter view is backed by, if any."
    },
    "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 for showing/hiding values per column."
    }
  }
}