List source objects

curl --request GET \
  --url https://app.getcensus.com/api/v1/sources/{source_id}/objects \
  --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": [
    {
      "type": "model",
      "id": 18,
      "name": "New App Users",
      "dataset_id": 12,
      "description": "Users that have signed up for our product in the last week.",
      "query": "SELECT * FROM \"users\"",
      "created_at": "2021-10-20T02:43:07.120Z",
      "updated_at": "2021-10-20T02:50:35.477Z",
      "compiled_query": null,
      "columns": [
        {
          "name": "user_id",
          "type": "character varying (256)"
        },
        {
          "name": "full_name",
          "type": "character varying (256)"
        }
      ],
      "dataset_id=": 12,
      "source_object_id": 20
    }
  ]
}

GET

sources

{source_id}

objects

List source objects

curl --request GET \
  --url https://app.getcensus.com/api/v1/sources/{source_id}/objects \
  --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": [
    {
      "type": "model",
      "id": 18,
      "name": "New App Users",
      "dataset_id": 12,
      "description": "Users that have signed up for our product in the last week.",
      "query": "SELECT * FROM \"users\"",
      "created_at": "2021-10-20T02:43:07.120Z",
      "updated_at": "2021-10-20T02:50:35.477Z",
      "compiled_query": null,
      "columns": [
        {
          "name": "user_id",
          "type": "character varying (256)"
        },
        {
          "name": "full_name",
          "type": "character varying (256)"
        }
      ],
      "dataset_id=": 12,
      "source_object_id": 20
    }
  ]
}

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

Response

200 - application/json

Successfully retrieved the list of source objects.

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. A list of source objects that this connection contains. May be either a Model, Segment, or Table.

Option 1
Option 2
Option 3

Show child attributes

data.type

enum<string>

The type of this source object, will always be model.

Available options:

model

Example:

"model"

data.id

integer

The id of this model.

Example:

18

data.name

string

The name of this model.

Example:

"New App Users"

data.dataset_id

integer | null

The identifier for the dataset that corresponds to this model. A model will always have a corresponding dataset unless the model belongs to a dbt, looker, sigma recipe that has not been used in Census

Example:

12

data.description

string

The description for this model.

Example:

"Users that have signed up for our product in the last week."

data.query

string

The SQL query associated with this model.

Example:

"SELECT * FROM \"users\""

data.created_at

string<date-time>

When this model was created.

Example:

"2021-10-20T02:43:07.120Z"

data.updated_at

string<date-time>

When this model was last updated.

Example:

"2021-10-20T02:50:35.477Z"

data.compiled_query

string | null

The compiled query associated with this model if it is built atop a DBT instance.

Example:

null

data.columns

object[]

A list of columns from this model.

Show child attributes

data.columns.name

string

The name of the column.

Example:

"email"

data.columns.type

string

The data type of the column.

Example:

"character varying (256)"

Example:

[
  {
    "name": "user_id",
    "type": "character varying (256)"
  },
  {
    "name": "full_name",
    "type": "character varying (256)"
  }
]

data.dataset_id=

integer | null

deprecated

[Deprecated] Identical to dataset_id but with a typo. Will be removed in a future version.

Example:

12

data.source_object_id

integer

deprecated

[Deprecated] The source object ID for this model. You can typically ignore this.

Example:

20

Delete source List models

⌘I

Introduction

Organization APIs

Workspace APIs

List source objects

Authorizations

Path Parameters

Query Parameters

Response