> ## Documentation Index
> Fetch the complete documentation index at: https://www.rootset.app/llms.txt
> Use this file to discover all available pages before exploring further.

# rootset_list_activity

> Search bounded record, schema and job activity under current permissions. Cursors preserve a fixed cutoff; refresh to include newer events.

## Workflow

```mermaid theme={"system"}
flowchart LR
  discover["Read the table schema"] --> invoke["List activity"]
  invoke --> outcome["Read the result"]
```

## 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. |

<Accordion title="Complete input schema">
  ```json theme={"system"}
  {
    "$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
  }
  ```
</Accordion>

## 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.

```json theme={"system"}
{
  "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](/api-reference/listActivity) documents the corresponding result fields and errors.

[Connect an MCP client](/mcp-guide) · [REST conventions](/api-reference/overview)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.