v4

latestOpenAPI 3.0.3MIT2026-08-054021,2895.8 MB
Admin

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.

get/api/database/admin/views/

Query parameters

idsstring

A comma-separated list of views IDs to filter by. When provided, only views with those IDs are returned.

only_publicboolean

If set to true, only publicly shared views are returned.

pageinteger

Defines which page should be returned.

searchstring

If provided only views with id or name or slug or table__id or table__name or table__database__id or table__database__name or table__database__workspace__id or table__database__workspace__name or owned_by__id or owned_by__username that match the query will be returned.

sizeinteger

Defines how many views should be returned per page.

sortsstring

A comma separated string of attributes to sort by, each attribute must be prefixed with + for a descending sort or a - for an ascending sort. The accepted attribute names are: id, name, type, database_name, workspace_name, public, owned_by_username, created_on. For example sorts=-id,-name will sort the views first by descending id and then ascending name. A sortparameter with multiple instances of the same sort attribute will respond with the ERROR_INVALID_SORT_ATTRIBUTE error.

Response

countinteger required

The total amount of results.

nextstring uri nullable required

URL to the next page.

previousstring uri nullable required

URL to the previous page.