Files
2026-05-18 09:28:15 +08:00

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)
```