获取数据集成解决方案库表映射信息
下表仅列出该接口特有的请求参数和部分公共参数。更多信息请见公共参数。
参数 | 类型 | 是否必填 | 示例值 | 描述 |
|---|---|---|---|---|
Action | String | 是 | ListSolutionTableMappings | 要执行的操作,取值:ListSolutionTableMappings。 |
Version | String | 是 | 2026-03-01 | API的版本,取值:2026-03-01。 |
参数 | 类型 | 是否必填 | 示例值 | 描述 |
|---|---|---|---|---|
ProjectId | Long | 是 | 1 | 项目 ID |
SolutionType | String | 是 | SYNC_STREAMING_MULTI_SNAP_ONCE_INCR | 解决方案类型 |
Reader | Array of Object | 否 | -- | 解决方案 Reader |
LogicReader | Object | 否 | -- | 解决方案 Logic Reader |
Writer | Object | 是 | -- | 解决方案 Writer |
TransformConfigs | Array of String | 否 | -- | 解决方案 Transform 配置 |
IdentifierMappingRule | Object | 是 | -- | 解决方案库、表名称映射规则配置 |
AdvancedConfig | Object | 否 | -- | 库、表映射自定义参数 |
ColumnMappingRules | String | 否 | -- | 列映射规则配置 |
下表仅列出本接口特有的返回参数。更多信息请参见返回结构。
参数 | 类型 | 示例值 | 描述 |
|---|---|---|---|
TableMappings | Array of Object | -- | 解决方案表映射配置 |
POST /?Action=ListSolutionTableMappings&Version=2026-03-01 HTTP/1.1 Host: dataleap.cn-beijing.volcengineapi.com Content-Type: application/json; charset=UTF-8 X-Date: 20260414T092729Z X-Content-Sha256: 287e874e******d653b44d21e Authorization: HMAC-SHA256 Credential=Adfks******wekfwe/20260414/cn-beijing/dataleap/request, SignedHeaders=host;x-content-sha256;x-date, Signature=47a7d934ff7b37c03938******cd7b8278a40a1057690c401e92246a0e41085f { "ProjectId": 1, "SolutionType": "SYNC_STREAMING_MULTI_SNAP_ONCE_INCR", "Reader": [ { "DataSourceId": 1, "DataSourceType": "mysql", "DataSourceName": "读数据源", "CatalogMetas": [ { "DatabaseName": "test_database", "SchemaName": "test_schema", "TableName": "test_table" } ], "Properties": [ { "Name": "key1", "Value": "value1" } ] } ], "LogicReader": { "Readers": [], "FilterExps": { "DatabaseName": [ { "FilterType": "FULL", "FilterAction": "INCLUDE", "FilterPattern": "test" } ], "SchemaName": [ { "FilterType": "FULL", "FilterAction": "INCLUDE", "FilterPattern": "test" } ], "TableName": [ { "FilterType": "FULL", "FilterAction": "INCLUDE", "FilterPattern": "test" } ] }, "ReaderTableMode": "STATIC_TABLE_SPECIFIED", "BinlogType": "DEBEZIUM_JSON", "LogicCatalogMeta": { "DatabaseName": "test_database", "SchemaName": "test_schema", "TableName": "test_table" }, "Parameter": { "LogicDatabaseName": "default", "LogicTableName": "default", "Columns": [ { "Name": "column1", "Type": "String", "Value": "D3p", "Nullable": true, "Description": "test column", "IsPartitionColumn": true, "IsPrimaryKey": true, "Precision": 32, "Scale": 6, "IsAdditionalColumn": "false", "SupportTypeList": [ "h1" ], "DefaultValue": "test", "DefaultValueRawExpression": true, "Properties": "HGZeNoc2Kn", "Length": 128 } ], "SplitKeys": [ "FxQGyy32l7" ] } }, "Writer": { "DataSourceId": 1, "DataSourceType": "mysql", "DataSourceName": "写数据源", "Partitions": [], "Properties": [ { "Name": "key1", "Value": "value1" } ] }, "TransformConfigs": [ "MbHmiYCp4" ], "IdentifierMappingRule": { "DatabaseMappings": [ { "SourceName": "source_database", "TargetName": "target_database" } ], "SchemaMappings": [ { "SourceName": "source_schema", "TargetName": "target_schema" } ], "TableMappings": [ { "SourceName": "source_table", "TargetName": "target_table" } ] }, "AdvancedConfig": { "ColumnAlignmentType": "NO_ALIGNMENT", "BatchMode": "JDBC", "DtsSubscriptionTaskId": "dts_123", "DtsSubscriptionTaskName": "test_subscribe", "Debezium": [ "c" ], "CustomParameter": [ { "Key": "key1", "Value": "value1", "Type": "String" } ] }, "ColumnMappingRules": "F83P" }
{ "ResponseMetadata": { "RequestId": "20260414172737011046019171598F0B", "Action": "ListSolutionTableMappings", "Version": "2026-03-01", "Service": "dataleap", "Region": "cn-beijing" }, "Result": { "TableMappings": [ { "EnableSnapshot": true, "EnabledTruncateTable": true, "TableCreationType": "NEW", "Reader": { "DataSourceId": 1, "Parameter": { "ProjectId": 1, "DatabaseName": "test_database", "SchemaName": "test_schema", "TableName": "test_table", "Columns": [ { "Name": "column1", "Type": "String", "Value": "SqP3T52M2Jj", "Nullable": true, "Description": "test column", "IsPartitionColumn": true, "IsPrimaryKey": true, "Precision": 32, "Scale": 6, "IsAdditionalColumn": "false", "SupportTypeList": [ "z6IQ" ], "DefaultValue": "test", "DefaultValueRawExpression": true, "Properties": "b", "Length": 128 } ], "SplitKeys": [ "0kjKA" ], "ShardingKeys": [ "X" ], "SortStrategy": { "SortType": "SMART" }, "PartitionKeys": [ "96otoJL" ], "OrderByKeys": [ "84fp9g" ], "Properties": [ { "Name": "key1", "Value": "value1" } ] } }, "LogicReader": { "Readers": [ { "DataSourceId": 1, "DataSourceType": "mysql", "DataSourceName": "读数据源", "CatalogMetas": [], "Properties": [ { "Name": "key1", "Value": "value1" } ] } ], "FilterExps": { "DatabaseName": [ { "FilterType": "FULL", "FilterAction": "INCLUDE", "FilterPattern": "test" } ], "SchemaName": [ { "FilterType": "FULL", "FilterAction": "INCLUDE", "FilterPattern": "test" } ], "TableName": [ { "FilterType": "FULL", "FilterAction": "INCLUDE", "FilterPattern": "test" } ] }, "ReaderTableMode": "STATIC_TABLE_SPECIFIED", "BinlogType": "DEBEZIUM_JSON", "LogicCatalogMeta": { "DatabaseName": "test_database", "SchemaName": "test_schema", "TableName": "test_table" }, "Parameter": { "LogicDatabaseName": "default", "LogicTableName": "default", "Columns": [ { "Name": "column1", "Type": "String", "Value": "GDHp01Yoi", "Nullable": true, "Description": "test column", "IsPartitionColumn": true, "IsPrimaryKey": true, "Precision": 32, "Scale": 6, "IsAdditionalColumn": "false", "SupportTypeList": [ "Dp" ], "DefaultValue": "test", "DefaultValueRawExpression": true, "Properties": "pPerWDRuA", "Length": 128 } ], "SplitKeys": [ "ffcQQY4c" ] } }, "Writer": { "DataSourceId": 1, "Parameter": {} }, "TransformConfigs": [ "56XEAUwej6" ], "SyncStrategy": { "Ddl": { "CreateTable": "IGNORE", "DropTable": "IGNORE", "AddTableColumn": "IGNORE", "DropTableColumn": "IGNORE", "RenameTable": "IGNORE", "RenameTableColumn": "IGNORE", "UpdateTableColumn": "IGNORE", "TruncateTable": "IGNORE" }, "Cycle": { "Frequency": "hourly", "RetryNum": 1, "RetryInterval": 1, "ScheduleTime": "0", "ScheduleDay": "1,2,3", "ScheduleMonth": "1" }, "Incremental": { "FilterCondition": "ID > 0" }, "WriteMode": "OsxY57njiKm" }, "AdvancedConfig": { "ColumnAlignmentType": "NO_ALIGNMENT", "BatchMode": "JDBC", "DtsSubscriptionTaskId": "dts_123", "DtsSubscriptionTaskName": "test_subscribe", "Debezium": [ "c" ], "CustomParameter": [ { "Key": "key1", "Value": "value1", "Type": "String" } ] }, "PartitionMode": "NoPartitionMode", "PartitionDefinition": "partition1" } ] } }
下表为您列举了该接口与业务逻辑相关的错误码。公共错误码请参见公共错误码文档。
状态码 | 错误码 | 说明 |
|---|---|---|
200 | InternalError | 获取表映射配置错误 |