Help Center/ DataArts Studio/ API Reference/ Manager API/ Metadata Acquisition/ Obtaining the Database List (to Be Brought Offline)
Updated on 2025-11-18 GMT+08:00
Online Debugging
CLI Examples
View PDF
Share

Obtaining the Database List (to Be Brought Offline)

Function

This API is used to obtain the database list.

Calling Method

For details, see Calling APIs.

URI

GET /v2/{project_id}/{connection_id}/databases

Table 1 Path Parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID. For details about how to obtain the project ID, see Project ID and Account ID.

connection_id

Yes

String

Data connection ID, which can be obtained from the data connection list.
Table 2 Query Parameters

Parameter

Mandatory

Type

Description

limit

No

String

Maximum number of data records

offset

No

String

Offset

Request Parameters

Table 3 Request header parameters

Parameter

Mandatory

Type

Description

X-Auth-Token

Yes

String

User token. This parameter is mandatory when token authentication is used. You can obtain it from the value of X-Subject-Token in the response message header returned by the "Obtaining a User Token" API of the IAM service.

workspace

Yes

String

Workspace ID

Response Parameters

Status code: 200

Table 4 Response body parameters

Parameter

Type

Description

total_count

Integer

Number of databases connected to the current data connection

dw_id

String

Data connection ID.

databases

Array of DatabasesList objects

Database list
Table 5 DatabasesList

Parameter

Type

Description

database_name

String

Database name

description

String

Database description

Status code: 400

Table 6 Response body parameters

Parameter

Type

Description

error_msg

String

Returned error information.

error_code

String

Returned error code.

Status code: 500

Table 7 Response body parameters

Parameter

Type

Description

error_msg

String

Returned error information.

error_code

String

Returned error code.

Example Requests

None

Example Responses

Status code: 200

The database list is returned.

{
  "dw_id" : "f6ce0c0de8f14ba8b7fbf23486b8ec16",
  "databases" : [ {
    "database_name" : "dlcatalog_2fe5",
    "description" : null
  }, {
    "database_name" : "dlcatalog_3e24",
    "description" : null
  }, {
    "database_name" : "dlcatalog_677a",
    "description" : null
  }, {
    "database_name" : "dlcatalog_86e4",
    "description" : null
  }, {
    "database_name" : "dlcatalog_ced5",
    "description" : null
  } ],
  "total_count" : 21
}

Status code: 400

Bad request.

{
  "error_code" : "DAYU.4402",
  "error_msg" : "The operation failed, detail msg {0}."
}

Status code: 500

Internal server error.

{
  "error_code" : "DAYU.3531",
  "error_msg" : "Internal server error: {0}"
}

Status Codes

Status Code

Description

200

The database list is returned.

400

Bad request.

500

Internal server error.
Parent Topic: Metadata Acquisition