---
title: "List events with payloads (flat format)"
method: GET
path: "/v1/events/payloads"
tags: ["Events"]
---

# List events with payloads (flat format)

`GET /v1/events/payloads`

Returns events joined with their stored payloads in a flat, tabular format
designed for data engineers and SQL-based workflows.

Each row is a single event with its input/output payloads inlined.
Only events that have stored payloads are returned (i.e., events created
with `input` or `output` fields).

**Filters:** `customerId`, `actionName`, `from`/`to` (ISO 8601 date range),
`hasInput`, `hasOutput` (boolean).

**Use cases:**
- Export to data warehouses (BigQuery, Snowflake, Redshift)
- Ad-hoc SQL analysis of event payloads
- Training data extraction for ML pipelines
- Compliance audits requiring full payload history

## Query parameters

- `customerId` string
- `actionName` string
- `eventType` 'USAGE' | 'API_CALL' | 'LLM_INFERENCE' | 'TOOL_CALL' | 'DATABASE' | 'FILE_IO' | 'NETWORK' | 'DECISION' | 'HUMAN_IN_LOOP' | 'MEMORY' | 'CUSTOM' | 'TOOL_CALL_START' | 'TOOL_CALL_END' | 'TOOL_CALL_ERROR' | 'TOOL_CALL_RETRY' | 'TRAINING' | 'FINE_TUNING'
- `from` string, date-time
- `to` string, date-time
- `hasInput` boolean
- `hasOutput` boolean
- `limit` integer
- `offset` integer

## Response `200`

Flat list of events with inlined payloads

- object — Flat list of events with inlined payloads
  - `data` object[]
    - `eventId` string
    - `customerId` string
    - `actionName` string
    - `eventType` string
    - `outcome` string, nullable
    - `quantity` string
    - `units` string, nullable
    - `idempotencyKey` string
    - `createdAt` string, date-time
    - `inputPayload` object, nullable
    - `outputPayload` object, nullable
    - `inputHash` string, nullable
    - `outputHash` string, nullable
    - `inputSizeBytes` integer, nullable
    - `outputSizeBytes` integer, nullable
    - `payloadExpiresAt` string, date-time, nullable
    - `runId` string, nullable
    - `workflowId` string, nullable
    - `metadata` object, nullable
  - `pagination` object
    - `total` integer
    - `limit` integer
    - `offset` integer
    - `hasMore` boolean
  - `sql_hint` string — Example SQL query for this data set

## Other responses

- `401` — Unauthorized

---

[API](https://skmtc.net/usedrip/apis/drip-api.md) · [All operations](https://skmtc.net/usedrip/apis/drip-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/usedrip/drip-api/versions/2cb1567969ca/schema)