Fetch dataset

Returns a single dataset. Supports SQL datasets.

Request schema

Path parameters

dataset_id

integerrequired

ID of the dataset

Header parameters

Authorization

stringrequired

HTTP: basicAuth

HTTP AuthorizationScheme: basic

Http + 1.1

GET

https://app.getcensus.com/api/v1/datasets/{dataset_id}

GET /api/v1/datasets/{dataset_id} HTTP/1.1
Authorization: Bearer REPLACE_BEARER_TOKEN
Host: app.getcensus.com

Responses

200

Successfully retrieved the dataset

401

Invalid credentials for the requested resource.

403

The feature you're trying to use is not available for your organization.

404

Resource not found.

`200`

status

string

Outcome of the operation.

enum:

"success""not_found""error"

data

object

type

stringrequired

sql

Type of dataset

default:

sql

enum:

"sql"

query

stringrequired

SQL query that defines the dataset

example:

SELECT id, name, email FROM users WHERE active = true

source_id

integerrequired

ID of the source connection

example:

123

`401`

status

integer

HTTP status code.

enum:

"401"

`403`

status

integer

HTTP status code.

enum:

"403"

message

string

Error message.

example:

The feature you're trying to use is not available for your organization.

`404`

status

integer

HTTP status code.

enum:

"404"

{
  "status": "success",
  "data": {
    "type": "sql",
    "query": "SELECT id, name, email FROM users WHERE active = true",
    "source_id": 123
  }
}