Domo DatasetsInstall

Summary

Execute a SQL query against a Domo dataset and return result rows as JSON.

Inputs

None.

Output shape

array

An array of objects, each containing a json property with a row from the query result.

Examples

Example 1: Basic query with default SQL

Provide a datasetId; the sql parameter defaults to SELECT * FROM table LIMIT 10.

Example 2: Custom SQL query

Set sql to a custom query string (e.g., SELECT name, count FROM users). The dataset is referenced as table in the query.