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.

Request schema

Path parameters

source_id

integerrequired

ID of the source

Query parameters

page

number

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

default:

per_page

number

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

default:

maximum:

100

order

string

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

default:

desc

enum:

"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

Header parameters

Authorization

stringrequired

HTTP: basicAuth

HTTP AuthorizationScheme: basic

Http + 1.1

GET

https://app.getcensus.com/api/v1/sources/{source_id}/tables

GET /api/v1/sources/{source_id}/tables?page=SOME_NUMBER_VALUE&per_page=SOME_NUMBER_VALUE&order=SOME_STRING_VALUE&search=customer&order_by=table_schema%3Adesc%2Ctable_name%3Aasc HTTP/1.1
Authorization: Bearer REPLACE_BEARER_TOKEN
Host: app.getcensus.com

Responses

200

Successfully retrieved the list of tables.

202

Tables have not been loaded yet. Kicking off a job to fetch them.

400

Failed to refresh source tables.

`200`

status

stringrequired

The outcome of the request

enum:

"success"

pagination

objectrequired

An object to help you navigate the list of results.

total_records

number

Total records in the collection.

example:

per_page

number

Records on each page.

default:

example:

prev_page

number | null

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

example:

page

number

The current page number.

default:

example:

next_page

number | null

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

example:

last_page

number

The number of the last page with records.

example:

data

arrayrequired

List of tables and views available in the source

table_catalog

string

The catalog or database name

example:

production

table_schema

string

The schema name

example:

public

table_name

string

The table or view name

example:

customers

last_refreshed_at

string

Timestamp of when the tables were last refreshed from the source

format:

date-time

example:

2025-10-30T21:38:51.424Z

`202`

status

string

example:

processing

`400`

status

string

example:

error

message

string

example:

Failed to refresh source tables

{
  "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"
}