Skip to content

Verify bulk sheet updates

Use this after an uncertain bulk apply response to classify each requested sheet target as applied, pending, conflicting, or error without writing.

{
"annotations": {
"readOnlyHint": true,
"destructiveHint": false,
"idempotentHint": true,
"openWorldHint": false
},
"fileParams": [],
"requiredPermission": "write",
"security": {
"type": "oauth2",
"scopes": [
"chalksurf:write"
]
}
}

The server advertises this JSON Schema to MCP clients. Runtime authorization and business-rule checks still apply.

{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"additionalProperties": false,
"properties": {
"organizationId": {
"description": "The ChalkSurf organization ID to use for this request.",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$",
"type": "string"
},
"updates": {
"items": {
"additionalProperties": false,
"properties": {
"expectedSeriesAssignments": {
"items": {
"additionalProperties": false,
"properties": {
"editionYear": {
"maximum": 9999,
"minimum": 1000,
"type": "integer"
},
"seriesPath": {
"minLength": 1,
"type": "string"
}
},
"required": [
"seriesPath",
"editionYear"
],
"type": "object"
},
"type": "array"
},
"expectedUpdatedAt": {
"minLength": 1,
"type": "string"
},
"id": {
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$",
"type": "string"
},
"patch": {
"additionalProperties": false,
"properties": {
"folderId": {
"anyOf": [
{
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$",
"type": "string"
},
{
"type": "null"
}
]
},
"private_notes": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
]
},
"scoringEnabled": {
"type": "boolean"
},
"seriesAssignments": {
"items": {
"additionalProperties": false,
"properties": {
"editionYear": {
"maximum": 9999,
"minimum": 1000,
"type": "integer"
},
"seriesPath": {
"minLength": 1,
"type": "string"
}
},
"required": [
"seriesPath",
"editionYear"
],
"type": "object"
},
"type": "array"
},
"subject": {
"enum": [
"math",
"physics",
"chemistry"
],
"type": "string"
},
"translations": {
"additionalProperties": {
"additionalProperties": false,
"properties": {
"description": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
]
},
"name": {
"minLength": 1,
"type": "string"
},
"title": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
]
}
},
"type": "object"
},
"properties": {},
"type": "object"
}
},
"type": "object"
}
},
"required": [
"id",
"expectedUpdatedAt",
"patch"
],
"type": "object"
},
"maxItems": 100,
"minItems": 1,
"type": "array"
}
},
"required": [
"updates",
"organizationId"
],
"type": "object"
}
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"additionalProperties": false,
"properties": {
"counts": {
"additionalProperties": false,
"properties": {
"applied": {
"maximum": 9007199254740991,
"minimum": 0,
"type": "integer"
},
"conflicting": {
"maximum": 9007199254740991,
"minimum": 0,
"type": "integer"
},
"error": {
"maximum": 9007199254740991,
"minimum": 0,
"type": "integer"
},
"pending": {
"maximum": 9007199254740991,
"minimum": 0,
"type": "integer"
},
"total": {
"maximum": 9007199254740991,
"minimum": 0,
"type": "integer"
}
},
"required": [
"total",
"applied",
"pending",
"conflicting",
"error"
],
"type": "object"
},
"results": {
"items": {
"additionalProperties": false,
"properties": {
"conflicts": {
"items": {
"additionalProperties": false,
"properties": {
"code": {
"enum": [
"updated_at_changed",
"series_assignments_changed"
],
"type": "string"
},
"field": {
"enum": [
"expectedUpdatedAt",
"expectedSeriesAssignments"
],
"type": "string"
}
},
"required": [
"field",
"code"
],
"type": "object"
},
"type": "array"
},
"errorCode": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
]
},
"errorMessage": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
]
},
"id": {
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$",
"type": "string"
},
"matchedPaths": {
"items": {
"type": "string"
},
"type": "array"
},
"status": {
"enum": [
"applied",
"pending",
"conflicting",
"error"
],
"type": "string"
},
"unmatchedPaths": {
"items": {
"type": "string"
},
"type": "array"
}
},
"required": [
"id",
"status",
"matchedPaths",
"unmatchedPaths",
"conflicts",
"errorCode",
"errorMessage"
],
"type": "object"
},
"type": "array"
},
"state": {
"enum": [
"applied",
"pending",
"conflicting",
"mixed",
"error"
],
"type": "string"
}
},
"required": [
"state",
"counts",
"results"
],
"type": "object"
}