---
title: "List a numbered record page"
method: GET
path: "/api/v1/records/page"
tags: ["Records"]
---

# List a numbered record page

`GET /api/v1/records/page`

## Request

- Base URL: `https://api-docs.busabase.com`
- URL: `https://api-docs.busabase.com/api/v1/records/page`
- Auth: none declared

## Query parameters

- `baseId` string, required: Required here, unlike `records.list` where omitting it spans the whole space.
- `viewId` string: Show only what this saved View would: its filters and its sort.
- `filters` object[]: Extra conditions ANDed with the View's own — "this View, further narrowed". Unlike `records.list`'s `filters`, these are EXACT: every page is precisely what the client's own matcher would keep, so a page is never missing records it should hold.
  - `fieldSlug` string, required
  - `fieldType` string
  - `operator` 'contains' | 'equals' | 'not_empty' | 'is_empty' | 'is_true' | 'is_false', required
  - `value` unknown
- `dateRange` object: Scope the page to a `date`/`created_time`/`updated_time` field falling in `[gte, lt)` — a half-open range of absolute UTC instants, not a `filters` condition. Resolve the bounds yourself: a day or a month only means something in a timezone, and the server does not know the viewer's.
  - `fieldSlug` string, required
  - `gte` string, required: Inclusive lower bound, ISO 8601 UTC instant.
  - `lt` string, required: EXCLUSIVE upper bound, ISO 8601 UTC instant.
- `sort` object: Sort by one field. Only number and date fields sort authoritatively (their typed value column matches a client's own ordering); any other field type is returned in the default order and left for the caller to sort. Replaces the saved View's sort when `viewId` is also given (the View's filters still apply). Empty values sort last; ties are broken by record id, so pages never overlap.
  - `fieldSlug` string, required
  - `fieldType` string
  - `direction` 'asc' | 'desc'
- `page` integer: 1-indexed, not 0-indexed.
- `pageSize` integer: Records per page. Capped at 100.

## Response `200`

A random-access page of active records. When viewId is supplied, the saved view is authoritatively filtered and sorted before total and page slicing are calculated. An explicit `sort` (same shape as `records.list`'s) replaces the View's sort, so page N of a number- or date-sorted list is one request. `dateRange` additionally scopes to a `[gte, lt)` UTC instant window on a date/created_time/updated_time field.

- object
  - `records` object[], required
    - `id` string, required
    - `baseId` string, required
    - `headCommitId` string, required
    - `parentRecordId` string, required
    - `parentCommitId` string, required
    - `status` 'active' | 'archived', required
    - `createdBy` string, required
    - `createdByUser` object
      - `id` string, required
      - `name` string, required
      - `email` string, required
      - `image` string, required
      - `role` string
    - `fieldUsers` object
    - `archivedAt` string, required
    - `createdAt` string, required
    - `updatedAt` string, required
    - `base` object, required
      - `id` string, required
      - `nodeId` string, required
      - `slug` string, required
      - `name` string, required
      - `description` string, required
      - `reviewPolicy` object, required
        - `kind` unknown, required
        - `requiredApprovals` number, required
      - `createdAt` string, required
      - `fields` object[], required
        - `id` string, required
        - `baseId` string, required
        - `slug` string, required
        - `name` union, required
          - string
          - object
        - `type` 'text' | 'longtext' | 'markdown' | 'html' | 'attachment' | 'relation' | 'member' | 'number' | 'date' | 'checkbox' | 'select' | 'multiselect' | 'url' | 'embed' | 'email' | 'phone' | 'created_time' | 'updated_time' | 'created_by' | 'updated_by' | 'auto_number' | 'ai_summary' | 'ai_tags' | 'code' | 'json' | 'yaml' | 'formula' | 'lookup' | 'whiteboard', required
        - `required` boolean, required
        - `position` number, required
        - `options` object
          - `help` object
            - `description` string
            - `example` string
          - `ai` object
            - `model` string
            - `prompt` string
            - `reviewRequired` boolean
            - `sourceFieldIds` string[]
          - `attachment` object
            - `allowedMimeTypes` string[]
          - `choices` object[]
            - `color` string
            - `id` string, required
            - `name` string, required
          - `code` object
            - `language` string
          - `date` object
            - `includeTime` boolean
            - `timezone` string: IANA time zone, e.g. "Asia/Shanghai". Omit to show each reader their own local time.
          - `embed` object
            - `aspectRatio` '16:9' | '4:3' | '1:1'
            - `providers` string[]
          - `formula` object
            - `expression` string, required
            - `format` 'auto' | 'number' | 'currency' | 'percent' | 'date'
            - `precision` integer
            - `currency` string
          - `inverseFieldId` string
          - `lookup` object
            - `relationFieldSlug` string, required: Slug of a `relation` field on THIS Base — the hop to follow.
            - `targetFieldSlug` string, required: Slug of the field on the related Base whose values are pulled over.
            - `rollup` 'values' | 'count' | 'sum' | 'average' | 'min' | 'max' | 'concatenate'
            - `limit` 'all' | 'first': `first` looks at only the first linked record; default `all`.
          - `multiple` boolean
          - `number` object
            - `format` 'plain' | 'currency'
            - `currency` string
            - `locale` string
          - `targetBaseId` string: Relation target Base id (bse_…). Or pass targetBaseSlug to name it by slug.
          - `targetBaseSlug` string: Relation target Base by slug — a convenience alias for targetBaseId, resolved server-side (active bases in the current space). If both are given, targetBaseId wins.
    - `headCommit` object, required
      - `id` string, required
      - `baseId` string, required
      - `targetType` 'base' | 'node', required
      - `nodeId` string, required
      - `operationId` string, required
      - `parentCommitId` string, required
      - `payload` object, required
      - `operation` 'node_create' | 'node_rename' | 'node_delete' | 'node_restore' | 'node_move' | 'record_create' | 'record_update' | 'record_delete' | 'record_variant' | 'view_create' | 'view_update' | 'view_delete' | 'view_restore' | 'base_add_field' | 'base_delete_field' | 'base_update_field' | 'base_convert_field' | 'base_reorder_fields' | 'base_restore_field' | 'base_archive' | 'base_restore' | 'record_restore' | 'skill_file_create' | 'skill_file_update' | 'skill_file_delete' | 'skill_metadata_update' | 'drive_file_create' | 'drive_file_update' | 'drive_file_delete' | 'drive_metadata_update' | 'airapp_file_create' | 'airapp_file_update' | 'airapp_file_delete' | 'airapp_metadata_update' | 'doc_update' | 'whiteboard_document_update' | 'workflow_document_update' | 'html_document_update', required
      - `message` string, required
      - `author` string, required
      - `authorUser` object
        - `id` string, required
        - `name` string, required
        - `email` string, required
        - `image` string, required
        - `role` string
      - `createdAt` string, required
  - `total` integer, required
  - `totalPages` integer, required
  - `page` integer, required
  - `pageSize` integer, required

---

[API](https://skmtc.dev/busabase/apis/busabase-api.md) · [All operations](https://skmtc.dev/busabase/apis/busabase-api/llms.txt) · [OpenAPI document](https://skmtc.dev/busabase/apis/busabase-api/revisions/bc6a7d5ff4c1?raw)