List tables

curl --request GET \
  --url https://app.getcensus.com/api/v1/sources/{source_id}/tables \
  --header 'Authorization: Bearer <token>'

{
  "status": "success",
  "pagination": {
    "total_records": 14,
    "per_page": 25,
    "prev_page": 1,
    "page": 2,
    "next_page": 3,
    "last_page": 10
  },
  "data": [
    {
      "table_catalog": "production",
      "table_schema": "public",
      "table_name": "customers"
    }
  ],
  "last_refreshed_at": "2025-10-30T21:38:51.424Z"
}

Tables

List tables

This endpoint returns the list of tables available in a source connection.

The tables can be loaded first by calling the refresh_tables endpoint and waiting for completion using refresh_tables_status.

If the tables have not been loaded yet, this endpoint will kick off a table refresh job.

This endpoint supports search, pagination, and sorting. Use the search parameter to filter tables by name, schema, or catalog. Use the page and per_page parameters to paginate through large result sets. Use the order_by parameter to sort results by table name, schema, or catalog.

GET

sources

{source_id}

tables

List tables

curl --request GET \
  --url https://app.getcensus.com/api/v1/sources/{source_id}/tables \
  --header 'Authorization: Bearer <token>'

{
  "status": "success",
  "pagination": {
    "total_records": 14,
    "per_page": 25,
    "prev_page": 1,
    "page": 2,
    "next_page": 3,
    "last_page": 10
  },
  "data": [
    {
      "table_catalog": "production",
      "table_schema": "public",
      "table_name": "customers"
    }
  ],
  "last_refreshed_at": "2025-10-30T21:38:51.424Z"
}

Authorizations

Authorization

string

header

required

Bearer token for the current workspace. Can be retrieved from the Workspace's settings page.

Path Parameters

source_id

integer

required

ID of the source

Query Parameters

page

number

default:1

Designates which page of results to return. Always starts at 1. If 0 is specified, it defaults to 1.

per_page

number

default:25

Determines the number of results on each page. It can't exceed 100.

Required range: x <= 100

order

enum<string>

default:desc

Organizes the results based on their creation time, either ascending or descending.

Available options:

asc,

desc

string

Search term to filter tables. Performs case-insensitive substring matching on table name, schema, and catalog. Example: customer will match tables named "customers", "customer_orders", or in schema "customer_analytics"

Example:

"customer"

order_by

string

Sort order for results. Format: field:direction where direction is asc or desc. Supported fields: table_name, table_schema, table_catalog.

Example:

"table_schema:desc,table_name:asc"

Response

Successfully retrieved the list of tables.

A successfully fetched list of results.

status

enum<string>

required

The outcome of the request

Available options:

success

Example:

"success"

pagination

object

required

An object to help you navigate the list of results.

Show child attributes

pagination.total_records

number

Total records in the collection.

Example:

14

pagination.per_page

number

default:25

Records on each page.

Example:

25

pagination.prev_page

number | null

The previous page number, or null for the first page.

Example:

1

pagination.page

number

default:1

The current page number.

Example:

2

pagination.next_page

number | null

The next page number, or null if it's the last page.

Example:

3

pagination.last_page

number

The number of the last page with records.

Example:

10

data

object[]

required

The list of results. List of tables and views available in the source

Show child attributes

data.table_catalog

string

The catalog or database name

Example:

"production"

data.table_schema

string

The schema name

Example:

"public"

data.table_name

string

The table or view name

Example:

"customers"

last_refreshed_at

string<date-time>

Timestamp of when the tables were last refreshed from the source

Example:

"2025-10-30T21:38:51.424Z"

Create a topic event Start table refresh

⌘I

Introduction

Organization APIs

Workspace APIs

List tables

Authorizations

Path Parameters

Query Parameters

Response