rootset_list_activity - Rootset

Workflow

Access and behavior

Requires a current workspace role of Viewer or higher. The connection needs history:read scope.

This tool reads data without changing it.

Arguments

Argument	Required	Type	Details
`orgId`	Yes	string	Workspace ID returned by rootset_get_context.
`databaseId`	No	string	ID of the database to work with.
`tableId`	No	string	ID of the table to work with.
`category`	No	”records” or “schema” or “imports” or “exports” or “backups” or “restores”	—
`event`	No	”job.testBackupDestination.cancelled” or “job.testBackupDestination.succeeded” or “job.testBackupDestination.failed” or “job.testBackupDestination.partially_completed” or “job.testBackupDestination.queued” or “job.saveBackupSchedule.cancelled” or “job.saveBackupSchedule.failed” or “job.saveBackupSchedule.partially_completed” or “job.saveBackupSchedule.queued” or “backup.failed.detected” or “backup.failed.resolved” or “backup.overdue.detected” or “backup.overdue.resolved” or “database.backup.prune” or “database.backup_policy.update” or “database.backup_schedule.update” or “database.backup_schedule.delete” or “job.previewDatabaseRestore.cancelled” or “job.previewDatabaseRestore.succeeded” or “job.previewDatabaseRestore.failed” or “job.previewDatabaseRestore.partially_completed” or “job.previewDatabaseRestore.queued” or “job.runDatabaseBackup.cancelled” or “job.runDatabaseBackup.succeeded” or “job.runDatabaseBackup.failed” or “job.runDatabaseBackup.partially_completed” or “job.runDatabaseBackup.queued” or “database.create” or “database.delete” or “job.deleteDatabase.cancelled” or “job.deleteDatabase.failed” or “job.deleteDatabase.partially_completed” or “job.deleteDatabase.queued” or “job.exportDatabase.cancelled” or “job.exportDatabase.succeeded” or “job.exportDatabase.failed” or “job.exportDatabase.partially_completed” or “job.exportDatabase.queued” or “job.restoreDatabaseBackup.cancelled” or “job.restoreDatabaseBackup.failed” or “job.restoreDatabaseBackup.partially_completed” or “job.restoreDatabaseBackup.queued” or “database.restore” or “database.update” or “field.create” or “field.convert” or “job.createField.cancelled” or “job.createField.failed” or “job.createField.partially_completed” or “job.createField.queued” or “field.delete” or “job.deleteField.cancelled” or “job.deleteField.failed” or “job.deleteField.partially_completed” or “job.deleteField.queued” or “job.reorderFields.cancelled” or “job.reorderFields.failed” or “job.reorderFields.partially_completed” or “job.reorderFields.queued” or “job.updateField.cancelled” or “job.updateField.failed” or “job.updateField.partially_completed” or “job.updateField.queued” or “field.update” or “fields.reorder” or “job.previewImportRows.cancelled” or “job.previewImportRows.succeeded” or “job.previewImportRows.failed” or “job.previewImportRows.partially_completed” or “job.previewImportRows.queued” or “job.importRows.cancelled” or “job.importRows.succeeded” or “job.importRows.failed” or “job.importRows.partially_completed” or “job.importRows.queued” or “records.changed” or “job.applySchemaChange.cancelled” or “job.applySchemaChange.failed” or “job.applySchemaChange.partially_completed” or “job.applySchemaChange.queued” or “table.create” or “job.createTable.cancelled” or “job.createTable.failed” or “job.createTable.partially_completed” or “job.createTable.queued” or “table.delete” or “job.deleteTable.cancelled” or “job.deleteTable.failed” or “job.deleteTable.partially_completed” or “job.deleteTable.queued” or “job.exportRows.cancelled” or “job.exportRows.succeeded” or “job.exportRows.failed” or “job.exportRows.partially_completed” or “job.exportRows.queued” or “foreign-key.create” or “job.createForeignKey.cancelled” or “job.createForeignKey.failed” or “job.createForeignKey.partially_completed” or “job.createForeignKey.queued” or “foreign-key.delete” or “job.deleteForeignKey.cancelled” or “job.deleteForeignKey.failed” or “job.deleteForeignKey.partially_completed” or “job.deleteForeignKey.queued” or “job.updateTable.cancelled” or “job.updateTable.failed” or “job.updateTable.partially_completed” or “job.updateTable.queued” or “table.update” or “rule.create” or “job.createUniqueRule.cancelled” or “job.createUniqueRule.failed” or “job.createUniqueRule.partially_completed” or “job.createUniqueRule.queued” or “rule.delete” or “job.deleteUniqueRule.cancelled” or “job.deleteUniqueRule.failed” or “job.deleteUniqueRule.partially_completed” or “job.deleteUniqueRule.queued” or “job.exportView.cancelled” or “job.exportView.succeeded” or “job.exportView.failed” or “job.exportView.partially_completed” or “job.exportView.queued”	—
`actor`	No	string	—
`resource`	No	string	—
`q`	No	string	—
`from`	No	string	—
`to`	No	string	—
`limit`	No	integer	Maximum number of items to return.
`cursor`	No	string or null	Continuation cursor from the previous response.

Complete input schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "type": "object",
  "properties": {
    "orgId": {
      "type": "string",
      "pattern": "^[0-7][0-9A-HJKMNP-TV-Z]{25}$"
    },
    "databaseId": {
      "type": "string",
      "pattern": "^[0-7][0-9A-HJKMNP-TV-Z]{25}$"
    },
    "tableId": {
      "type": "string",
      "pattern": "^[0-7][0-9A-HJKMNP-TV-Z]{25}$"
    },
    "category": {
      "type": "string",
      "enum": ["records", "schema", "imports", "exports", "backups", "restores"]
    },
    "event": {
      "type": "string",
      "enum": [
        "job.testBackupDestination.cancelled",
        "job.testBackupDestination.succeeded",
        "job.testBackupDestination.failed",
        "job.testBackupDestination.partially_completed",
        "job.testBackupDestination.queued",
        "job.saveBackupSchedule.cancelled",
        "job.saveBackupSchedule.failed",
        "job.saveBackupSchedule.partially_completed",
        "job.saveBackupSchedule.queued",
        "backup.failed.detected",
        "backup.failed.resolved",
        "backup.overdue.detected",
        "backup.overdue.resolved",
        "database.backup.prune",
        "database.backup_policy.update",
        "database.backup_schedule.update",
        "database.backup_schedule.delete",
        "job.previewDatabaseRestore.cancelled",
        "job.previewDatabaseRestore.succeeded",
        "job.previewDatabaseRestore.failed",
        "job.previewDatabaseRestore.partially_completed",
        "job.previewDatabaseRestore.queued",
        "job.runDatabaseBackup.cancelled",
        "job.runDatabaseBackup.succeeded",
        "job.runDatabaseBackup.failed",
        "job.runDatabaseBackup.partially_completed",
        "job.runDatabaseBackup.queued",
        "database.create",
        "database.delete",
        "job.deleteDatabase.cancelled",
        "job.deleteDatabase.failed",
        "job.deleteDatabase.partially_completed",
        "job.deleteDatabase.queued",
        "job.exportDatabase.cancelled",
        "job.exportDatabase.succeeded",
        "job.exportDatabase.failed",
        "job.exportDatabase.partially_completed",
        "job.exportDatabase.queued",
        "job.restoreDatabaseBackup.cancelled",
        "job.restoreDatabaseBackup.failed",
        "job.restoreDatabaseBackup.partially_completed",
        "job.restoreDatabaseBackup.queued",
        "database.restore",
        "database.update",
        "field.create",
        "field.convert",
        "job.createField.cancelled",
        "job.createField.failed",
        "job.createField.partially_completed",
        "job.createField.queued",
        "field.delete",
        "job.deleteField.cancelled",
        "job.deleteField.failed",
        "job.deleteField.partially_completed",
        "job.deleteField.queued",
        "job.reorderFields.cancelled",
        "job.reorderFields.failed",
        "job.reorderFields.partially_completed",
        "job.reorderFields.queued",
        "job.updateField.cancelled",
        "job.updateField.failed",
        "job.updateField.partially_completed",
        "job.updateField.queued",
        "field.update",
        "fields.reorder",
        "job.previewImportRows.cancelled",
        "job.previewImportRows.succeeded",
        "job.previewImportRows.failed",
        "job.previewImportRows.partially_completed",
        "job.previewImportRows.queued",
        "job.importRows.cancelled",
        "job.importRows.succeeded",
        "job.importRows.failed",
        "job.importRows.partially_completed",
        "job.importRows.queued",
        "records.changed",
        "job.applySchemaChange.cancelled",
        "job.applySchemaChange.failed",
        "job.applySchemaChange.partially_completed",
        "job.applySchemaChange.queued",
        "table.create",
        "job.createTable.cancelled",
        "job.createTable.failed",
        "job.createTable.partially_completed",
        "job.createTable.queued",
        "table.delete",
        "job.deleteTable.cancelled",
        "job.deleteTable.failed",
        "job.deleteTable.partially_completed",
        "job.deleteTable.queued",
        "job.exportRows.cancelled",
        "job.exportRows.succeeded",
        "job.exportRows.failed",
        "job.exportRows.partially_completed",
        "job.exportRows.queued",
        "foreign-key.create",
        "job.createForeignKey.cancelled",
        "job.createForeignKey.failed",
        "job.createForeignKey.partially_completed",
        "job.createForeignKey.queued",
        "foreign-key.delete",
        "job.deleteForeignKey.cancelled",
        "job.deleteForeignKey.failed",
        "job.deleteForeignKey.partially_completed",
        "job.deleteForeignKey.queued",
        "job.updateTable.cancelled",
        "job.updateTable.failed",
        "job.updateTable.partially_completed",
        "job.updateTable.queued",
        "table.update",
        "rule.create",
        "job.createUniqueRule.cancelled",
        "job.createUniqueRule.failed",
        "job.createUniqueRule.partially_completed",
        "job.createUniqueRule.queued",
        "rule.delete",
        "job.deleteUniqueRule.cancelled",
        "job.deleteUniqueRule.failed",
        "job.deleteUniqueRule.partially_completed",
        "job.deleteUniqueRule.queued",
        "job.exportView.cancelled",
        "job.exportView.succeeded",
        "job.exportView.failed",
        "job.exportView.partially_completed",
        "job.exportView.queued"
      ]
    },
    "actor": {
      "type": "string",
      "minLength": 1,
      "maxLength": 256
    },
    "resource": {
      "type": "string",
      "pattern": "^(database|table):[0-9A-HJKMNP-TV-Z]{26}$"
    },
    "q": {
      "type": "string",
      "maxLength": 200
    },
    "from": {
      "type": "string",
      "pattern": "^(?!0000)\\d{4}-\\d{2}-\\d{2}T(?:[01]\\d|2[0-3]):[0-5]\\d:[0-5]\\d\\.\\d{3}Z$"
    },
    "to": {
      "type": "string",
      "pattern": "^(?!0000)\\d{4}-\\d{2}-\\d{2}T(?:[01]\\d|2[0-3]):[0-5]\\d:[0-5]\\d\\.\\d{3}Z$"
    },
    "limit": {
      "type": "integer",
      "minimum": 1,
      "maximum": 100
    },
    "cursor": {
      "anyOf": [
        {
          "type": "string",
          "maxLength": 131200
        },
        {
          "type": "null"
        }
      ]
    }
  },
  "required": ["orgId"],
  "additionalProperties": false
}

Example call

Your client initializes the MCP connection before this call. Example identifiers and values are illustrative; use the IDs, schema version and values from your installation.

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "rootset_list_activity",
    "arguments": {
      "orgId": "01K6J7B8000000000000000000"
    }
  }
}

Result

Read the structured result returned by the tool. A tool failure sets isError; do not treat an error as a completed operation. The REST operation documents the corresponding result fields and errors. Connect an MCP client · REST conventions