You can send Dune data to a webhook by going to any query your own, and pressing the “schedule” button to the left of “Run” in the editor. You’ll the popup below, where you can paste in a webhook url and recieve data on a scheduled interval.

A good use case for this is sending data to a Slack webhook, which you can learn to do here.

You can quickly test the output with a webhook generator like this one.

Here is an example schema sent to the webhook from this Jupiter swap fees query:

{
  "message": "Query Jupiter Fees was submitted for execution at Wed, 17 Jan 2024 04:18:49 GMT by your query schedule and it was successfully executed with a non empty result.\nYou can check its latest result here: https://dune.com/queries/3106864?utm_source=webhook&utm_campaign=alerts",
  "query_result": {
    "execution_id": "01HMAT9AB8JRV1NQR1W6NMYQK7",
    "query_id": 3106864,
    "state": "QUERY_STATE_COMPLETED",
    "submitted_at": "2024-01-17T04:18:49Z",
    "expires_at": "2024-04-16T04:20:57Z",
    "execution_started_at": "2024-01-17T04:18:49Z",
    "execution_ended_at": "2024-01-17T04:20:57Z",
    "result": {
      "data_uri": "https://api.dune.com/api/v1/execution/01HMAT9AB8JRV1NQR1W6NMYQK7/results",
      "metadata": {
        "column_names": [
          "week",
          "fee_usd"
        ],
        "result_set_bytes": 1164,
        "total_row_count": 25,
        "datapoint_count": 50,
        "pending_time_millis": 40,
        "execution_time_millis": 127845
      }
    }
  },
  "visualizations": [
    {
      "title": "Chart",
      "image_url": "https://prod-dune-media.s3.eu-west-1.amazonaws.com/screenshots/3106864/01HMAT9AB8JRV1NQR1W6NMYQK7/5222108.png"
    }
  ]
}

You’ll need to GET query the data_uri with your api key to get the results data. This is the same as passing the execution_id into get execution result.

In the case the query errors out on its scheduled run, you won’t recieve anything to the webhook.

Was this page helpful?

Unprivate QueryHosted Blockchain Integration