Import data into DataSet

Import data into a DataSet in your Domo instance. You can replace everything or append new data.

PUT /v1/datasets/{dataset_id}/data

cURL

Example 1

curl --request PUT \
  --url https://api.domo.com/v1/datasets/{dataset_id}/data \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: text/csv' \
  --data 'Friend,Attending
Isaac Newton,Yes
Pythagoras,No
Carl Friedrich Gauss,Yes
Ada Lovelace,Yes
'

400

{
  "status": 400,
  "statusReason": "Bad Request",
  "message": "Data import failed for dataset e6277565-39fc-42d7-835a-5cfe2905a840.",
  "toe": "CA6JIHTO46-28C5D-UEQ7I"
}

{
  "status": 403,
  "toe": "694M4LH50R-CFNR0-N0VD2"
}

Authorizations

Authorization · string · header · required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

dataset_id · string · required

ID of the DataSet

Example:

"08a061e2-12a2-4646-b4bc-20beddb403e3"

Query Parameters

updateMethod · enum<string> · default: REPLACE

Specifies how the data import should update the DataSet.

Defaults to REPLACE if not specified.

Case-sensitive; must be uppercase. Falls back to REPLACE if given an invalid value.

Available options: REPLACE, APPEND

Body

text/csv

The schema needs to match, even when replacing.

The only supported content type for this endpoint is CSV. However, if you use the Simple API, it will automatically convert JSON to CSV.

The Domo specification used for representing data grids in CSV format closely follows the RFC standard for CSV (RFC-4180).

Content-Type: text/csv

Friend,Attending
Isaac Newton,Yes
Pythagoras,No
Carl Friedrich Gauss,Yes
Ada Lovelace,Yes

CSV data according to RFC 4180 format.

Response

204

Success! Returns an empty response body.