Search databases

get

https://{host}/platform/riskdata/v1/dataservers/{serverId}/databases

Returns a list of databases hosted on the specified SQL Server instance.

This operation supports response filtering based the value of a subset of properties. Depending on the property, you may use a combination of comparison operators, list operators, and logical operators. To learn more, see Response Filtering.

Path Params

serverId

int64

required

ID of a manager SQL Server instance on Data Bridge.

Query Params

filter

string

Query string to select response data based on property values.

Supported properties: databaseId, databaseName, databaseType, databaseVersion. Operators depend on the data type of the property.

Property	Data Type	Comparison	List
`databaseId`	`Number`	`=`, `!=`	`IN`, `NOT IN`
`databaseName`	`String`	`=`, `!=`, `LIKE`, `NOT LIKE`	`IN`, `NOT IN`
`databaseType`	`String`	`=`, `!=`	`IN`, `NOT IN`
`databaseVersion`	`String`	`=`, `!=`, `LIKE`, `NOT LIKE`	`IN`, `NOT IN`

Use the AND and OR logical operators to defined compound queries. See Filtering Responses.

sort

string

Defaults to databaseName ASC

Comma-delimited list of properties. Sort order defined by one of ASC (ascending) or DESC (descending).

Supported properties: databaseName, databaseType, databaseVersion See Response Pagination.

limit

int32

1 to 1000

Defaults to 100

Number of records returned per page. See Response Pagination

offset

int32

Defaults to 0

Number of the page displaying the returned records, starting at 0

Responses

200Success

400Bad Request

401Unauthorized

403Forbidden

404The requested resource was not found.

500Internal Server Error