Skip to main content
POST
/
api
/
query
/
v1
/
execute
/
export
/
{datasetId}
Query Dataset
curl --request POST \
  --url https://{instance}.domo.com/api/query/v1/execute/export/{datasetId} \
  --header 'Content-Type: application/json' \
  --header 'X-DOMO-Developer-Token: <api-key>' \
  --data @- <<EOF
{
  "sql": "SELECT * FROM `<DATASET_ID>` WHERE status='error'"
}
EOF
{
  "datasource": "<DATASET_ID>",
  "columns": [],
  "metadata": [],
  "numColumns": 10,
  "rows": [],
  "numRows": 15
}

Authorizations

X-DOMO-Developer-Token
string
header
required

Path Parameters

datasetId
string
required

The dataset identifier. <DATASET_ID>

Query Parameters

includeHeader
boolean

includeHeader

Body

application/json
sql
string
required

Response

200 - application/json

200:

Description of the Response with an example of the data

datasource
string
columns
any[]
metadata
any[]
numColumns
integer
rows
any[]
numRows
integer