125 lines
2.4 KiB
Markdown
125 lines
2.4 KiB
Markdown
# 静态数据接口
|
|
|
|
## 基本配置
|
|
|
|
| 字段 | 值 | 说明 |
|
|
|------|-----|------|
|
|
| type | 2 | 静态数据 |
|
|
| action | 0 | 无 |
|
|
| staticData | JSON字符串 | 固定数据 |
|
|
|
|
## 数据格式
|
|
|
|
### 数组格式
|
|
|
|
```json
|
|
[
|
|
{"id": "1", "name": "选项1"},
|
|
{"id": "2", "name": "选项2"}
|
|
]
|
|
```
|
|
|
|
### 对象格式
|
|
|
|
```json
|
|
{
|
|
"categories": ["类别1", "类别2"],
|
|
"series": [{"name": "系列1", "data": [120, 200]}]
|
|
}
|
|
```
|
|
|
|
## 图表静态数据示例
|
|
|
|
### 柱状图
|
|
|
|
```json
|
|
{
|
|
"categories": ["苹果品牌", "三星品牌", "小米品牌"],
|
|
"series": [
|
|
{"name": "2024年", "data": [335, 310, 234]},
|
|
{"name": "2023年", "data": [502, 534, 763]}
|
|
]
|
|
}
|
|
```
|
|
|
|
### 折线图
|
|
|
|
```json
|
|
{
|
|
"categories": ["苹果", "三星", "小米", "oppo", "vivo"],
|
|
"series": [
|
|
{"name": "销量", "data": [235, 189, 156, 208, 133]}
|
|
]
|
|
}
|
|
```
|
|
|
|
### 饼图
|
|
|
|
```json
|
|
{
|
|
"title": {"text": "天气情况统计", "subtext": "虚构数据"},
|
|
"series": [
|
|
{"name": "访问来源", "data": [{"value": 335, "name": "直接访问"}]}
|
|
]
|
|
}
|
|
```
|
|
|
|
### 雷达图
|
|
|
|
```json
|
|
{
|
|
"indicator": [
|
|
{"name": "销售", "max": 6500},
|
|
{"name": "管理", "max": 16000}
|
|
],
|
|
"series": [{"data": [{"value": [4300, 10000, 2800, 3500, 5000], "name": "预算分配"}]}]
|
|
}
|
|
```
|
|
|
|
## 级联选择静态数据
|
|
|
|
```json
|
|
[
|
|
{
|
|
"id": "d7f26bf6ad224054a6d3276b62eeeb43",
|
|
"hasChildren": true,
|
|
"fullName": "广东省",
|
|
"children": [
|
|
{"id": "child1", "fullName": "广州市", "hasChildren": false}
|
|
]
|
|
}
|
|
]
|
|
```
|
|
|
|
## 参考示例
|
|
|
|
| ID | 名称 | 用途 |
|
|
|-----|------|------|
|
|
| cd6fe911f90048f0bba7ef9f38251d96 | 柱状图 | 图表配置 |
|
|
| be312b18a1664d8787e0dfcd2412969f | 折线图 | 图表配置 |
|
|
| 79e5455c2f0d4d8ba2b444249bae0490 | 饼图 | 图表配置 |
|
|
| 8ce8ccf7a3bf48a79a0c2bff20b46726 | 象形图 | 图表配置 |
|
|
| 78814d0a32fa41ae8427b708bfadb808 | 雷达图 | 图表配置 |
|
|
| 04d910fb47f4469e907a5c85949329cb | 散点图 | 图表配置 |
|
|
| 3044325436d347af9b59a617f10e3ab6 | 漏斗图 | 图表配置 |
|
|
| 469493919109937797 | 测试级联_字段列表 | 级联选择 |
|
|
|
|
## AIBridge创建
|
|
|
|
```python
|
|
# 静态数据直接存储在dataConfigJson.staticData中
|
|
payload = {
|
|
"fullName": "下拉选项",
|
|
"enCode": "dropdown_options",
|
|
"type": 2,
|
|
"action": 0,
|
|
"dataConfigJson": json.dumps({
|
|
"staticData": '[{"id":"1","name":"选项1"},{"id":"2","name":"选项2"}]',
|
|
"sqlData": {"dbLinkId": "", "sql": ""},
|
|
"apiData": {}
|
|
})
|
|
}
|
|
|
|
di.create(payload)
|
|
```
|