---
title: "Get filtered table data"
method: POST
path: "/databases/{id}/tables/data/get"
tags: ["Database"]
---

# Get filtered table data

`POST /databases/{id}/tables/data/get`

Get data from a database table with filtering

## Path parameters

- `id` string, required — MongoDB ObjectId represented as a hexadecimal string

## Query parameters

- `page` integer
- `size` integer

## Request body

- object
  - `table` string — Table name
  - `where` object — Where conditions
  - `sort` object — Sort options

## Response `200`

Filtered table data

- SuccessWithList
  - `code` integer
  - `message` string
  - `data` object
    - `list` object[]
    - `total` integer

## Changes

- **2025-03-02** `526e5bdf6dee` — 3 breaking, 7 warning, 15 info
  - request body became required
  - added the pattern `^[0-9a-fA-F]{24}$` to the `path` request parameter `id`
  - the `data` response's property type/format changed from `array`/`` to `object`/`` for status `200`
  - removed the request property `database`
  - …21 more

[Change history](https://skmtc.dev/crawlab-team/apis/crawlab-api/changes/databases/:id/tables/data/get/post.md)

---

[API](https://skmtc.dev/crawlab-team/apis/crawlab-api.md) · [All operations](https://skmtc.dev/crawlab-team/apis/crawlab-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/crawlab-team/crawlab-api/revisions/14e4eafea538/schema)