查询数据

开发中

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

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

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}

示例

{}

修改于 2025-02-28 12:22:04

问数以及问答

猜你想问