Help Center/ ROMA Connect/ API Reference/ Data Integration APIs/ Data Source Management/ Obtaining All Tables in the Data Source
Updated on 2025-10-22 GMT+08:00
Online Debugging
CLI Examples
View PDF
Share

Obtaining All Tables in the Data Source

Function

This API is used to obtain all tables in the data source.

Authorization Information

Each account has all the permissions required to call all APIs, but IAM users must be assigned the required permissions. For details about the required permissions, see Permissions Policies and Supported Actions.

URI

GET /v2/{project_id}/fdi/instances/{instance_id}/datasources/{datasource_id}/tables

Table 1 Path Parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID. For details about how to obtain the project ID, see "Appendix" > "Obtaining a Project ID" in the API Reference.

instance_id

Yes

String

Instance ID

datasource_id

Yes

String

Data source ID.
Table 2 Query Parameters

Parameter

Mandatory

Type

Description

direction_type

Yes

String

Location of the task where the data source is located.

  • SOURCE: the data source is at the source end of the task.

  • TARGET: the data source is at the target end of the task.

db_name

No

String

Database name. Only data sources of the MRSHIVE type is supported.

db_schema

No

String

Database mode. This API is used by the Gauss100 database.

filter

No

String

Filter for fuzzy match of table names.

Request Parameters

Table 3 Request header parameters

Parameter

Mandatory

Type

Description

X-Auth-Token

Yes

String

User token. The token can be obtained by calling an IAM API. The value of X-Subject-Token in the response header is the user token.

Response Parameters

Status code: 200

Table 4 Response body parameters

Parameter

Type

Description

tables

Array of strings

Names of all tables in the data source.

Status code: 400

Table 5 Response body parameters

Parameter

Type

Description

error_code

String

Error code.

error_msg

String

Error message.

detail

String

Description details.

Status code: 404

Table 6 Response body parameters

Parameter

Type

Description

error_code

String

Error code.

error_msg

String

Error message.

Status code: 500

Table 7 Response body parameters

Parameter

Type

Description

error_code

String

Error code.

error_msg

String

Error message.

Example Requests

None

Example Responses

Status code: 200

OK

  • Example 1

    null

  • Example 2

    [ "app.0" ]

Status Codes

Status Code

Description

200

OK

400

Error response

404

Not Found

500

Internal Server Error

Error Codes

See Error Codes.

Parent topic: Data Source Management