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

KeyDatatypeRequiredDescription
compartmentIdstring(Required) The OCID of the compartment in which to list resources.
lifecycleStatestringA filter to return only resources their lifecycleState matches the specified lifecycleState.
displayNamestringA filter to return only resources that match the entire specified display name.
typestringA filter to return only resources their type matches the specified type.
typestringA filter to return only resources their type matches the specified type.
runtimeSupportstringA filter to return only resources with one of the specified runtimeSupport values.
runtimeSupportstringA filter to return only resources with one of the specified runtimeSupport values.
relatedResourceIdentifierstringThe OCID of the related resource.
limitnumberThe maximum number of items to return.
pagestringThe page token representing the page at which to start retrieving results. This is usually retrieved from a previous list call.
sortOrderstringThe sort order to use, either 'asc' or 'desc'.
sortBystringThe 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

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
Acceptstring

RESPONSES

status: OK

{&quot;items&quot;:[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifecycleState&quot;:&quot;FAILED&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeUpdated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;type&quot;:&quot;GENERIC_JDBC&quot;,&quot;runtimeSupport&quot;:&quot;UNSUPPORTED&quot;,&quot;definedTags&quot;:{&quot;ut_32_&quot;:{&quot;dolor_4df&quot;:{}}},&quot;freeformTags&quot;:{&quot;Duis_9f&quot;:&quot;\u003cstring\u003e&quot;},&quot;lifecycleDetails&quot;:&quot;\u003cstring\u003e&quot;,&quot;locks&quot;:[{&quot;type&quot;:&quot;DELETE&quot;,&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;relatedResourceId&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;},{&quot;type&quot;:&quot;DELETE&quot;,&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;relatedResourceId&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;}],&quot;systemTags&quot;:{&quot;sunt_643&quot;:{&quot;ex_a12&quot;:{},&quot;exercitation_a9&quot;:{}}}},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifecycleState&quot;:&quot;DELETING&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeUpdated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;type&quot;:&quot;GENERIC_JDBC&quot;,&quot;runtimeSupport&quot;:&quot;SUPPORTED&quot;,&quot;definedTags&quot;:{&quot;cillum_7ec&quot;:{&quot;in8&quot;:{}},&quot;mollit73&quot;:{&quot;voluptate_01_&quot;:{}}},&quot;freeformTags&quot;:{&quot;aliqua_3a&quot;:&quot;\u003cstring\u003e&quot;,&quot;utce9&quot;:&quot;\u003cstring\u003e&quot;},&quot;lifecycleDetails&quot;:&quot;\u003cstring\u003e&quot;,&quot;locks&quot;:[{&quot;type&quot;:&quot;DELETE&quot;,&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;relatedResourceId&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;},{&quot;type&quot;:&quot;FULL&quot;,&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;relatedResourceId&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;}],&quot;systemTags&quot;:{&quot;ex4&quot;:{&quot;proidentda6&quot;:{}},&quot;minim_f&quot;:{&quot;incididunt6&quot;:{}}}}]}