REST API Reference

10.4.1
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0

Back Next

Schemas

The schemas request lists all schemas for a connection. If you include query parameters in the request, it returns schemas that match the query parameters.

Resource URL

/tdm/v1/connections/{connectionId}/schemas

HTTP Request

GET http(s)://<host>:<port>/api/public/tdm/v1/connections/{connectionId}/schemas

Request Header

The request header includes the following headers:

Header	Description
accept	Use the following value: application/json
Authorization	Required. Use the following value: Basic <user name>

Request Path Parameters

The request includes the following path parameter:

Parameter	Description
connectionId	Required. ID of the connection that contains the schemas.

Request Query Parameters

The request includes the following optional query parameters:

Parameter	Description
filter	Filters based on criteria.
sort	Sorts based on criteria. You can enter more than one field name as criteria. By default, sorts in ascending order of criteria. For example, to sort in descending order enter: id:desc
start	The start index of the list.
size	The number of records that you want to return.

Sample Request

GET http://<host>:6605/api/public/tdm/v1/connections/U:b2DtzUtUEem6p6Tll-PTWQ/schemas

Sample Response

[
  "CI",
  "db_accessadmin",
  "db_backupoperator",
  "db_datareader",
  "db_datawriter",
  "db_ddladmin",
  "db_denydatareader",
  "db_denydatawriter",
  "db_owner",
  "db_securityadmin",
  "dbo",
  "guest",
  "INFORMATION_SCHEMA",
  "sys"
]

Rename Saved Search

Table of Contents

REST API Reference

REST API Reference

Schemas

Schemas

Resource URL

HTTP Request

Request Header

Request Path Parameters

Request Query Parameters

Sample Request

Sample Response