Skip to main content

List Type Mapping

Interface Overview

Gets a data type map for presentation

Interface Address

/cloudcanal/console/api/v1/openapi/datasource/listcoltypemapping

Request Manner

POST

Request Parameters

ParameterNameParameter DescriptionRequestTypeWhether RequiredDataType
dstDsIdID of the source data sourceBodyTrueLong
srcDsIdID of the target data sourceBodyTrueLong

Public response result

ParameterNameParameter DescriptionType(Java)NotNull
code1: success, 0: failureStringTrue
dataObjectFalse
msgStringFalse
requestIdStringTrue

Data Parameter

data is the mapping between the type of the source end and the type of the target end. For the time being, one type on the source end cannot be paired with multiple types on the target end.

Response Example

{
"requestId": "7d61897e-2be2-11ec-b616-f194b7b514f9",
"code": "1",
"msg": "request success",
"data": {
"BLOB": "BLOB",
"FLOAT": "FLOAT",
"POLYGON": "POLYGON",
"SET": "SET",
"BINARY": "BINARY",
"DECIMAL": "DECIMAL",
"CHAR": "CHAR",
"TEXT": "TEXT",
"JSON": "JSON",
"MEDIUMTEXT": "MEDIUMTEXT",
"MULTIPOLYGON": "MULTIPOLYGON",
"INT": "INT",
"YEAR": "INT",
"GEOMCOLLECTION": "GEOMCOLLECTION",
"TIMESTAMP": "TIMESTAMP",
"DOUBLE": "DOUBLE",
"TINYTEXT": "TINYTEXT",
"LONGBLOB": "LONGBLOB",
"TINYINT": "TINYINT",
"GEOMETRYCOLLECTION": "GEOMETRYCOLLECTION",
"GEOMETRY": "GEOMETRY",
"ENUM": "ENUM",
"MULTIPOINT": "MULTIPOINT",
"LINESTRING": "LINESTRING",
"LONGTEXT": "LONGTEXT",
"TIME": "TIME",
"BIGINT": "BIGINT",
"MEDIUMINT": "MEDIUMINT",
"BIT": "BINARY",
"DATE": "DATE",
"MULTILINESTRING": "MULTILINESTRING",
"DATETIME": "DATETIME",
"MEDIUMBLOB": "MEDIUMBLOB",
"TINYBLOB": "TINYBLOB",
"SMALLINT": "SMALLINT",
"VARCHAR": "VARCHAR",
"VARBINARY": "VARBINARY",
"POINT": "POINT"
}
}