Querying a Connection List

Function

This API is used to query a connection list.

URI

URI format
GET /v1/{project_id}/connections?offset={offset}&limit={limit}&connectionName={connectionName}

Parameter description

**Table 1** URI parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID. For details about how to obtain a project ID, see Project ID and Account ID.
offset	No	Integer	The value is no less than 0. The default value is 0.
limit	No	Integer	The maximum number of records on each page. Value range: 1 to 100 Default value: 10
connectionName	No	String	Name of a connection.

Request

**Table 2** Request header parameter
Parameter	Mandatory	Type	Description
workspace	No	String	Workspace ID. If this parameter is not set, data in the default workspace is queried by default. To query data in other workspaces, this header must be carried.

Response

Parameter	Mandatory	Type	Description
total	Yes	Integer	The total number of connections.
connections	Yes	List<Connections>	Connection list.

**Table 3** connections parameters
Parameter	Mandatory	Type	Description
name	Yes	String	Connection name. The name contains a maximum of 100 characters, including only letters, numbers, hyphens (-), and underscores (_). The connection name must be unique.
type	Yes	String	Connection type. DWS DLI SparkSQL HIVE RDS CloudTable HOST
config	No	Map<String,String>	Connection configuration item. The configuration item varies with the connection type. You do not need to set the config parameter for DLI connections. For other types of connections, see the description of connection configuration items.
description	No	String	Description of the connection. The description contains a maximum of 255 characters.

Example

Query a connection list.

Request

GET /v1/b384b9e9ab9b4ee8994c8633aabc9505/connections

Success response

HTTP status code 200

{
    "total":1,
    "connections":[
        {
            "name":"connection1",
            "type":"DWS",
            "config":{
                "clusterName":"test",
                "userName":"dbadmin",
                "password":"*********",
                "kmsKey":"cdm-dlf",
                "agentName":"cdm-donotdelete",
                "sslEnable":false
            }
        }
    ]
}

Failure response

HTTP status code 400

{
    "error_code":"DLF.3051",
    "error_msg":"The request parameter is invalid."
}

Parent topic: Connection Management APIs

Previous topic: Creating a Connection

Next topic: Viewing Connection Details

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot