创建对应表

POST

/datacenter/universal/interface/createTable

创建对应表

请求参数

Header 参数

Body 参数application/json

示例

{
    "secretKey": "Gmkb80tPQDOu2aCO",
    "tableName": "TEST_TABLE_TEST1015",
    "tableComment": "测试表",
    "tableStatus": "1",
    "createType": "1",
    "contact": "测试人员",
    "contactPhone": "11111122222",
    "description": "测试",
    "effective": "是",
    "datasource": "DM",
    "createDeptName": "山西黎霍高速公路有限公司",
    "systemName": "子公司",
    "columnList": [
        {
            "columnName": "USER_NAME_1",
            "columnType": "VARCHAR",
            "nullable": true,
            "columnLength": 100,
            "columncomment": "用户名称"
        },
        {
            "columnName": "USER_TYPE",
            "columnType": "VARCHAR",
            "nullable": true,
            "columnLength": 100,
            "columncomment": "用户类型",
            "defaultValue": "1"
        },
        {
            "columnName": "USER_COUNT",
            "columnType": "INTEGER",
            "nullable": true,
            "columnLength": 10,
            "columnComment": "用户总数"
        }
    ]
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST '/datacenter/universal/interface/createTable' \
--header 'Authorization: Bearer eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbiIsInRlbmFudElkIjoiLTEiLCJleHAiOjE3NzQ5MzgyOTAsImlhdCI6MTc3NDg1MTg5MH0.lNcYtnmLTLUbsm2ZZA6ya3Niumykikygxu3hAFSuXUyDDaY8Dydtm4QjyP8n_3CtQAs9orXbtc7N7tVU_ziUvw' \
--header 'Content-Type: application/json' \
--data-raw '{
    "secretKey": "Gmkb80tPQDOu2aCO",
    "tableName": "TEST_TABLE_TEST1015",
    "tableComment": "测试表",
    "tableStatus": "1",
    "createType": "1",
    "contact": "测试人员",
    "contactPhone": "11111122222",
    "description": "测试",
    "effective": "是",
    "datasource": "DM",
    "createDeptName": "山西黎霍高速公路有限公司",
    "systemName": "子公司",
    "columnList": [
        {
            "columnName": "USER_NAME_1",
            "columnType": "VARCHAR",
            "nullable": true,
            "columnLength": 100,
            "columncomment": "用户名称"
        },
        {
            "columnName": "USER_TYPE",
            "columnType": "VARCHAR",
            "nullable": true,
            "columnLength": 100,
            "columncomment": "用户类型",
            "defaultValue": "1"
        },
        {
            "columnName": "USER_COUNT",
            "columnType": "INTEGER",
            "nullable": true,
            "columnLength": 10,
            "columnComment": "用户总数"
        }
    ]
}'

返回响应

🟢200成功

application/json

Body

示例

{
  "code": 0,
  "data": "",
  "msg": ""
}

修改于 2025-10-15 08:16:44

获得某表的列数据

第三方数据入库