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 |
JSON Schema
{
"$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.
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.