Chat Conversation

Documentation Index

Fetch the complete documentation index at: https://docs.wellapp.ai/llms.txt

Use this file to discover all available pages before exploring further.

​

API operations

​

Data model

​

Attributes

​

Relationships

​

System-computed

• thread_id is the public resource identifier, generated via defaultRaw: gen_random_uuid() at INSERT time. The internal pk (auto-increment integer) is never exposed via the API.
• created_at is set once by the MikroORM onCreate lifecycle hook (new Date()) and is never subsequently modified.
• updated_at is set by both onCreate and onUpdate lifecycle hooks, reflecting the wall-clock time of every PATCH or write. It carries an explicit @Index decorator for ORDER BY performance.
• deleted_at uses soft-delete semantics consistent with the rest of the platform, but ChatConversation is an explicitly listed exception in apps/api/CLAUDE.md to the standard soft-delete filter (‘append-only audit log’ category).
• messages defaults to an empty array [] at entity construction. Parts within each message element use the PersistedPart discriminated union (type-tagged), making round-tripped history messages safely hydrable from JSONB.
• tabs defaults to an empty array [] at entity construction. As of Migration20260522150000, tabs are keyed objects (PersistedTab[]) rather than the legacy string[]. The migration backfilled all existing rows: new_tab elements received gen_random_uuid() keys; all other destinations used their destinationId as the key.
• active_tab_key replaced the legacy active_path varchar(512) column in Migration20260522150000. The migration extracted the active destination from active_path URLs via regex prefix matching against the known WORKSPACE_DESTINATIONS segment list, then dropped the active_path column.
• total_tokens defaults to 0 at construction and is incremented by the AI chat service after each model call. It is never reset.
• The compound index idx_chat_conversations_workspace_deleted (workspace_pk, deleted_at) was added in Migration20260416000000 specifically to accelerate the Hasura hot-path permission filter (workspace_pk = $1 AND deleted_at IS NULL).
• The partial composite index idx_chat_conversations_workspace_source_updated (workspace_pk, source, updated_at DESC) WHERE deleted_at IS NULL was added in Migration20260427160000 to accelerate surface-filtered recency-sorted list queries (the web app and extension history panels each filter by their own source value).
• source was backfilled by Migration20260427160000 for all pre-existing rows using a page_path heuristic: rows with a non-null page_path not starting with /workspaces/ were set to ‘extension’; all others were set to ‘web’. Only rows created via the API without a source value remain NULL.
• There is no sourceWorkspaceConnector relation. ChatConversation rows are created exclusively by the chat service in response to user actions; they are not produced by connector syncs.
• source is nullable (rows created via the API without a source field). The frontend’s surface-filtering logic treats NULL as ‘unknown’ and shows those conversations on both surfaces.

​

Example

{
  "data": {
    "type": "chat_conversation",
    "id": "c7e1a2f3-88d4-4b9e-9c6a-3f0e1d2b5a7c",
    "attributes": {
      "thread_id": "c7e1a2f3-88d4-4b9e-9c6a-3f0e1d2b5a7c",
      "title": "Q1 invoice reconciliation",
      "mode": "agent",
      "source": "web",
      "page_path": "/workspaces/9f3e2d1a-7b4c-4e5f-8a2b-1c0d3e6f9a8b/records/invoices",
      "total_tokens": 14832,
      "messages": [
        {
          "role": "user",
          "content": "Show me all unpaid invoices from March",
          "ts": "2026-05-14T09:12:33.000Z"
        },
        {
          "role": "assistant",
          "content": "I found 7 unpaid invoices from March totalling EUR 34,200.",
          "parts": [
            { "type": "text", "text": "I found 7 unpaid invoices from March totalling EUR 34,200." }
          ],
          "ts": "2026-05-14T09:12:36.000Z"
        }
      ],
      "context": {
        "root": "invoices",
        "lastGqlQuery": "{ invoices(where: { status: { _eq: \"unpaid\" } }) { id amount } }",
        "queryResult": null,
        "columns": ["id", "amount", "status", "due_date"],
        "rowCount": 7,
        "sampleRow": { "id": "inv_001", "amount": 4800, "status": "unpaid" },
        "whereClause": { "status": { "_eq": "unpaid" } },
        "orderBy": { "field": "due_date", "direction": "asc" },
        "fields": [["id"], ["amount"], ["status"]],
        "selectionType": "rows",
        "selectedCells": null,
        "selectedColumns": null,
        "documentAnalysisSummary": null,
        "gcsPath": null
      },
      "tabs": [
        { "key": "invoices", "destinationId": "invoices" },
        { "key": "3a9c1e2d-44b7-4f0e-8c6a-2b1d3e5f7a9c", "destinationId": "new_tab", "subPath": "/workspaces/9f3e2d1a/new-tab" }
      ],
      "active_tab_key": "invoices",
      "deleted_at": null,
      "created_at": "2026-05-14T09:12:30.000Z",
      "updated_at": "2026-05-14T09:12:36.000Z"
    },
    "relationships": {
      "workspace": {
        "data": { "type": "workspace", "id": "9f3e2d1a-7b4c-4e5f-8a2b-1c0d3e6f9a8b" }
      }
    }
  }
}