REST API Reference

10.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0

Back Next

Sources

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

Resource URL

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

HTTP Request

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

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 schema.
schemaName	Name of the schema that contains the sources

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 sources in descending order, enter the following: 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/dbo/sources

Sample Response

[
  {
    "name": "dbo",
    "sources": [
      {
        "name": "ALL_DATA_TYPES"
      },
      {
        "name": "ALL_TIMESTAMP_TYPES"
      },
      {
        "name": "ALLDATATYPE"
      },
      {
        "name": "DATETIMETABLE"
      },
      {
        "name": "IBIGINT"
      },
      {
        "name": "IBINARY"
      },
      {
        "name": "IBIT"
      },
      {
        "name": "ICHAR"
      },
      {
        "name": "IDATE"
      },
      {
        "name": "IDATETIME"
      },
      {
        "name": "IDATETIME2"
      },
      {
        "name": "IDATETIMEOFFSET"
      },
      {
        "name": "IDECIMAL"
      },
      {
        "name": "IDECIMAL38"
      },
      {
        "name": "IDECIMAL3838"
      },
      {
        "name": "IFLOAT"
      },
      {
        "name": "IGEOGRAPHY"
      },
      {
        "name": "IGEOMETRY"
      },
      {
        "name": "IHIERARCHYID"
      },
      {
        "name": "IIMAGE"
      },
      {
        "name": "IINTEGER"
      },
      {
        "name": "IMONEY"
      },
      {
        "name": "INCHAR"
      },
      {
        "name": "INTEXT"
      },
      {
        "name": "INUMERIC"
      },
      {
        "name": "INUMERIC38"
      },
      {
        "name": "INUMERIC3838"
      },
      {
        "name": "INVARCHAR"
      },
      {
        "name": "INVARCHARMAX"
      },
      {
        "name": "IPERCNT"
      },
      {
        "name": "IPERCNT_1"
      },
      {
        "name": "IPERCNT_2"
      },
      {
        "name": "IREAL"
      },
      {
        "name": "ISMALLDATETIME"
      },
      {
        "name": "ISMALLINT"
      },
      {
        "name": "ISMALLMONEY"
      },
      {
        "name": "ISQL_VARIANT"
      },
      {
        "name": "ITEXT"
      },
      {
        "name": "ITIME"
      },
      {
        "name": "ITIMESTAMP"
      },
      {
        "name": "ITINYINT"
      },
      {
        "name": "IUNIQUEIDENTIFIER"
      },
      {
        "name": "IVARBINARY"
      },
      {
        "name": "IVARBINARYMAX"
      },
      {
        "name": "IVARCHAR"
      },
      {
        "name": "IVARCHARMAX"
      },
      {
        "name": "IXML"
      },
      {
        "name": "PERF_TABLE_1"
      },
      {
        "name": "PERF_TABLE_2"
      },
      {
        "name": "PERF_TABLE_3"
      },
      {
        "name": "PERF_TABLE_4"
      },
      {
        "name": "TEMP"
      },
      {
        "name": "testdecimal"
      }
    ]
  }
]

Test Data Manager

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal