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

# Get table change status

> A table's active runs plus change watermarks for rows, columns, display preferences, and the definition, in one response.

NOT A POLLING TARGET. The grid now receives changes over the change feed (`GET /tables/{table_id}/events/`) and fetches this once on load for its initial active-run state. It remains useful to any client that wants a cheap point-in-time snapshot without opening a stream.

Preferences are watermarked separately from columns so a hide, pin, resize, or recolour refreshes the column list alone. A client comparing two responses must compare for inequality — never ordering: max timestamps can move backward when the newest row or column is hard-deleted (the counts catch deletes). All timestamps are server-generated; never compare them to the client clock. There is deliberately no table-existence 404: an unknown or foreign table returns empty runs and null/zero watermarks, which leaks nothing (same no-leak contract as the active-runs endpoint). The org-scoped definition read gates the row aggregate, so a foreign table ID never reaches the (potentially large) row index.



## OpenAPI

````yaml /openapi.json get /tables/{table_id}/status/
openapi: 3.1.0
info:
  contact:
    email: support@getoneprofile.ai
    name: Oneprofile Support
  description: >-
    REST API reference for Oneprofile, the GTM data layer for your CRM. Manage
    tables, enrichments, and integrations. Authenticate with an API key to get
    started.
  termsOfService: https://www.getoneprofile.ai/terms
  title: API Reference | Oneprofile
  version: '0.0'
servers:
  - url: https://api.getoneprofile.ai
security: []
tags:
  - description: Sender profiles, connected mailboxes, tags, and the Google connect flow.
    name: senders
  - description: The workspace do-not-contact list, enforced before every send.
    name: suppression
  - description: 'Sequence authoring: the graph, the table-backed audience, previews.'
    name: sequences
  - description: >-
      The LinkedIn channel: connecting an account to a sender, its safety limits
      and history, and the protocol the browser extension speaks.
    name: linkedin
  - description: 'The unified outreach inbox: threads, replies, labels, events.'
    name: inbox
  - description: 'The AI reply layer: workspace settings, drafts, and approval.'
    name: inbox-ai
  - description: Notification rules, per-user preferences, and the Slack connection.
    name: notifications
  - description: Endpoints for seeing all available integration types.
    name: integration-types
  - description: Endpoints for creating and managing integrations.
    name: integrations
  - description: Endpoints for the generic OAuth install/claim app-listings engine.
    name: app-listings
  - description: Endpoints for creating and managing API keys.
    name: apikey
  - description: Endpoints for managing billing and subscription information.
    name: billing
  - description: Endpoints for creating and managing tables.
    name: tables
  - description: Endpoints for table columns, formula previews, and on-demand column runs.
    name: table-columns
  - description: Endpoints for table rows and manual cell edits.
    name: table-rows
  - description: Endpoints for observing and cancelling table recompute runs.
    name: table-runs
  - description: >-
      Endpoints for org-shared per-column display preferences: hidden, pinned,
      width, and colour tint.
    name: table-ui-prefs
  - description: >-
      Endpoints for the org-shared names given to the column tint palette: what
      this organisation calls each colour. Org-level, not per-table.
    name: table-column-color-labels
  - description: >-
      Endpoints for the enrichment action catalog, model list, presets, draft
      generation, and saved agents.
    name: table-enrichments
  - description: >-
      Endpoints for teaching a saved agent from example rows: training sessions,
      per-row feedback, and the proposed prompt to approve.
    name: agent-training
  - description: >-
      The durable audit trail of a table's enrichment actions: configured,
      edited, run, cancelled, and settled cost.
    name: table-enrichment-audit-logs
  - description: Endpoints for saving and applying column templates.
    name: table-templates
  - description: Server-sent change feed for a table's grid.
    name: table-events
  - description: 'Endpoints for org-shared saved table views: sort, filters, hidden columns.'
    name: table-views
  - description: >-
      The per-table AI Assistant: named conversations, the column suggestions a
      build turn produces, and the questions an analyze turn answers.
    name: table-assistant
  - description: >-
      Endpoints for PER-USER table preferences: favourites and recently opened.
      Unlike the rest of the table surface these are personal, so two members of
      one organisation legitimately see different answers.
    name: table-user-prefs
  - description: >-
      Endpoints for building a table from an uploaded CSV: upload and preview
      the inferred columns, commit the reviewed mapping, then poll the row load.
    name: table-imports
  - description: Endpoint for downloading a table's rows as CSV.
    name: table-export
  - description: >-
      Endpoints for the integration a table imports from: attach and preview it,
      promote imported fields into columns, and run the import on demand.
    name: table-sources
  - description: >-
      Endpoints for a table's recurring import cadence: set it, pause it, and
      read the next fire times.
    name: table-schedules
  - description: >-
      Endpoints for pushing a table's rows out to a connected integration: list
      writable destinations, derive their write capabilities, and map export
      columns.
    name: table-writeback
  - description: >-
      Endpoints backing a lookup column's setup: the connections whose records a
      column could read, and the identity fields one record type can be looked
      up by.
    name: table-integration-lookup
  - description: >-
      Endpoints for sourcing leads from the lead database: count and preview
      matches, land them in a table, and keep saved searches.
    name: find-leads
  - description: >-
      Endpoints for discovering a domain's subdomains from public certificate
      logs and landing the results in a table.
    name: find-subdomains
  - description: Endpoints for the credit balance meter and usage reporting.
    name: credits
  - description: >-
      Endpoints for the workspace referral program: the shareable link, the
      friends who joined through it, and claiming a code after signup.
    name: referral
  - description: >-
      Endpoints for the design partner program's customer surface: whether this
      workspace is a design partner, the badges its feedback has earned, and
      sending and reading that feedback.
    name: design-partner
  - description: >-
      Endpoints for the org-level AI business context — company description,
      ideal customer profile, buyer personas and interest signals — plus
      domain-based generation.
    name: ai-context
paths:
  /tables/{table_id}/status/:
    get:
      tags:
        - tables
      summary: Get table change status
      description: >-
        A table's active runs plus change watermarks for rows, columns, display
        preferences, and the definition, in one response.


        NOT A POLLING TARGET. The grid now receives changes over the change feed
        (`GET /tables/{table_id}/events/`) and fetches this once on load for its
        initial active-run state. It remains useful to any client that wants a
        cheap point-in-time snapshot without opening a stream.


        Preferences are watermarked separately from columns so a hide, pin,
        resize, or recolour refreshes the column list alone. A client comparing
        two responses must compare for inequality — never ordering: max
        timestamps can move backward when the newest row or column is
        hard-deleted (the counts catch deletes). All timestamps are
        server-generated; never compare them to the client clock. There is
        deliberately no table-existence 404: an unknown or foreign table returns
        empty runs and null/zero watermarks, which leaks nothing (same no-leak
        contract as the active-runs endpoint). The org-scoped definition read
        gates the row aggregate, so a foreign table ID never reaches the
        (potentially large) row index.
      operationId: get_table_status
      parameters:
        - in: path
          name: table_id
          required: true
          schema:
            format: uuid
            title: Table Id
            type: string
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/TableStatusSchema'
          description: Successful Response
        '401':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/UnauthorizedResponse'
          description: Unauthorized
        '403':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ForbiddenResponse'
          description: Forbidden
        '422':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/UnprocessableEntityResponse'
          description: Invalid request made to the API.
        '500':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ServerErrorResponse'
          description: Internal server error.
        '502':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ServerErrorResponse'
          description: Bad gateway error.
        '503':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ServerErrorResponse'
          description: Service unavailable.
      security:
        - HTTPBearer: []
        - APIKeyHeader: []
components:
  schemas:
    TableStatusSchema:
      description: 'A point-in-time snapshot: active runs plus the four change watermarks.'
      properties:
        active_runs:
          description: Every active (pending/running/cancelling) run, newest first.
          items:
            $ref: '#/components/schemas/TableRunReadSchema'
          title: Active Runs
          type: array
        columns:
          $ref: '#/components/schemas/TableColumnsWatermarkSchema'
        last_finished_run:
          anyOf:
            - $ref: '#/components/schemas/TableRunReadSchema'
            - type: 'null'
          description: >-
            The newest run that has finished, whatever its outcome. Present so a
            client can distinguish a table whose last run FAILED from one that
            is simply idle — before this, both answered with no runs at all and
            the footer reported the table up to date moments after a run failed.
        paused_runs:
          description: >-
            Runs most recently stopped because the credit balance ran out
            mid-run — terminal, but the grid's most important fact until a fresh
            run supersedes them. Empty when nothing is paused.
          items:
            $ref: '#/components/schemas/TableRunReadSchema'
          title: Paused Runs
          type: array
        rows:
          $ref: '#/components/schemas/TableRowsWatermarkSchema'
        table_updated_at:
          anyOf:
            - format: date-time
              type: string
            - type: 'null'
          description: >-
            The definition's updated_at. Moves on rename/description edits AND
            on row-count maintenance (the counter lives on the definition row) —
            not a rename-only signal. Null only for an unknown table (the
            no-leak empty status).
          title: Table Updated At
        ui_prefs:
          $ref: '#/components/schemas/TableUIPrefsWatermarkSchema'
          description: >-
            Display-preferences watermark. Deliberately separate from `columns`:
            a hide, pin, resize, or recolour must refresh the column list alone,
            never the rows page and stats that a definition change refreshes.
      required:
        - active_runs
        - rows
        - columns
        - ui_prefs
        - table_updated_at
      title: TableStatusSchema
      type: object
    UnauthorizedResponse:
      properties:
        detail:
          description: The detail of why the request is unauthorized.
          title: Detail
          type: string
      required:
        - detail
      title: UnauthorizedResponse
      type: object
    ForbiddenResponse:
      properties:
        detail:
          description: The detail of why the request is forbidden.
          title: Detail
          type: string
      required:
        - detail
      title: ForbiddenResponse
      type: object
    UnprocessableEntityResponse:
      properties:
        detail:
          description: >-
            The detail of the error. This is the error message to show to the
            user. You should also use the issues field to show more detailed
            error messages per field. Use this field for a single liner error
            message.
          title: Detail
          type: string
        issues:
          description: >-
            The issues that caused the error. There can be multiple issues. Each
            issue is a user-facing error message.
          items:
            $ref: '#/components/schemas/UnprocessableEntityIssue'
          title: Issues
          type: array
      required:
        - detail
        - issues
      title: UnprocessableEntityResponse
      type: object
    ServerErrorResponse:
      properties:
        detail:
          description: The detail of why the server returned an error.
          title: Detail
          type: string
      required:
        - detail
      title: ServerErrorResponse
      type: object
    TableRunReadSchema:
      description: A table recompute run with its static denominator and monotone counters.
      properties:
        cells_done:
          description: >-
            Cells processed so far; clamped to cells_total so the banner can
            never overshoot.
          title: Cells Done
          type: integer
        cells_failed:
          description: Cells whose formula evaluation failed.
          title: Cells Failed
          type: integer
        cells_no_data:
          description: >-
            Cells that ran clean but found nothing. Free, never retried, and
            excluded from errored views. Counted within cells_done.
          title: Cells No Data
          type: integer
        cells_skipped:
          description: >-
            Cells the run deliberately skipped — a missing required input or a
            false run condition. Counted within cells_done.
          title: Cells Skipped
          type: integer
        cells_total:
          description: Exact static denominator, fixed when the run plan is minted.
          title: Cells Total
          type: integer
        column_id:
          anyOf:
            - format: uuid
              type: string
            - type: 'null'
          description: >-
            The column a column-lineage run recomputes, parsed from its workflow
            identity; null for whole-table runs. Narrows the grid's busy paint
            to one column — `row_scope` is what narrows it to the rows within
            that column.
          title: Column Id
        completed_at:
          anyOf:
            - format: date-time
              type: string
            - type: 'null'
          title: Completed At
        created_at:
          format: date-time
          title: Created At
          type: string
        error:
          anyOf:
            - type: string
            - type: 'null'
          description: Failure description when the run status is failed.
          title: Error
        export_retry_attempt:
          default: 0
          description: >-
            How many automatic export retries preceded this run. 0 is a run a
            person or a schedule asked for; higher values mark the follow-ups
            queued for rows whose push failed for a retryable reason, so a run
            history can tell 'we tried again' from 'you ran it again'.
          title: Export Retry Attempt
          type: integer
        id:
          format: uuid
          title: Id
          type: string
        row_scope:
          $ref: '#/components/schemas/TableRunRowScopeReadSchema'
          description: >-
            The rows this run resolved to at mint. Present on every read so a
            resync cannot lose it and silently fall back to painting the whole
            column busy.
        started_at:
          anyOf:
            - format: date-time
              type: string
            - type: 'null'
          title: Started At
        status:
          $ref: '#/components/schemas/TableRunStatus'
          description: The run's lifecycle status.
        table_id:
          format: uuid
          title: Table Id
          type: string
        trigger:
          $ref: '#/components/schemas/TableRunTrigger'
          description: What kind of mutation requested the run.
      required:
        - id
        - table_id
        - trigger
        - status
        - cells_total
        - cells_done
        - cells_failed
        - cells_skipped
        - cells_no_data
        - error
        - created_at
        - started_at
        - completed_at
        - row_scope
      title: TableRunReadSchema
      type: object
    TableColumnsWatermarkSchema:
      description: 'The columns change watermark: column count plus newest column write.'
      properties:
        count:
          description: Number of columns in the table.
          title: Count
          type: integer
        max_updated_at:
          anyOf:
            - format: date-time
              type: string
            - type: 'null'
          description: >-
            Newest column updated_at; null when the table has no columns. Moves
            on create, rename, definition change, and reorder; deletes move
            `count` — compare for inequality, never ordering.
          title: Max Updated At
      required:
        - count
        - max_updated_at
      title: TableColumnsWatermarkSchema
      type: object
    TableRowsWatermarkSchema:
      description: |-
        The rows watermark: the authoritative row counter.

        There is no cell-write watermark here. Freshness is a per-cell fact now,
        and every cell write is already announced on the change feed as a delta
        the client applies directly — so a polled max(updated_at) over 100M cell
        rows would buy an index on the hottest table in the schema to answer a
        question nothing asks.
      properties:
        count:
          description: Exact row count, maintained atomically by row mutations.
          title: Count
          type: integer
      required:
        - count
      title: TableRowsWatermarkSchema
      type: object
    TableUIPrefsWatermarkSchema:
      description: >-
        The display-preferences change watermark: stored row count plus newest
        write.
      properties:
        count:
          description: Number of columns with customised display preferences.
          title: Count
          type: integer
        max_updated_at:
          anyOf:
            - format: date-time
              type: string
            - type: 'null'
          description: >-
            Newest preferences updated_at; null when no column is customised.
            Moves on every hide, pin, resize, and recolour; resets move `count`
            and can move this backward — compare for inequality, never ordering.
          title: Max Updated At
      required:
        - count
        - max_updated_at
      title: TableUIPrefsWatermarkSchema
      type: object
    UnprocessableEntityIssue:
      properties:
        input:
          anyOf:
            - type: string
            - type: integer
            - type: number
            - type: boolean
            - items: {}
              type: array
            - additionalProperties: true
              type: object
          description: The user's input that caused the error.
          title: Input
        loc:
          description: >-
            The location of the error. Always contains 1 or 2 elements. The
            first element is the type of location (e.g. 'body', 'query', 'path',
            'header'). The second element is the name of the field that caused
            the error. If the error is not related to a specific field, the
            second element is not present.
          items:
            type: string
          title: Loc
          type: array
        msg:
          description: The message of the error. The error message to show to the user.
          title: Msg
          type: string
        type:
          description: >-
            The type of the error. Useful for frontend code to handle different
            types of errors.
          title: Type
          type: string
      required:
        - loc
        - msg
        - type
        - input
      title: UnprocessableEntityIssue
      type: object
    TableRunRowScopeReadSchema:
      description: >-
        The rows a run resolved to — what lets a client mark exactly those busy.


        ``record_ids`` is populated for the ``record_ids`` kind alone.
        ``all_rows``

        and ``unlisted`` both mean "assume every row": the first because it is

        true, the second because the set was too large to carry on every frame.

        Collapsing them keeps a client's fallback one branch rather than two.
      properties:
        kind:
          $ref: '#/components/schemas/TableRunScopeKind'
          description: How the resolved row set is published.
        record_ids:
          anyOf:
            - items:
                format: uuid
                type: string
              type: array
            - type: 'null'
          description: The exact rows the run will touch; null unless kind is record_ids.
          title: Record Ids
        rows:
          anyOf:
            - type: integer
            - type: 'null'
          description: Rows the resolved scope covers; null for all rows.
          title: Rows
      required:
        - kind
        - rows
        - record_ids
      title: TableRunRowScopeReadSchema
      type: object
    TableRunStatus:
      description: >-
        Lifecycle status of a table run.


        ``PENDING`` exists for API compatibility but is never observed — runs
        are

        born ``RUNNING`` at mint. ``CANCELLING`` is the requested-stop state the

        page activities observe; the workflow finalizes it to ``CANCELLED``.
      enum:
        - pending
        - running
        - cancelling
        - cancelled
        - paused_for_credits
        - completed
        - completed_with_errors
        - failed
      title: TableRunStatus
      type: string
    TableRunTrigger:
      description: What kind of mutation requested a recompute run.
      enum:
        - cell_edited
        - row_added
        - row_manual
        - column_added
        - column_edited
        - column_manual
      title: TableRunTrigger
      type: string
    TableRunScopeKind:
      description: >-
        How a minted run's RESOLVED row set is published to readers.


        Distinct from :class:`TableRunScope`, which is what the caller ASKED
        for.

        The two disagree routinely — ``ALL`` on a ``keep_existing_results``
        table is

        silently narrowed to the unfilled rows at mint — and only the resolved
        set

        can be painted, so only the resolved set is stored.


        ``UNLISTED`` is a real row subset whose ids were too many to carry on
        every

        changefeed frame (see ``max_persisted_scope_rows``). It reads exactly
        like

        ``ALL_ROWS`` to a client: assume every row. That keeps the fallback one

        branch rather than two, at the cost of over-painting the rare huge
        partial.
      enum:
        - all_rows
        - record_ids
        - unlisted
      title: TableRunScopeKind
      type: string
  securitySchemes:
    HTTPBearer:
      scheme: bearer
      type: http
    APIKeyHeader:
      in: header
      name: X-API-Key
      type: apiKey

````