Microsoft Graph · Schema

workbookFilterCriteria

Microsoft GraphAzure ADCollaborationContactsDocumentsEmailGraphIdentityMicrosoftOffice 365PresentationsProductivitySpreadsheetsT1Task

Properties

Name Type Description
color string The color applied to the cell.
criterion1 string A custom criterion.
criterion2 string A custom criterion.
dynamicCriteria string A dynamic formula specified in a custom filter.
filterOn string Indicates whether a filter is applied to a column.
icon object An icon applied to a cell via conditional formatting.
operator string An operator in a cell; for example, =, >, <, <=, or <>.
values object The values that appear in the cell.
@odata.type string
View JSON Schema on GitHub

JSON Schema

microsoft-graph-microsoftgraphworkbookfiltercriteria-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/microsoft.graph.workbookFilterCriteria",
  "title": "workbookFilterCriteria",
  "required": [
    "@odata.type"
  ],
  "type": "object",
  "properties": {
    "color": {
      "type": "string",
      "description": "The color applied to the cell.",
      "nullable": true
    },
    "criterion1": {
      "type": "string",
      "description": "A custom criterion.",
      "nullable": true
    },
    "criterion2": {
      "type": "string",
      "description": "A custom criterion.",
      "nullable": true
    },
    "dynamicCriteria": {
      "type": "string",
      "description": "A dynamic formula specified in a custom filter."
    },
    "filterOn": {
      "type": "string",
      "description": "Indicates whether a filter is applied to a column."
    },
    "icon": {
      "anyOf": [
        {
          "$ref": "#/components/schemas/microsoft.graph.workbookIcon"
        },
        {
          "type": "object",
          "nullable": true
        }
      ],
      "description": "An icon applied to a cell via conditional formatting."
    },
    "operator": {
      "type": "string",
      "description": "An operator in a cell; for example, =, >, <, <=, or <>."
    },
    "values": {
      "description": "The values that appear in the cell."
    },
    "@odata.type": {
      "type": "string"
    }
  }
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/microsoft-graph-microsoftgraphworkbookfiltercriteria"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.