---
title: "Get the database columns (properties)"
method: GET
path: "/public/api/v1/databases/{databaseId}/fields"
tags: ["Fields"]
---

# Get the database columns (properties)

`GET /public/api/v1/databases/{databaseId}/fields`

## Path parameters

- `databaseId` string, required

## Query parameters

- `Pagination` object
  - `nextPageToken` string
  - `limit` integer
- `fieldIds` string[]

## Response `200`

OK

- FieldsResponse
  - `data` union[], required
    - union
      - FieldResponse
        - `isMirror` boolean, required
        - `id` string, required
        - `title` string, required
        - `type` 'id' | 'text' | 'number' | 'percent' | 'checkbox' | 'date' | 'duration' | 'currency' | 'singleSelect' | 'multiSelect' | 'linkToDatabase' | 'formula', required
        - `readerIds` string[]
      - SingleSelectFieldResponse
        - `isMirror` boolean, required
        - `id` string, required
        - `title` string, required
        - `type` 'id' | 'text' | 'number' | 'percent' | 'checkbox' | 'date' | 'duration' | 'currency' | 'singleSelect' | 'multiSelect' | 'linkToDatabase' | 'formula', required
        - `readerIds` string[]
        - `allowedEnumValues` OptionWithColor[], required
          - `id` string
          - `name` string, required
          - `color` 'Brown' | 'Red' | 'Purple' | 'Indigo' | 'DarkBlue' | 'Blue' | 'Turquoise' | 'DarkCyan' | 'Green' | 'YellowGreen' | 'Yellow' | 'Orange' | 'Gray' | 'DarkRed'
      - MultiSelectFieldResponse
        - `isMirror` boolean, required
        - `id` string, required
        - `title` string, required
        - `type` 'id' | 'text' | 'number' | 'percent' | 'checkbox' | 'date' | 'duration' | 'currency' | 'singleSelect' | 'multiSelect' | 'linkToDatabase' | 'formula', required
        - `readerIds` string[]
        - `allowedEnumValues` OptionWithColor[], required
          - `id` string
          - `name` string, required
          - `color` 'Brown' | 'Red' | 'Purple' | 'Indigo' | 'DarkBlue' | 'Blue' | 'Turquoise' | 'DarkCyan' | 'Green' | 'YellowGreen' | 'Yellow' | 'Orange' | 'Gray' | 'DarkRed'
      - LinkToDatabaseFieldResponse
        - `isMirror` boolean, required
        - `id` string, required
        - `title` string, required
        - `type` 'id' | 'text' | 'number' | 'percent' | 'checkbox' | 'date' | 'duration' | 'currency' | 'singleSelect' | 'multiSelect' | 'linkToDatabase' | 'formula', required
        - `readerIds` string[]
        - `databaseId` string, required
        - `allowMultipleEntries` boolean, required
        - `mirrorFields` MirrorField[]
          - `id` string, required
          - `title` string, required
          - `fieldId` string, required
  - `total` integer, required
  - `nextPageToken` string

---

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