# List Extension Table Rows

`GET /extensions-admin/{slug}/tables/{table}/rows` · Core · Extensions

Lists the rows of one of an installed extension's own tables, a page at a time. `order` is `created_at` or `updated_at` (the default) and `dir` is `asc` or `desc` (the default); the row id breaks ties, so every row appears once across pages. Pass the returned `cursor` to read the next page; it is null on the last page.

`limit` defaults to 100, and a value above 1000 reads 1000. Timestamps come back as ISO 8601 with an offset, to the microsecond. Reads are not written to the audit log.

Only a signed-in operator reaches it: a plugin token, a personal access token, a service token and an end user are refused. The caller needs a project membership; an org role alone gets nothing here. The table must be one the installed version's manifest lists in `schema.user_tables`, and the caller's project role must be in the set its `min_role` names: `PROJECT_ANALYST` admits analysts, editors, authors and admins, never an auditor alone.

## Parameters

| Name | In | Required | Description |
|---|---|---|---|
| `projectSlug` | path | yes | The project's slug. Example: `"storefront"`. |
| `slug` | path | yes | The installed extension's slug. Example: `"lookout"`. |
| `table` | path | yes | A table the extension's manifest lists in `schema.user_tables`. Example: `"lk_slos"`. |
| `limit` | query | no | The page size, an integer from 1. Default 100; a larger value than 1000 reads as 1000. |
| `cursor` | query | no | The `cursor` the previous page returned. |
| `order` | query | no | `created_at` or `updated_at` (the default). |
| `dir` | query | no | `asc` or `desc` (the default). |

## Responses

- **200**: Success

| Field | Type | Required | Description |
|---|---|---|---|
| `data` | object | yes | One page of rows and the cursor for the next. |
| `data.rows` | array of object | yes | One page of rows, in the order asked for, with the row id as the tiebreak. |
| `data.cursor` | object | yes | Pass it as `cursor` to read the next page. It is null on the last page. |
| _one of_ | | |  |
| _or_ | | |  |
| `meta` | object | yes |  |


## Errors

| HTTP | Code | When |
|---|---|---|
| 401 | `K9O_UNAUTHENTICATED` | The caller is not signed in. |
| 403 | `K9O_FORBIDDEN` | The caller is not an operator session (`context.reason: "principal_not_admitted"`), or their project role is not in the table's `min_role` set (`context.reason: "below_min_role"`, `context.minRole`). |
| 403 | `K9O_ACCESS_DENIED` | The caller has no membership in this project; an org role alone does not count. |
| 403 | `K9O_IAM_POLICY_DENIED` | A bound IAM policy denies extensions:table_read or extensions:table_write on this extension. |
| 404 | `K9O_EXTENSION_NOT_INSTALLED` | No extension with this slug is installed on the project. |
| 403 | `K9O_EXTENSION_DISABLED` | The extension is installed but not enabled. |
| 404 | `K9O_EXTENSION_TABLE_NOT_FOUND` | The extension has no user table by this name: it is not in the manifest's `schema.user_tables`, or it does not exist. Both answer the same. |
| 409 | `K9O_STATE_CONFLICT` | The table does not have the user-table shape (`context.reason: "user_table_shape"`, `context.column`): an `id text` primary key, `created_by text NOT NULL`, and `created_at` and `updated_at` `timestamptz NOT NULL`. |
| 429 | `K9O_EXTENSION_BFF_RATE_LIMITED` | Too many calls from this caller to this extension; retry after a second. |
| 400 | `K9O_INVALID_FIELD_VALUE` | `limit` is not a positive integer, `order` is not created_at or updated_at, `dir` is not asc or desc, or `cursor` is not one this route returned. |

## Code samples

### cURL

```bash
curl -X GET 'https://<org>.api-<region>.k9o.io/@storefront/extensions-admin/demoext/tables/<table>/rows' \
  -H 'Authorization: Bearer $K9O_TOKEN'
```

### fetch

```javascript
const res = await fetch('https://<org>.api-<region>.k9o.io/@storefront/extensions-admin/demoext/tables/<table>/rows', {
  method: 'GET',
  headers: {
    'Authorization': `Bearer ${process.env.K9O_TOKEN}`
  },
});
const { data, meta } = await res.json();
```


Canonical page: https://docs.kilimanjaro.dev/api-playground/core/list-extension-table-rows
