Node ReferenceData
Dune
Execute SQL queries and retrieve blockchain analytics via Dune.
Dune provides SQL-based blockchain analytics. The Dune node lets you execute existing queries, check execution status, and retrieve results programmatically.
Prerequisites
- Dune API key (dune.com/settings/api)
- Requires Plus plan or higher for API access
- Add as a credential in Credentials
Operations
| Operation | Description | Key inputs |
|---|---|---|
| getQueryResults | Get cached results for a query | queryId, limit |
| executeQuery | Execute a query with optional parameters | queryId, queryParameters, performance |
| getExecutionStatus | Check status of a running execution | executionId |
| getExecutionResults | Get results from a completed execution | executionId, limit |
| cancelExecution | Cancel a running execution | executionId |
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
| queryId | string | For query ops | Dune query ID (numeric) |
| executionId | string | For execution ops | Execution ID from executeQuery |
| queryParameters | string | No | JSON string of query parameters |
| performance | string | No | medium or large (default: medium) |
| limit | number | No | Max rows to return (default: 100, max: 10000) |
| offset | number | No | Row offset for pagination |
Output
All operations return the standard envelope:
{
"success": true,
"operation": "getQueryResults",
"queryId": "1234567",
"data": { /* raw Dune response */ }
}Query-result operations expose rows under data.result.rows. Reference fields downstream with the response name (default duneResponse), for example {duneResponse.data.result.rows[0].volume_usd}. Execution-state operations (getExecutionStatus, getExecutionResults, cancelExecution, executeQuery) echo executionId instead of queryId.
Common use cases
- Run scheduled blockchain analytics queries
- Feed Dune data into AI for automated reporting
- Monitor specific on-chain metrics via custom SQL