- chat
- app-弃用
- sql
- 工具调用
- image
- file
- 通用版智能问数
- 重庆-智能问数
- 新疆-智能问数
- mcp
- manus
查询数据
开发中
POST
http://localhost:8086/wenShu/getDataAndType
请求参数
Body 参数application/json
object {0}
示例
{
"sessionId":"112b54fd54a44e97bd672df6ee72a7f7",
"msgId":"2f71949bd70d4f91a66c44de56b1cb60",
"sql":"SELECT a.power_month AS `月份`,a.power_num AS `实际售电量_亿kWh`,b.expect_num AS `预测售电量_亿kWh` FROM tb_dlyc_area_power_month a LEFT JOIN tb_dlyc_area_prediction_result b ON a.org_name = b.org_name AND a.power_month = b.expect_month WHERE a.org_name = '阿勒泰' AND a.power_year = '2024' AND a.power_month BETWEEN '01' AND '06' AND b.expect_year = '2024' ORDER BY a.power_month",
"prompt":"帮我查一下2024年阿勒泰1~6月的售电量。",
"dataSourceId":"1727170624134"
}示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request POST 'http://localhost:8086/wenShu/getDataAndType' \
--header 'Content-Type: application/json' \
--data-raw '{
"sessionId":"112b54fd54a44e97bd672df6ee72a7f7",
"msgId":"2f71949bd70d4f91a66c44de56b1cb60",
"sql":"SELECT a.power_month AS `月份`,a.power_num AS `实际售电量_亿kWh`,b.expect_num AS `预测售电量_亿kWh` FROM tb_dlyc_area_power_month a LEFT JOIN tb_dlyc_area_prediction_result b ON a.org_name = b.org_name AND a.power_month = b.expect_month WHERE a.org_name = '\''阿勒泰'\'' AND a.power_year = '\''2024'\'' AND a.power_month BETWEEN '\''01'\'' AND '\''06'\'' AND b.expect_year = '\''2024'\'' ORDER BY a.power_month",
"prompt":"帮我查一下2024年阿勒泰1~6月的售电量。",
"dataSourceId":"1727170624134"
}'返回响应
🟢200成功
application/json
Body
object {0}
示例
{}