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:
description
string
Optional description of the dataset
x-nullable:
example:
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:
data
object
type
stringrequired
sql
Type of dataset
default:
enum:
query
stringrequired
SQL query that defines the dataset
example:
source_id
integerrequired
ID of the source connection
example:
400
status
string
The outcome of the request
enum:
message
string
The reason the request failed
example:
401
status
integer
HTTP status code.
enum:
403
status
integer
HTTP status code.
enum:
message
string
Error message.
example:
404
status
integer
HTTP status code.
enum:
{ "status": "updated", "data": { "type": "sql", "query": "SELECT id, name, email FROM users WHERE active = true", "source_id": 123 } }