Gets a list of all DatabaseToolsConnections in a compartment
GET {{baseUrl}}/databaseToolsConnections?compartmentId=<string>&lifecycleState=DELETED&displayName=<string>&type=POSTGRESQL&type=MYSQL&runtimeSupport=SUPPORTED&runtimeSupport=UNSUPPORTED&relatedResourceIdentifier=<string>&limit=10&page=<string>&sortOrder=ASC&sortBy=timeCreated
Returns a list of Database Tools connections.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
compartmentId | string | (Required) The OCID of the compartment in which to list resources. | |
lifecycleState | string | A filter to return only resources their lifecycleState matches the specified lifecycleState. | |
displayName | string | A filter to return only resources that match the entire specified display name. | |
type | string | A filter to return only resources their type matches the specified type. | |
type | string | A filter to return only resources their type matches the specified type. | |
runtimeSupport | string | A filter to return only resources with one of the specified runtimeSupport values. | |
runtimeSupport | string | A filter to return only resources with one of the specified runtimeSupport values. | |
relatedResourceIdentifier | string | The OCID of the related resource. | |
limit | number | The maximum number of items to return. | |
page | string | The page token representing the page at which to start retrieving results. This is usually retrieved from a previous list call. | |
sortOrder | string | The sort order to use, either 'asc' or 'desc'. | |
sortBy | string | The field to sort by. Only one sort order may be provided. Default order for timeCreated is descending. Default order for displayName is ascending. If no value is specified timeCreated is default. | |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Accept | string |
RESPONSES
status: OK
{"items":[{"id":"\u003cstring\u003e","displayName":"\u003cstring\u003e","compartmentId":"\u003cstring\u003e","lifecycleState":"FAILED","timeCreated":"\u003cdateTime\u003e","timeUpdated":"\u003cdateTime\u003e","type":"GENERIC_JDBC","runtimeSupport":"UNSUPPORTED","definedTags":{"ut_32_":{"dolor_4df":{}}},"freeformTags":{"Duis_9f":"\u003cstring\u003e"},"lifecycleDetails":"\u003cstring\u003e","locks":[{"type":"DELETE","message":"\u003cstring\u003e","relatedResourceId":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e"},{"type":"DELETE","message":"\u003cstring\u003e","relatedResourceId":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e"}],"systemTags":{"sunt_643":{"ex_a12":{},"exercitation_a9":{}}}},{"id":"\u003cstring\u003e","displayName":"\u003cstring\u003e","compartmentId":"\u003cstring\u003e","lifecycleState":"DELETING","timeCreated":"\u003cdateTime\u003e","timeUpdated":"\u003cdateTime\u003e","type":"GENERIC_JDBC","runtimeSupport":"SUPPORTED","definedTags":{"cillum_7ec":{"in8":{}},"mollit73":{"voluptate_01_":{}}},"freeformTags":{"aliqua_3a":"\u003cstring\u003e","utce9":"\u003cstring\u003e"},"lifecycleDetails":"\u003cstring\u003e","locks":[{"type":"DELETE","message":"\u003cstring\u003e","relatedResourceId":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e"},{"type":"FULL","message":"\u003cstring\u003e","relatedResourceId":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e"}],"systemTags":{"ex4":{"proidentda6":{}},"minim_f":{"incididunt6":{}}}}]}