Skip to main content

​
Query Dataset

Playground

 Method: POST
Endpoint: api/query/v1/execute/export/<DATASET_ID>?includeHeader=true Example: 
{
  "method": "POST",
  "url": "https://{instance}.domo.com/api/query/v1/execute/export/<DATASET_ID>?includeHeader=true",
  "headers": {
    "X-DOMO-Developer-Token": "",
    "Content-Type": "application/json"
  },
  "body": { "sql": "SELECT * FROM `<DATASET_ID>` WHERE status='error'" }
}
Response:
Description of the Response with an example of the data 
200:
{
    "datasource": "<DATASET_ID>",
    "columns": [
    ],
    "metadata": [
    ],
    "numColumns": 10,
    "rows": [
    ],
    "numRows": 15
}