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

# Get the database records along with requested fields values

# 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}/records": {
      "get": {
        "tags": [
          "Records"
        ],
        "summary": "Get the database records along with requested fields values",
        "operationId": "findRecords",
        "parameters": [
          {
            "name": "databaseId",
            "in": "path",
            "required": true,
            "schema": {
              "type": "string"
            }
          },
          {
            "$ref": "#/components/parameters/Pagination"
          },
          {
            "$ref": "#/components/parameters/RecordsGetRequest"
          },
          {
            "$ref": "#/components/parameters/filter"
          },
          {
            "$ref": "#/components/parameters/searchQuery"
          },
          {
            "$ref": "#/components/parameters/FieldsGetRequest"
          }
        ],
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/RecordsResponse"
                }
              }
            }
          }
        },
        "deprecated": false
      }
    }
  },
  "components": {
    "schemas": {
      "RecordResponse": {
        "required": [
          "deleted",
          "fieldValues",
          "id",
          "title"
        ],
        "type": "object",
        "properties": {
          "id": {
            "type": "string"
          },
          "title": {
            "type": "string"
          },
          "deleted": {
            "type": "boolean"
          },
          "fieldValues": {
            "type": "object",
            "additionalProperties": {}
          }
        }
      },
      "RecordsResponse": {
        "required": [
          "data",
          "total"
        ],
        "type": "object",
        "properties": {
          "data": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/RecordResponse"
            }
          },
          "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
            }
          }
        }
      },
      "FieldsGetRequest": {
        "name": "fieldIds",
        "in": "query",
        "description": "Columns (properties) to be loaded in the result",
        "required": false,
        "schema": {
          "type": "array",
          "items": {
            "type": "string"
          }
        }
      },
      "RecordsGetRequest": {
        "name": "recordIds",
        "in": "query",
        "description": "Items filter parameter",
        "required": false,
        "schema": {
          "type": "array",
          "items": {
            "type": "string"
          }
        }
      },
      "filter": {
        "name": "filter",
        "in": "query",
        "description": "Filter parameter",
        "required": false,
        "schema": {
          "type": "string",
          "example": "{\"and\": [{\"or\": [{\"op\": \"equals\",\"fld\": \"FI123456\",\"val\": 224}]},{\"op\": \"isNotEmpty\",\"fld\": \"FI123654\"}]}"
        }
      },
      "searchQuery": {
        "name": "searchQuery",
        "in": "query",
        "description": "Search query by all fields. Special characters (\", <> etc. must be escaped). The value is ignored if items filter is provided",
        "required": false,
        "schema": {
          "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"
      }
    }
  }
}
```