Ingest CSV file

post

https://api.doit.com/datahub/v1/csv/upload

Sends a batch of events to DataHub using a CSV file, either uncompressed or compressed in ZIP or GZ format. It may take up to 15 minutes for the data to become available in the DoiT console.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Body Params

provider

string

The identifier of the data provider. Allowed characters: alphanumeric (0-9,a-z,A-Z), underscore (_), space, dash (-).

file

The CSV file to upload, either uncompressed or compressed in ZIP or GZ format. The maximum file size is 30 MB.

schemaTemplate

string

Versioned schema template of the file. Defaults to the dataset's template (default@1 for datasets created without one). Provider-native templates such as anthropic-spend-report@1 and codex-usage-report@1 validate the vendor's own columns and normalize them into DataHub events. Must match the template stored on the dataset.

periodStart

date

Inclusive first day of the report period (YYYY-MM-DD). Required for template uploads whose filename does not carry the period; when both are present they must agree.

periodEnd

date

Inclusive last day of the report period (YYYY-MM-DD). Events are booked on this day.

replace

boolean

Defaults to false

Template uploads only. When true, active batches whose report period overlaps this upload are soft-deleted before the new file is ingested, and their ids are returned in replacedBatches. Refused with 409 when an overlapping batch extends outside the requested period (so a one-day replacement can never remove a wider upload) or was ingested less than 90 minutes ago (Retry-After header set). Without replace, any overlap is rejected with 409.

Responses

Language

Credentials

Loading…

Response

Click Try It! to start a request and see the response here! Or choose an example:

application/json

201OK - Ingestion succeeded.

400Bad Request - The server cannot process the request, often due to a malformed request.

401Unauthorized - Invalid API key.

403Forbidden - The client is not authorized to perform the request.

404Not Found - The requested resource does not exist.

409Conflict - the report period overlaps an active batch (upload without replace), the request template does not match the dataset, replace would remove data outside the requested period, or an overlapping batch is still being processed (retry after the Retry-After seconds).

500Internal Server Error - Something went wrong with the DoiT API server.