---
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

---

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