Skip to main content
GET
/
sources
/
{source_id}
/
tables
/
columns
List columns
curl --request GET \
  --url https://app.getcensus.com/api/v1/sources/{source_id}/tables/columns \
  --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": [
    {
      "name": "email",
      "data_type": "string",
      "can_be_upsert_key": true
    }
  ],
  "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

​
table_catalog
string
required

The catalog name of the table (e.g., database name in some systems).

​
table_schema
string
required

The schema name of the table.

​
table_name
string
required

The table name.

​
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

Response

Successfully retrieved the list of columns.

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 columns in the table

​
last_refreshed_at
string<date-time>

Timestamp of when the columns were last refreshed from the source table

Example:

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