---
title: "Get all DLQ streams with counts"
method: GET
path: "/api/v2/pipelines/{name}/dlqs"
tags: ["v2", "dlq"]
---

# Get all DLQ streams with counts

`GET /api/v2/pipelines/{name}/dlqs`

Returns all tables that have DLQ records with their total counts. Table names are returned in the format: source_name.schema_name.table_name (for PostgreSQL, Oracle, SQL Server, Spanner) or source_name.database_name.table_name (for MySQL, MariaDB, MongoDB).

## Path parameters

- `name` string, required — Pipeline name

## Response `200`

Successful Response

- DlqListResponse — Response model for listing all DLQ tables with their counts. Returns a dictionary mapping table names to their DLQ info. Example: {"source.schema.table1": {"total_count": 100}, ...}

## Other responses

- `401` — Unauthorized
- `403` — Forbidden
- `404` — Not Found
- `500` — Internal Server Error

## Changes

- **2026-07-16** `e381b64b5ffc` — 1 info
  - added the non-success response with the status `404`
- **2026-04-29** `d5de67e6bd60` — 1 info
  - endpoint added
- **2025-02-27** `b0ed6c7dac42` — 1 breaking
  - api path removed without deprecation

[Change history](https://skmtc.dev/redis/apis/redis-data-integration-api/changes/api/v2/pipelines/:name/dlqs/get.md)

---

[API](https://skmtc.dev/redis/apis/redis-data-integration-api.md) · [All operations](https://skmtc.dev/redis/apis/redis-data-integration-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/redis/redis-data-integration-api/revisions/30f630f0aac5/schema)