Skip to main content
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
​
search
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.

​
data
object[]
required

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

​
last_refreshed_at
string<date-time>

Timestamp of when the tables were last refreshed from the source

Example:

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