API-body中的columns参数结构
本接口一共对应5张数据库表，请您传数据时找到对应表进行参数构建
第一张表 光伏电厂每日信息记录表
1. tableName（表名）：neccPlat_yuan_photovoltaics(光伏电厂每日信息记录表)
2. 请求体（Body）结构说明
{
"tableName": "neccPlat_yuan_photovoltaics",
"columns": [
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "record_date",
"dataType": "timestamp"
},
{
"columnName": "target_name",
"dataType": "string"
},
{
"columnName": "target_value",
"dataType": "string"
},
{
"columnName": "target_unit",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "发电量", "120.56", "kWh","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "供电量", "108.2666", "kWh","2025-08-19 11:35:26"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| measure_point | string | 是 | 测点名 | |
| id | string | 是 | id | |
| substation_name | string | 是 | 厂站名称 | "绿能134团永安光伏站" |
| substation_code | string | 是 | 厂站编码(用名称的首字母简写) | "lnyagfz" |
| record_date | timestamp | 是 | 记录日期(yyyy-MM-dd) | "2025-08-19" |
| target_name | string | 是 | 指标名称（发电量、供电量） | 发电量 |
| target_value | string | 否 | 指标值 | |
| target_unit | string | 否 | 指标单位 | |
| create_date | timestamp | 否 | 数据推送时间 | "2025-08-29 11:12:20" |
4. 数据推送频率
一天更新一次（1次/天）
第二张表 储能电厂每日信息记录表
1. tableName（表名）：neccPlat_chu_storages(储能电厂每日信息记录表)
2. 请求体（Body）结构说明
{
"tableName": "neccPlat_chu_storages",
"columns": [
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "record_date",
"dataType": "timestamp"
},
{
"columnName": "target_name",
"dataType": "string"
},
{
"columnName": "target_type",
"dataType": "string"
},
{
"columnName": "target_value",
"dataType": "string"
},
{
"columnName": "target_unit",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "供电量", "光伏储能","220","kWh","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "放电量", "光伏储能","140","kWh","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "充电量", "光伏储能","324","kWh","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "最大负荷", "光伏储能","141","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "最小负荷", "光伏储能","252","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "供电量", "抽水蓄能","112","kWh","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "放电量", "抽水蓄能","323","kWh","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "充电量", "抽水蓄能","454","kWh","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "最大负荷", "抽水蓄能","524","kWh","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "最小负荷", "抽水蓄能","125","kWh","2025-08-19 11:35:26"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| measure_point | string | 是 | 测点名 | |
| id | string | 是 | id | |
| substation_name | string | 是 | 厂站名称 | "绿能134团永安光伏站" |
| substation_code | string | 是 | 厂站编码 | "lnyagfz" |
| record_date | timestamp | 是 | 记录日期(yyyy-MM-dd) | "2025-08-19" |
| target_name | string | 是 | 指标名称（供电量、放电量、充电量、最大负荷、最小负荷） | |
| target_type | string | 是 | 指标类型（光伏储能、抽水蓄能） | |
| target_value | string | 否 | 指标值 | |
| target_unit | string | 否 | 指标单位 | |
| create_date | timestamp | 否 | 数据推送时间 | "2025-08-29 11:12:20" |
4. 数据推送频率
一天更新一次（1次/天）
第三张表 电厂环境记录表
1. tableName（表名）：neccPlat_yuan_circumstances(电厂环境记录表)
2. 请求体（Body）结构说明
{
"tableName": "neccPlat_yuan_circumstances",
"columns": [
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "record_date",
"dataType": "timestamp"
},
{
"columnName": "target_name",
"dataType": "string"
},
{
"columnName": "target_value",
"dataType": "string"
},
{
"columnName": "target_unit",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "日照时数","12","h","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "空气温度","23.5","℃","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "相对湿度","28.2","%","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "空气风速", "36","m/s","2025-08-19 11:35:26"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| measure_point | string | 是 | 测点名 | |
| id | string | 是 | id | |
| substation_name | string | 是 | 厂站名称 | "绿能134团永安光伏站" |
| substation_code | string | 是 | 厂站编码(用名称的首字母简写) | "lnyagfz" |
| record_date | timestamp | 是 | 记录日期(yyyy-MM-dd) | "2025-08-19" |
| target_name | string | 是 | 指标名称（日照时数、空气温度、相对湿度、空气风速） | |
| target_value | string | 否 | 指标值 | |
| target_unit | string | 否 | 指标单位 | |
| create_date | timestamp | 否 | 数据推送时间 | "2025-08-29 11:12:20" |
4. 数据推送频率
一天更新一次（1次/天）
第四张表 光伏电厂实时数据记录表
1. tableName（表名）：neccPlat_yuan_photovoltaics_real(光伏电厂实时数据记录表)
2. 请求体（Body）结构说明
{
"tableName": "neccPlat_yuan_photovoltaics_real",
"columns": [
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "record_date",
"dataType": "timestamp"
},
{
"columnName": "target_name",
"dataType": "string"
},
{
"columnName": "target_value",
"dataType": "string"
},
{
"columnName": "target_unit",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19","实时负荷","153","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19","今年实际发电量","2500","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-20","实时负荷","155","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-20","今年实际发电量","2600","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-21","实时负荷","175","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-21","今年实际发电量","2861","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "驼铃光伏", "tlgf", "2025-08-19","实时负荷","147","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "驼铃光伏", "tlgf", "2025-08-19","今年实际发电量","852","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "驼铃光伏", "tlgf", "2025-08-20","实时负荷","151","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "驼铃光伏", "tlgf", "2025-08-20","今年实际发电量","896","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "驼铃光伏", "tlgf", "2025-08-21","实时负荷","122","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "驼铃光伏", "tlgf", "2025-08-21","今年实际发电量","984","MW","2025-08-19 11:35:26"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| measure_point | string | 是 | 测点名 | |
| id | string | 是 | id | |
| substation_name | string | 是 | 厂站名称 | "绿能134团永安光伏站" |
| substation_code | string | 是 | 厂站编码(用名称的首字母简写) | "lnyagfz" |
| record_date | timestamp | 是 | 记录日期(yyyy-MM-dd) | "2025-08-19" |
| target_name | string | 是 | 指标名称（实时负荷、今年实际发电量） | |
| target_value | string | 否 | 指标值 | |
| target_unit | string | 否 | 指标单位 | |
| create_date | timestamp | 否 | 数据推送时间(yyyy-MM-dd hh:mm:ss) | "2025-08-29 11:12:20" |
4. 数据推送频率
五秒更新一次即可（1次/5秒）
第五张表 储能电厂实时数据记录表
1. tableName（表名）：neccPlat_chu_storages_real(储能电厂实时数据记录表)
2. 请求体（Body）结构说明
{
"tableName": "neccPlat_chu_storages_real",
"columns": [
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "record_date",
"dataType": "timestamp"
},
{
"columnName": "target_name",
"dataType": "string"
},
{
"columnName": "target_value",
"dataType": "string"
},
{
"columnName": "target_unit",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19","实时负荷","153","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19","今年累计供电量","2500","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19","去年累计供电量","155","MW","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19","储能效率","2600","%","2025-08-19 11:35:26"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| measure_point | string | 是 | 测点名 | |
| id | string | 是 | id | |
| substation_name | string | 是 | 厂站名称 | "绿能134团永安光伏站" |
| substation_code | string | 是 | 厂站编码(用名称的首字母简写) | "lnyagfz" |
| record_date | timestamp | 是 | 记录日期(yyyy-MM-dd) | "2025-08-19" |
| target_name | string | 是 | 指标名称（实时负荷、今年累计供电量、去年累计供电量、储能效率） | |
| target_value | string | 否 | 指标值 | |
| target_unit | string | 否 | 指标单位 | |
| create_date | timestamp | 否 | 数据推送时间(yyyy-MM-dd hh:mm:ss) | "2025-08-29 11:12:20" |
4. 数据推送频率
五秒更新一次即可（1次/5秒）
微信扫描二维码修改于 2025-09-17 09:00:29