Flashcat API

查询数据库表结构

开发中

POST

https://api.flashcat.cloud/api/n9e-plus/db-desc-table

最后修改时间：2024-08-22 05:11:26

请求示例

Shell

JavaScript

Java

Swift

curl --location --request POST 'https://api.flashcat.cloud/api/n9e-plus/db-desc-table' \
--header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NfdXVpZCI6IjVhZTliYjliLWM4MGMtNDdjNy1iMmYxLTVlODNlMzk3MTQ4YiIsImF1dGhvcml6ZWQiOnRydWUsImV4cCI6MTcyNDM4MDU4OCwidXNlcl9pZGVudGl0eSI6IjEtcm9vdCJ9.JE5k2aY9YXYC7oUQ59K8UwzpkJBJvt53WI9arZKOqic' \
--header 'X-Language: zh_CN' \
--header 'Cookie: Goland-d1b8a466=488855f3-c676-4947-9c9e-ee2caf3d4f9b' \
--header 'Content-Type: application/json;charset=UTF-8' \
--data-raw '{"cate":"ck","datasource_id":4,"query":[{"database":"default","table":"student"}]}'

响应示例

{
  "dat": [
    {
      "field": "name",
      "type": "Nullable(String)",
      "indexable": false
    },
    {
      "field": "age",
      "type": "Nullable(Int32)",
      "indexable": false
    }
  ],
  "err": ""
}

请求参数

Authorization

在 Header 添加参数

Authorization

，其值为在 Bearer 之后拼接 Token

示例：

Authorization: Bearer ********************

Header 参数

Authorization

string

必需

示例值:

Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NfdXVpZCI6IjVhZTliYjliLWM4MGMtNDdjNy1iMmYxLTVlODNlMzk3MTQ4YiIsImF1dGhvcml6ZWQiOnRydWUsImV4cCI6MTcyNDM4MDU4OCwidXNlcl9pZGVudGl0eSI6IjEtcm9vdCJ9.JE5k2aY9YXYC7oUQ59K8UwzpkJBJvt53WI9arZKOqic

Content-Type

string

必需

示例值:

application/json;charset=UTF-8

string

必需

示例值:

Goland-d1b8a466=488855f3-c676-4947-9c9e-ee2caf3d4f9b

X-Language

string

必需

示例值:

zh_CN

Body 参数application/json

cate

string

必需

datasource_id

integer

必需

query

array [object {2}]

必需

database

string

可选

table

string

可选

示例

返回响应

🟢200成功

application/json

Body

dat

array [object {3}]

必需

field

string

必需

type

string

必需

indexable

boolean

必需

err

string

必需

查询数据库表名称列表

sql 查询 table