Skip to main content

​
Method 1 - Using the SQL Endpoint

This method allows you to use traditional SQL to query. This method currently only returns an “array-of-arrays” (see output formats below): 
var query = 'SELECT SUM(amount) as Sales FROM dataset0';
domo.post('/sql/v1/myDatasetAlias', query, {contentType: 'text/plain'}).then(function(result) { … });
To use a column name with spaces in your query, wrap the column name with back-ticks, for example: 
var query = 'SELECT SUM(`Store Sales`) as Sales FROM dataset0';

​
Method 2 - Using the Data Endpoint

This is the traditional method for getting data out of Domo: 
var query = `fields=amount&sum=amount`;
domo.get('/data/v1/myDatasetAlias?' + query)
  .then(function(result)
     { … }
  );
Here are some references and examples to get you started:

​
Output Formats

The default data endpoint output format may not always be the format you need. Supported formats are:
  • array-of-objects (default)
  • array-of-arrays
  • excel
  • csv
You can specify the format like this: 
domo.get('/data/v1/dataset?' + query, {format: 'csv'})
  .then(function(result)
    { … }
  );