---
title: "GET /api/database/admin/views/"
method: GET
path: "/api/database/admin/views/"
tags: ["Admin"]
---

# GET /api/database/admin/views/

`GET /api/database/admin/views/`

Returns all database views in the instance with information about the table, database and workspace they belong to, if the requesting user is staff. This can for example be used to find and intervene with publicly shared views that are being abused.

## Query parameters

- `ids` string
- `only_public` boolean
- `page` integer
- `search` string
- `size` integer
- `sorts` string

## Response `200`

- PaginationSerializerAdminView
  - `count` integer, required — The total amount of results.
  - `next` string, uri, nullable, required — URL to the next page.
  - `previous` string, uri, nullable, required — URL to the previous page.
  - `results` AdminView[], required
    - `id` integer, required
    - `name` string, required
    - `slug` string — The unique slug where the view can be accessed publicly on.
    - `type` string, required
    - `table_id` integer, required
    - `table_name` string, required
    - `database_id` integer, required
    - `database_name` string, required
    - `workspace_id` integer, required
    - `workspace_name` string, required
    - `public` boolean — Indicates whether the view is publicly accessible to visitors.
    - `public_view_has_password` boolean, required
    - `owned_by_id` integer, required
    - `owned_by_username` string, required
    - `ownership_type` string — Indicates how the access to the view is determined. By default, views are collaborative and shared for all users that have access to the table.
    - `created_on` string, date-time, required

## Other responses

- `400`
- `401` — No response body

---

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