---
title: "list records"
method: POST
path: "/object/list"
---

# list records

`POST /object/list`

## Request body

- object
  - `object_type` string — The name of table to fetch records
  - `sort` string — sort criteria
  - `page` integer
  - `size` string
  - `filters` object[] — Array of filters to be applied. The api apply AND operator to the given filters. Allowed values: ==, !=, >, <, >=, <=, like, starts, not like, in, is_null, is_not_null, null_or_empty, between
    - `field` string — The name of field
    - `value` string — Value to match filter
    - `operator` '==' | '!=' | '>' | '<' | '>=' | '<=' | 'like' | 'starts' | 'not like' | 'in' | 'is_null' | 'is_not_null' | 'null_or_empty' | 'between' — The operator to apply into field and value. If not provide, the equal operator will be assigned
  - `select` string[] — Choose fields you want select

## Response `200`

200

- object
  - `status` boolean
  - `data` object
    - `warnings` object[]
    - `items` object[]
      - `id_sample_table` integer
      - `name` string
      - `criado_por` object
        - `id_user` integer
        - `id_org` integer
        - `first_name` string
        - `last_name` string
        - `email` string
        - `id_profile` integer
        - `name` string
        - `has_preview` integer
        - `is_preview` integer
        - `birthdate` unknown
        - `city` unknown
        - `whatsapp` unknown
        - `phone` unknown
        - `personal_email` string
        - `status` unknown
      - `criado_em` string
      - `atualizado_por` integer
      - `atualizado_em` string
      - `binary_field` integer
      - `nested_field` object
        - `id_colors_are_fun` integer
        - `name` string
        - `criado_por` integer
        - `criado_em` string
        - `atualizado_por` integer
        - `atualizado_em` string
        - `pro_tip` string
        - `picture` string
        - `stack` string
      - `number_field` integer
      - `formula_field` integer
      - `boolean_field` unknown
    - `total` integer
  - `metadata` object
    - `response` string
    - `message` string

## Other responses

- `400` — 400

---

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