---
title: "Search objects and columns"
method: GET
path: "/v1/search"
tags: ["Schema"]
---

# Search objects and columns

`GET /v1/search`

## Request

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

Search object and column names (and column descriptions).

## Query parameters

- `q` string
- `limit` integer

## Response `200`

OK

- SearchResult
  - `query` string
  - `objectCount` integer
  - `columnCount` integer
  - `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
  - `columns` object[]

---

[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)