Dune Analytics Integration

Connect Dunmore to Dune Analytics to stream payment event data into a Dune dataset. Build SQL queries, create dashboards, and combine your x402 payment data with on-chain data.

Setup

1. Get a Dune API key from dune.com/settings/api
2. Create a dataset namespace and table in Dune, or use the defaults (dunmore / payment_events)
3. Add a Dune connector in the Dunmore console or via the API

Data Schema

Each event inserts a row with these columns:

Column	Type	Description
event_id	text	Dunmore event ID
event_type	text	Event type (e.g., payment.settled)
timestamp	text	ISO 8601 timestamp
project_id	text	Dunmore project ID
amount_raw	text	Raw amount in atomic units
amount_usd	numeric	Amount converted to USD
currency	text	Currency code
network	text	CAIP-2 chain ID
endpoint	text	Endpoint path
payer_wallet	text	Payer wallet address
seller_wallet	text	Seller wallet address
tx_hash	text	Settlement transaction hash
payment_id	text	Dunmore payment ID
stage	text	Failure stage (if applicable)
error_code	text	Error code (if applicable)
latency_ms	numeric	Settlement latency in ms

Supported Events

All event types are streamed to Dune. The connector does not filter — it inserts every event for complete analytics coverage.

Configuration

{
  "type": "dune",
  "config": {
    "apiKey": "your-dune-api-key",
    "namespace": "dunmore",
    "table": "payment_events"
  },
  "eventTypes": ["*"]
}

Field	Required	Default	Description
apiKey	Yes	—	Dune API key
namespace	No	dunmore	Dune dataset namespace
table	No	payment_events	Dune table name

API Example

curl -X POST https://api.dunmore.xyz/api/projects/{projectId}/connectors \
  -H "Authorization: Bearer {token}" \
  -H "Content-Type: application/json" \
  -d '{
    "type": "dune",
    "config": {
      "apiKey": "YOUR_DUNE_API_KEY",
      "namespace": "dunmore",
      "table": "payment_events"
    },
    "eventTypes": ["*"]
  }'