---
title: "List / filter objects"
method: GET
path: "/v1/tables"
tags: ["Schema"]
---

# List / filter objects

`GET /v1/tables`

## Request

- Base URL: `https://api.rossdata.dev`
- URL: `https://api.rossdata.dev/v1/tables`
- Auth: none declared

List / filter objects (tables, views, procedures, functions).

## Query parameters

- `type` 'TABLE' | 'VIEW' | 'PROCEDURE' | 'FUNCTION'
- `db` 'FIN' | 'MAN'
- `module` string
- `q` string
- `limit` integer
- `offset` integer

## Response `200`

OK

- ObjectList
  - `total` integer: Total matches before pagination
  - `offset` integer
  - `limit` integer
  - `count` integer: Objects in this page
  - `objects` ObjectSummary[]
    - `name` string
    - `type` 'table' | 'view' | 'procedure' | 'function'
    - `database` 'FIN' | 'MAN', nullable
    - `module` string, nullable
    - `class` string, nullable: e.g. 'ref' for a lookup table
    - `columns` integer
    - `hasPrimaryKey` boolean
    - `usedByPrograms` integer
    - `usedByViewsProcs` integer
    - `url` string, uri

---

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