---
title: "Get offset-paginated roster rows from Spanner"
method: GET
path: "/roster-records/{rosterId}/paged"
tags: ["RosterRecord"]
---

# Get offset-paginated roster rows from Spanner

`GET /roster-records/{rosterId}/paged`

Returns an offset-based paginated list of roster rows with totalCount and totalPages.

## Path parameters

- `rosterId` string, required

## Query parameters

- `page` integer
- `size` integer
- `statuses` string

## Headers

- `tenant-id` string, required

## Response `200`

Paginated roster rows (offset-based)

- RosterRowsOffsetPage
  - `data` RosterRowItem[]
    - `rowId` string
    - `status` string
    - `data` JsonNode
      - `empty` boolean
      - `valueNode` boolean
      - `containerNode` boolean
      - `missingNode` boolean
      - `array` boolean
      - `object` boolean
      - `nodeType` 'ARRAY' | 'BINARY' | 'BOOLEAN' | 'MISSING' | 'NULL' | 'NUMBER' | 'OBJECT' | 'POJO' | 'STRING'
      - `pojo` boolean
      - `number` boolean
      - `integralNumber` boolean
      - `floatingPointNumber` boolean
      - `short` boolean
      - `int` boolean
      - `long` boolean
      - `float` boolean
      - `double` boolean
      - `bigDecimal` boolean
      - `bigInteger` boolean
      - `textual` boolean
      - `boolean` boolean
      - `null` boolean
      - `binary` boolean
    - `createdAt` string
    - `updatedAt` string
  - `page` integer
  - `size` integer
  - `totalCount` integer
  - `totalPages` integer
  - `hasMore` boolean

## Other responses

- `400` — Invalid input
- `401` — Unauthorized - Authentication required
- `403` — Forbidden - Insufficient permissions

---

[API](https://skmtc.net/certifyos/apis/certify-api-layer.md) · [All operations](https://skmtc.net/certifyos/apis/certify-api-layer/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/certifyos/certify-api-layer/revisions/3d27e9019c7b/schema)