ListTables

Obtains tables of different data source types within a tenant by page.

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Debug

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

Parameter	Type	Required	Description	Example

Parameter	Type	Required	Description	Example
PageSize	integer	No	The number of entries displayed on each page. The default value is 10 and the maximum value is 100.	10
DataSourceType	string	Yes	The type of the data source. Valid values: ODPS, emr, mysql, holo, analyticdb_for_mysql, oracle, postgresql, sqlserver, clickhouse, and starrocks.	odps emr mysql holo
NextToken	string	No	Pagination information, which specifies the starting point of this read.	12222

Response parameters

Parameter	Type	Description	Example

Parameter	Type	Description	Example
	object	The response parameters.
RequestId	string	The request ID.	E25887B7-579C-54A5-9C4F-83A0DE367DD
Data	object	The returned data.
Total	long	The total number.	100
TableEntityList	array<object>	An array of entities.
TableEntityList	object	The information about the table.
EntityQualifiedName	string	The unique identifier of the table entity.	maxcompute-table.project.table
EntityContent	object	The information about the table.
TableName	string	The name of the table.	table
DataSourceQualifiedName	string	The unique identifier of the data source.	accountId:cn-shanghai:odps:project
DataSourceUniqueId	string	The unique ID of the data source identifier.	e70f92239d491057f6a2563b545bdaf8cc6b537d9dc55ec84c55f7cfefg
DatabaseName	string	The name of the database.	database
ProjectName	string	The name of the ODPS project.	project
InstanceId	string	The ID of the data source instance.	rm-uf6rn0123
NextToken	string	Pagination information, which specifies the starting point of the next read.	AAAAAVY3rYiv9VoUJQSiCitgjgSwg+byk0FIjirFkm4zfM4G0xYwM/FQvOhgrTHsCPIZ5yqXYu2NG6qRCRC52HvwbOA=

Examples

Sample success responses

JSONformat

            
            
          
{
  "RequestId": "E25887B7-579C-54A5-9C4F-83A0DE367DD",
  "Data": {
    "Total": 100,
    "TableEntityList": [
      {
        "EntityQualifiedName": "maxcompute-table.project.table",
        "EntityContent": {
          "TableName": "table",
          "DataSourceQualifiedName": "accountId:cn-shanghai:odps:project",
          "DataSourceUniqueId": "e70f92239d491057f6a2563b545bdaf8cc6b537d9dc55ec84c55f7cfefg",
          "DatabaseName": "database",
          "ProjectName": "project",
          "InstanceId": "rm-uf6rn0123"
        }
      }
    ],
    "NextToken": "AAAAAVY3rYiv9VoUJQSiCitgjgSwg+byk0FIjirFkm4zfM4G0xYwM/FQvOhgrTHsCPIZ5yqXYu2NG6qRCRC52HvwbOA="
  }
}

Error codes

For a list of error codes, visit the Service error codes.

Change history

Change time	Summary of changes	Operation

Change time	Summary of changes	Operation
2024-09-03	The response structure of the API has changed	View Change Details