---
updatedAt: 2026-02-24T14:46:00.000Z
agentTools:
  projectIndex: https://developers.wrike.com/llms.txt
---

# Get the database columns (properties)

# OpenAPI definition

```json
{
  "openapi": "3.0.1",
  "info": {
    "title": "Wrike DataHub API",
    "description": "This is Wrike DataHub public API.\n\nThere are several distinct entities\n\nData folders (not to be confused with Wrike Folders) are meant for organizing databases and navigation\n\nDatabase store actual user data as records (database rows) and define (through metadata) the record structure.\nThe record structure is defined as a collection of Fields",
    "version": "0.1.1"
  },
  "servers": [
    {
      "url": "https://www.wrike.com/app/wrike_v2_web"
    },
    {
      "url": "https://app-eu.wrike.com/app/wrike_v2_web"
    },
    {
      "url": "https://app-us2.wrike.com/app/wrike_v2_web"
    }
  ],
  "security": [
    {
      "bearer-auth": []
    }
  ],
  "paths": {
    "/public/api/v1/databases/{databaseId}/fields": {
      "get": {
        "tags": [
          "Fields"
        ],
        "summary": "Get the database columns (properties)",
        "operationId": "findFields",
        "parameters": [
          {
            "name": "databaseId",
            "in": "path",
            "required": true,
            "schema": {
              "type": "string"
            }
          },
          {
            "$ref": "#/components/parameters/Pagination"
          },
          {
            "$ref": "#/components/parameters/FieldsFilterGetRequest"
          }
        ],
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/FieldsResponse"
                },
                "examples": {
                  "Multiple fields": {
                    "description": "Multiple fields",
                    "value": {
                      "data": [
                        {
                          "type": "text",
                          "isMirror": false,
                          "id": "FI413230",
                          "title": "text property"
                        },
                        {
                          "type": "number",
                          "isMirror": false,
                          "id": "FI413231",
                          "title": "number property"
                        },
                        {
                          "type": "percent",
                          "isMirror": false,
                          "id": "FI413232",
                          "title": "percentage property"
                        },
                        {
                          "type": "checkbox",
                          "isMirror": false,
                          "id": "FI413233",
                          "title": "checkbox property"
                        },
                        {
                          "type": "duration",
                          "isMirror": false,
                          "id": "FI413234",
                          "title": "duration property"
                        },
                        {
                          "type": "currency",
                          "isMirror": false,
                          "id": "FI413235",
                          "title": "currency property"
                        },
                        {
                          "type": "date",
                          "isMirror": false,
                          "id": "FI413236",
                          "title": "datetime property"
                        },
                        {
                          "type": "singleSelect",
                          "id": "FI413237",
                          "title": "singleSelect property",
                          "allowedEnumValues": [
                            {
                              "id": "750b6b81-2f4b-42d1-bc5f-0506e37390ca",
                              "name": "name 1"
                            },
                            {
                              "id": "6b618b7d-537d-4f5a-a345-0f7968fc1537",
                              "name": "name 2",
                              "color": "YellowGreen"
                            }
                          ],
                          "isMirror": false
                        },
                        {
                          "type": "multiSelect",
                          "id": "FI413238",
                          "title": "multiSelect property",
                          "allowedEnumValues": [
                            {
                              "id": "93d4dfa2-1db9-4428-a698-7d21ad4a10d6",
                              "name": "name 3"
                            }
                          ],
                          "isMirror": false
                        },
                        {
                          "type": "linkToDatabase",
                          "id": "FI413239",
                          "title": "Link to database single property",
                          "databaseId": "DB399565",
                          "allowMultipleEntries": false,
                          "mirrorFields": [
                            {
                              "id": "FI413240",
                              "title": "Mirror field for Mirror Text property",
                              "fieldId": "FI413210"
                            }
                          ],
                          "isMirror": false
                        },
                        {
                          "type": "text",
                          "isMirror": true,
                          "id": "FI413240",
                          "title": "Mirror field for Mirror Text property"
                        },
                        {
                          "type": "linkToDatabase",
                          "id": "FI413260",
                          "title": "Link to database multiple property",
                          "databaseId": "DB399566",
                          "allowMultipleEntries": true,
                          "isMirror": false
                        }
                      ],
                      "total": 12
                    }
                  }
                }
              }
            }
          }
        },
        "deprecated": false
      }
    }
  },
  "components": {
    "schemas": {
      "OptionWithColor": {
        "required": [
          "name"
        ],
        "type": "object",
        "properties": {
          "id": {
            "type": "string"
          },
          "name": {
            "type": "string"
          },
          "color": {
            "type": "string",
            "enum": [
              "Brown",
              "Red",
              "Purple",
              "Indigo",
              "DarkBlue",
              "Blue",
              "Turquoise",
              "DarkCyan",
              "Green",
              "YellowGreen",
              "Yellow",
              "Orange",
              "Gray",
              "DarkRed"
            ]
          }
        }
      },
      "FieldResponse": {
        "required": [
          "id",
          "isMirror",
          "title",
          "type"
        ],
        "type": "object",
        "properties": {
          "isMirror": {
            "type": "boolean"
          },
          "id": {
            "type": "string"
          },
          "title": {
            "type": "string"
          },
          "type": {
            "type": "string",
            "enum": [
              "id",
              "text",
              "number",
              "percent",
              "checkbox",
              "date",
              "duration",
              "currency",
              "singleSelect",
              "multiSelect",
              "linkToDatabase",
              "formula"
            ]
          },
          "readerIds": {
            "uniqueItems": true,
            "type": "array",
            "items": {
              "type": "string"
            }
          }
        },
        "discriminator": {
          "propertyName": "type",
          "mapping": {
            "singleSelect": "#/components/schemas/SingleSelectFieldResponse",
            "multiSelect": "#/components/schemas/MultiSelectFieldResponse",
            "linkToDatabase": "#/components/schemas/LinkToDatabaseFieldResponse",
            "formula": "#/components/schemas/FormulaFieldResponse"
          }
        }
      },
      "FormulaFieldResponse": {
        "required": [
          "format",
          "formula",
          "id",
          "isMirror",
          "title",
          "type"
        ],
        "type": "object",
        "allOf": [
          {
            "$ref": "#/components/schemas/FieldResponse"
          },
          {
            "type": "object",
            "properties": {
              "formula": {
                "type": "string"
              },
              "format": {
                "type": "string",
                "enum": [
                  "number",
                  "currency",
                  "percent",
                  "hours",
                  "days",
                  "date"
                ]
              }
            }
          }
        ]
      },
      "LinkToDatabaseFieldResponse": {
        "required": [
          "allowMultipleEntries",
          "databaseId",
          "id",
          "isMirror",
          "title",
          "type"
        ],
        "type": "object",
        "allOf": [
          {
            "$ref": "#/components/schemas/FieldResponse"
          },
          {
            "type": "object",
            "properties": {
              "databaseId": {
                "type": "string"
              },
              "allowMultipleEntries": {
                "type": "boolean"
              },
              "mirrorFields": {
                "type": "array",
                "items": {
                  "$ref": "#/components/schemas/MirrorField"
                }
              }
            }
          }
        ]
      },
      "MirrorField": {
        "required": [
          "fieldId",
          "id",
          "title"
        ],
        "type": "object",
        "properties": {
          "id": {
            "type": "string"
          },
          "title": {
            "type": "string"
          },
          "fieldId": {
            "type": "string"
          }
        }
      },
      "MultiSelectFieldResponse": {
        "required": [
          "allowedEnumValues",
          "id",
          "isMirror",
          "title",
          "type"
        ],
        "type": "object",
        "allOf": [
          {
            "$ref": "#/components/schemas/FieldResponse"
          },
          {
            "type": "object",
            "properties": {
              "allowedEnumValues": {
                "type": "array",
                "items": {
                  "$ref": "#/components/schemas/OptionWithColor"
                }
              }
            }
          }
        ]
      },
      "SingleSelectFieldResponse": {
        "required": [
          "allowedEnumValues",
          "id",
          "isMirror",
          "title",
          "type"
        ],
        "type": "object",
        "allOf": [
          {
            "$ref": "#/components/schemas/FieldResponse"
          },
          {
            "type": "object",
            "properties": {
              "allowedEnumValues": {
                "type": "array",
                "items": {
                  "$ref": "#/components/schemas/OptionWithColor"
                }
              }
            }
          }
        ]
      },
      "FieldsResponse": {
        "required": [
          "data",
          "total"
        ],
        "type": "object",
        "properties": {
          "data": {
            "type": "array",
            "items": {
              "discriminator": {
                "propertyName": "type",
                "mapping": {
                  "singleSelect": "#/components/schemas/SingleSelectFieldResponse",
                  "multiSelect": "#/components/schemas/MultiSelectFieldResponse",
                  "linkToDatabase": "#/components/schemas/LinkToDatabaseFieldResponse"
                }
              },
              "oneOf": [
                {
                  "$ref": "#/components/schemas/FieldResponse"
                },
                {
                  "$ref": "#/components/schemas/SingleSelectFieldResponse"
                },
                {
                  "$ref": "#/components/schemas/MultiSelectFieldResponse"
                },
                {
                  "$ref": "#/components/schemas/LinkToDatabaseFieldResponse"
                }
              ]
            }
          },
          "total": {
            "type": "integer",
            "format": "int32"
          },
          "nextPageToken": {
            "type": "string"
          }
        }
      }
    },
    "parameters": {
      "Pagination": {
        "name": "Pagination",
        "in": "query",
        "description": "Pagination parameter",
        "required": false,
        "schema": {
          "type": "object",
          "properties": {
            "nextPageToken": {
              "type": "string"
            },
            "limit": {
              "maximum": 1000,
              "minimum": 1,
              "type": "integer",
              "format": "int32",
              "default": 100
            }
          }
        }
      },
      "FieldsFilterGetRequest": {
        "name": "fieldIds",
        "in": "query",
        "description": "Columns filter parameter",
        "required": false,
        "schema": {
          "type": "array",
          "items": {
            "type": "string"
          }
        }
      }
    },
    "securitySchemes": {
      "bearer-auth": {
        "type": "http",
        "description": "See details at [Wrike Developers Portal](https://developers.wrike.com/oauth-20-authorization/)",
        "scheme": "bearer",
        "bearerFormat": "JWT"
      }
    }
  }
}
```