---
title: "Retrieve prepared/skipped user-database state for one connection within one pipeline"
method: GET
path: "/v1/integration/projects/{projectId}/pipelines/{pipelineId}/databases"
tags: ["Unified Project Lifecycle APIs"]
---

# Retrieve prepared/skipped user-database state for one connection within one pipeline

`GET /v1/integration/projects/{projectId}/pipelines/{pipelineId}/databases`

## Request

- Base URL: `https://integration-adapter.connect.cloud.precisely.com`
- URL: `https://integration-adapter.connect.cloud.precisely.com/v1/integration/projects/{projectId}/pipelines/{pipelineId}/databases`
- Auth: HTTP bearer

`connectionId` is required; state is scoped to this connection within this pipeline, never
merged across every connection on the pipeline.

**Features:**
- Returns database names successfully prepared and database names skipped/failed.
- Never returns preparation credentials.

**Use Cases:**
- Determine whether a connection's user databases are already prepared before prompting again.
- Surface skipped databases for explicit remediation/retry.

**Authorization:** Requires `replication-pipeline::view`.

## Path parameters

- `projectId` string, required
- `pipelineId` string, required

## Query parameters

- `connectionId` string, required
- `projectType` 'REPLICATION' | 'MAINFRAME_REPLICATION' | 'ADVANCED_REPLICATION': Supported project types for unified project operations

## Response `200`

Successfully retrieved prepared user-database state

## Other responses

- `400`: Bad request — MAINFRAME_REPLICATION is not supported (DI-ADAPTER-PRJ-0013)
- `401`: Unauthorized
- `403`: Forbidden
- `404`: No prepared user-database state found (DI-ADAPTER-UDB-0002)
- `500`: Internal server error (DI-ADAPTER-UDB-0003)

---

[API](https://skmtc.dev/precisely/apis/precisely-integration-adapter-service.md) · [All operations](https://skmtc.dev/precisely/apis/precisely-integration-adapter-service/llms.txt) · [OpenAPI document](https://skmtc.dev/precisely/apis/precisely-integration-adapter-service/revisions/2d2629f4987d?raw)