---
title: "List Jdbc Instances"
method: POST
path: "/data-source/list-jdbc"
tags: ["data-source"]
---

# List Jdbc Instances

`POST /data-source/list-jdbc`

## Query parameters

- `provider_id` integer, required

## Request body

- QueryCondition
  - `page` integer
  - `size` integer
  - `sort_column` string
  - `asc` boolean
  - `conditions` CommonQueryConditionCondition[]
    - `column` string
    - `values` string[]
    - `condition` string
    - `operation` string
  - `group_column` string

## Response `200`

Successful Response

- BaseResponsePageJDBCInstanceSourceFullInfo
  - `status` string, required
  - `code` integer, required
  - `message` string
  - `data` PageJDBCInstanceSourceFullInfo
    - `items` JDBCInstanceSourceFullInfo[], required
      - `instance_id` string
      - `account_provider_id` integer
      - `account_id` string
      - `region` string
      - `description` string
      - `jdbc_connection_url` string
      - `jdbc_connection_schema` string
      - `jdbc_enforce_ssl` string
      - `kafka_ssl_enabled` string
      - `master_username` string
      - `password` string
      - `secret` string
      - `skip_custom_jdbc_cert_validation` string
      - `custom_jdbc_cert` string
      - `custom_jdbc_cert_string` string
      - `network_availability_zone` string
      - `network_subnet_id` string
      - `network_sg_id` string
      - `glue_crawler_last_updated` string, date-time
      - `creation_time` string
      - `last_updated_time` string
      - `jdbc_driver_class_name` string
      - `jdbc_driver_jar_uri` string
      - `create_type` integer
      - `data_source_id` integer
      - `detection_history_id` integer
      - `connection_status` string
      - `glue_database` string
      - `glue_connection` string
      - `glue_vpc_endpoint` string
      - `glue_crawler` string
      - `glue_state` string
      - `instance_class` string
      - `instance_status` string
    - `total` integer, required
    - `page` integer
    - `size` integer
    - `pages` integer

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.net/aws-samples/apis/sensitive-data-protect-solution.md) · [All operations](https://skmtc.net/aws-samples/apis/sensitive-data-protect-solution/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/aws-samples/sensitive-data-protect-solution/versions/e0c2e29932e2/schema)