Update dataset
Updates 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
Request
name
string
The name of the dataset
example:
Users
description
string
Optional description of the dataset
x-nullable:
true
example:
This dataset contains golden user records
Http + 1.1
PATCH
https://app.getcensus.com/api/v1/datasets/{dataset_id}
PATCH /api/v1/datasets/{dataset_id} HTTP/1.1 Authorization: Bearer REPLACE_BEARER_TOKEN Content-Type: application/json Host: app.getcensus.com Content-Length: 159 { "name": "Users", "description": "This dataset contains user data from our database", "query": "SELECT id, name, email FROM users WHERE active = true" }
Responses
200
Successfully updated the dataset
400
Bad Request
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:
"updated""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
400
status
string
The outcome of the request
enum:
"error"
message
string
The reason the request failed
example:
There was a problem with the request: cron_expression is not in a valid format
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": "updated", "data": { "type": "sql", "query": "SELECT id, name, email FROM users WHERE active = true", "source_id": 123 } }