API-body中的columns参数结构
本接口一共对应5张数据库表，请您传数据时找到对应表进行参数构建
第一张表 变电站每日实时负荷表
1. tableName（表名）：prodSched_he_substation_loads（变电站每日实时负荷表）
2. 请求体（Body）结构说明
{
"tableName": "prodSched_he_substation_loads",
"columns": [
{
"columnName": "substation_date",
"dataType": "timestamp"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "total_load",
"dataType": "string"
},
{
"columnName": "total_load_unit",
"dataType": "string"
},
{
"columnName": "one_load_high",
"dataType": "string"
},
{
"columnName": "one_load_high_unit",
"dataType": "string"
},
{
"columnName": "one_load_middle",
"dataType": "string"
},
{
"columnName": "one_load_middle_unit",
"dataType": "string"
},
{
"columnName": "one_load_low",
"dataType": "string"
},
{
"columnName": "one_load_low_unit",
"dataType": "string"
},
{
"columnName": "two_load_high",
"dataType": "string"
},
{
"columnName": "two_load_high_unit",
"dataType": "string"
},
{
"columnName": "two_load_middle",
"dataType": "string"
},
{
"columnName": "two_load_middle_unit",
"dataType": "string"
},
{
"columnName": "two_load_low",
"dataType": "string"
},
{
"columnName": "two_load_low_unit",
"dataType": "string"
},
{
"columnName": "one_transformer_load",
"dataType": "string"
},
{
"columnName": "one_transformer_load_unit",
"dataType": "string"
},
{
"columnName": "two_transformer_load",
"dataType": "string"
},
{
"columnName": "two_transformer_load_unit",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "2025-07-25", "0881id", "测点名","厂站名称","厂站编号", "总负荷","MW", "#1主变高压侧负荷","MW", "#1主变中压侧负荷","MW", "#1主变低压侧负荷","MW", "#2主变高压侧负荷","MW",
"#2主变中压侧负荷","MW", "#2主变低压侧负荷","MW", "#1变压器负荷率","%", "#2变压器负荷率","%", "2025-08-18"
],
[ "2025-07-26", "0881id", "测点名","厂站名称","厂站编号", "总负荷","MW", "#1主变高压侧负荷","MW", "#1主变中压侧负荷","MW", "#1主变低压侧负荷","MW", "#2主变高压侧负荷","MW",
"#2主变中压侧负荷","MW", "#2主变低压侧负荷","MW", "#1变压器负荷率","%", "#2变压器负荷率","%", "2025-08-18"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| substation_date | string | 是 | 变电站时间 | "2025-08-29 11:12:20" |
| id | string | 是 | id | 0881id |
| measure_point | string | 否 | 测点名 | |
| substation_name | string | 是 | 厂站名称 | 220kV光华变电站 |
| substation_code | string | 是 | 厂站编码 | gh |
| total_load | string | 否 | 总负荷 | |
| one_load_high | string | 否 | #1主变高压侧负荷 | |
| one_load_high_unit | string | 否 | #1主变高压侧负荷单位 | |
| one_load_middle | string | 否 | #1主变中压侧负荷 | |
| one_load_middle_unit | string | 否 | #1主变中压侧负荷单位 | |
| one_load_low | string | 否 | #1主变低压侧负荷 | |
| one_load_low_unit | string | 否 | #1主变低压侧负荷单位 | |
| two_load_high | string | 否 | #2主变高压侧负荷 | |
| two_load_high_unit | string | 否 | #2主变高压侧负荷单位 | |
| two_load_middle | string | 否 | #2主变中压侧负荷 | |
| two_load_middle_unit | string | 否 | #2主变中压侧负荷单位 | |
| two_load_low | string | 否 | #2主变低压侧负荷 | |
| two_load_low_unit | string | 否 | #2主变低压侧负荷单位 | |
| one_transformer_load | string | 否 | #1变压器负荷率 | |
| one_transformer_load_unit | string | 否 | #1变压器负荷率单位 | |
| two_transformer_load | string | 否 | #2变压器负荷率 | |
| two_transformer_load_unit | string | 否 | #2变压器负荷率单位 | |
| create_date | string | 否 | 数据推送时间 | "2025-08-29 11:12:20" |
4. 数据推送频率
五秒更新一次即可（1次/5秒）
第二张表 每日大客户负荷和用电量表
1. tableName（表名）：prodSched_he_substation_bigCustomer_load(每日大客户负荷和用电量表)
2. 请求体（Body）结构说明
{
"tableName": "prodSched_he_substation_bigCustomer_load",
"columns": [
{
"columnName": "load_date",
"dataType": "timestamp"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "tl_max_load",
"dataType": "string"
},
{
"columnName": "tl_max_load_unit",
"dataType": "string"
},
{
"columnName": "tl_min_load",
"dataType": "string"
},
{
"columnName": "tl_min_load_unit",
"dataType": "string"
},
{
"columnName": "hs_max_load",
"dataType": "string"
},
{
"columnName": "hs_max_load_unit",
"dataType": "string"
},
{
"columnName": "hs_min_load",
"dataType": "string"
},
{
"columnName": "hs_min_load_unit",
"dataType": "string"
},
{
"columnName": "dq_max_load",
"dataType": "string"
},
{
"columnName": "dq_max_load_unit",
"dataType": "string"
},
{
"columnName": "dq_min_load",
"dataType": "string"
},
{
"columnName": "dq_min_load_unit",
"dataType": "string"
},
{
"columnName": "gyy_max_load",
"dataType": "string"
},
{
"columnName": "gyy_max_load_unit",
"dataType": "string"
},
{
"columnName": "gyy_min_load",
"dataType": "string"
},
{
"columnName": "gyy_min_load_unit",
"dataType": "string"
},
{
"columnName": "nz_max_load",
"dataType": "string"
},
{
"columnName": "nz_max_load_unit",
"dataType": "string"
},
{
"columnName": "nz_min_load",
"dataType": "string"
},
{
"columnName": "nz_min_load_unit",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "2025-07-25" , "0881id" , "测点名" , "248" , "MW" , "221" , "MW" , "252" , "MW" , "121" , "MW" , "111", "MW" ,"101" , "MW" , "189" , "MW" , "100" , "MW" , "189" , "MW" , "100" , "MW" , "2025-08-18"
],
[ "2025-07-24" , "0881id" , "测点名" , "252" , "MW" , "221" , "MW" , "252" , "MW" , "133" , "MW" , "111", "MW" ,"101" , "MW" , "255" , "MW" , "100" , "MW" , "189" , "MW" , "100" , "MW" , "2025-08-18"
],
[ "2025-07-23" , "0881id" , "测点名" , "332" , "MW" , "221" , "MW" , "252" , "MW" , "121" , "MW" , "111", "MW" ,"101" , "MW" , "189" , "MW" , "100" , "MW" , "189" , "MW" , "100" , "MW" , "2025-08-18"
],
[ "2025-07-28" , "0881id" , "测点名" , "312" , "MW" , "221" , "MW" , "252" , "MW" , "121" , "MW" , "111", "MW" ,"101" , "MW" , "189" , "MW" , "100" , "MW" , "189" , "MW" , "100" , "MW" , "2025-08-18"
],
[ "2025-07-27" , "0881id" , "测点名" , "414" , "MW" , "221" , "MW" , "252" , "MW" , "121" , "MW" , "111", "MW" ,"101" , "MW" , "189" , "MW" , "100" , "MW" , "189" , "MW" , "100" , "MW" , "2025-08-18"
],
[ "2025-07-22" , "0881id" , "测点名" , "489" , "MW" , "221" , "MW" , "252" , "MW" , "121" , "MW" , "111", "MW" ,"101" , "MW" , "189" , "MW" , "100" , "MW" , "189" , "MW" , "100" , "MW" , "2025-08-18"
],
[ "2025-07-21" , "0881id" , "测点名" , "235" , "MW" , "221" , "MW" , "252" , "MW" , "121" , "MW" , "111", "MW" ,"101" , "MW" , "189" , "MW" , "100" , "MW" , "189" , "MW" , "100" , "MW" , "2025-08-18"
],
[ "2025-07-20" , "0881id" , "测点名" , "474" , "MW" , "221" , "MW" , "252" , "MW" , "121" , "MW" , "111", "MW" ,"101" , "MW" , "189" , "MW" , "100" , "MW" , "189" , "MW" , "100" , "MW" , "2025-08-18"
],
[ "2025-07-26" , "0881id" , "测点名" , "412" , "MW" , "221" , "MW" , "252" , "MW" , "121" , "MW" , "111", "MW" ,"101" , "MW" , "189" , "MW" , "100" , "MW" , "189" , "MW" , "100" , "MW" , "2025-08-18"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| load_date | string | 是 | 负荷日期 | "2025-08-29" |
| id | string | 是 | id | 0881id |
| measure_point | string | 否 | 测点名 | |
| tl_max_load | string | 否 | 天铝最大负荷 | |
| tl_max_load_unit | string | 否 | 天铝最大负荷单位 | |
| tl_min_load | string | 否 | 天铝最小负荷 | |
| tl_min_load_unit | string | 否 | 天铝最小负荷单位 | |
| hs_max_load | string | 否 | 合盛最大负荷 | |
| hs_max_load_unit | string | 否 | 合盛最大负荷单位 | |
| hs_min_load | string | 否 | 合盛最小负荷 | |
| hs_min_load_unit | string | 否 | 合盛最小负荷单位 | |
| dq_max_load | string | 否 | 大全最大负荷 | |
| dq_max_load_unit | string | 否 | 大全最大负荷单位 | |
| dq_min_load | string | 否 | 大全最小负荷 | |
| dq_min_load_unit | string | 否 | 大全最小负荷单位 | |
| gyy_max_load | string | 否 | 147工业园最大负荷 | |
| gyy_max_load_unit | string | 否 | 147工业园最大负荷单位 | |
| gyy_min_load | string | 否 | 147工业园最小负荷 | |
| gyy_min_load_unit | string | 否 | 147工业园最小负荷单位 | |
| nz_max_load | string | 否 | 农站最大负荷 | |
| nz_max_load_unit | string | 否 | 农站最大负荷单位 | |
| nz_min_load | string | 否 | 农站最小负荷 | |
| nz_min_load_unit | string | 否 | 农站最小负荷单位 | |
| create_date | string | 否 | 数据推送时间 | "2025-08-29 11:12:20" |
4. 数据推送频率
一天更新一次（1次/天）
第三张表 每日全网公司负荷表
1. tableName（表名）：prodSched_he_daily_load
2. 请求体（Body）结构说明
{
"tableName": "prod_sched_he_daily_load",
"columns": [
{
"columnName": "data_date",
"dataType": "timestamp"
},
{
"columnName": "max_load_net",
"dataType": "double"
},
{
"columnName": "min_load_net",
"dataType": "double"
},
{
"columnName": "max_load_company",
"dataType": "double"
},
{
"columnName": "min_load_company",
"dataType": "double"
},
{
"columnName": "max_power_supply_net",
"dataType": "double"
},
{
"columnName": "min_power_supply_net",
"dataType": "double"
},
{
"columnName": "max_power_supply_company",
"dataType": "double"
},
{
"columnName": "min_power_supply_net",
"dataType": "double"
},
{
"columnName": "unit",
"dataType": "string"
}
],
"rows": [
[ "2025-07-25", 1000.1, 1000.2,1000.3,1000.4, 1000.5,1000.6, 1000.7,1000.8,"kv"]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| data_date | timestamp | 是 | 日期 | "2025-08-29" |
| max_load_net | double | 否 | 全网发电最大负荷 | |
| min_load_net | double | 否 | 全网发电最小负荷 | |
| max_load_company | double | 否 | 公司发电最大负荷 | |
| min_load_company | double | 否 | 公司发电最小负荷 | |
| max_power_supply_net | double | 否 | 全网供电最大负荷 | |
| min_power_supply_net | double | 否 | 全网供电最小负荷 | |
| max_power_supply_company | double | 否 | 公司供电最大负荷 | |
| min_power_supply_company | double | 否 | 公司供电最小负荷 | |
| unit | string | 否 | 单位 |
4. 数据推送频率
现场数据实时更新
第四张表 国网下电量表
1. tableName（表名）：prodSched_wang_power_consumption
2. 请求体（Body）结构说明
{
"tableName": "prod_sched_wang_power_consumption",
"columns": [
{
"columnName": "data_date",
"dataType": "timestamp"
},
{
"columnName": "supply_power",
"dataType": "double"
},
{
"columnName": "consumption_power",
"dataType": "double"
},
{
"columnName": "220kv_input",
"dataType": "double"
},
{
"columnName": "unit",
"dataType": "string"
}
],
"rows": [
[ "2025-07-25", 1000.1, 1000.2,1000.3,"kv"]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| data_date | timestamp | 是 | 日期 | "2025-08-29" |
| supply_power | double | 否 | 国网下网电量 | |
| consumption_power | double | 否 | 耗损电量 | |
| 220kv_input | double | 否 | 220kv输入电量 | |
| unit | string | 否 | 单位 |
4. 数据推送频率
现场数据实时更新
第五张表 变电站每日运行数据表
1. tableName（表名）：prodSched_he_substation_operations（变电站每日运行数据表）
2. 请求体（Body）结构说明
{
"tableName": "prodSched_he_substation_operations",
"columns": [{
"columnName": "operations_date",
"dataType": "timestamp"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "max_load",
"dataType": "string"
},
{
"columnName": "max_load_unit",
"dataType": "string"
},
{
"columnName": "transmission_capacity",
"dataType": "string"
},
{
"columnName": "transmission_capacity_unit",
"dataType": "string"
},
{
"columnName": "power_loss",
"dataType": "string"
},
{
"columnName": "power_loss_unit",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
["2022-08-25", "0881id", "测点名", "厂站名称", "厂站编码", "236.5", "万kWh", "232.8", "万kWh", "1.2", "万kWh", "2025-08-18"],
["2022-08-27", "0881id", "测点名", "厂站名称", "厂站编码", "415.5", "万kWh", "212.8", "万kWh", "1.3", "万kWh", "2025-08-18"],
["2022-09-28", "0881id", "测点名", "厂站名称", "厂站编码", "334.5", "万kWh", "323.8", "万kWh", "1.4", "万kWh", "2025-08-18"],
["2022-09-29", "0881id", "测点名", "厂站名称", "厂站编码", "758.5", "万kWh", "32.8", "万kWh", "1.63", "万kWh", "2025-08-18"],
["2023-01-29", "0881id", "测点名", "厂站名称", "厂站编码", "243.5", "万kWh", "32.8", "万kWh", "1.63", "万kWh", "2025-08-18"],
["2023-02-12", "0881id", "测点名", "厂站名称", "厂站编码", "244.5", "万kWh", "32.8", "万kWh", "1.63", "万kWh", "2025-08-18"],
["2023-03-11", "0881id", "测点名", "厂站名称", "厂站编码", "245.5", "万kWh", "32.8", "万kWh", "1.63", "万kWh", "2025-08-18"],
["2023-03-12", "0881id", "测点名", "厂站名称", "厂站编码", "268.5", "万kWh", "32.8", "万kWh", "1.63", "万kWh", "2025-08-18"],
["2023-04-15", "0881id", "测点名", "厂站名称", "厂站编码", "357.5", "万kWh", "32.8", "万kWh", "1.63", "万kWh", "2025-08-18"],
["2023-05-01", "0881id", "测点名", "厂站名称", "厂站编码", "386.5", "万kWh", "32.8", "万kWh", "1.63", "万kWh", "2025-08-18"]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| operations_date | string | 是 | 运行日期 | "2025-08-29" |
| id | string | 是 | id | 0881id |
| measure_point | string | 否 | 测点名 | |
| substation_name | string | 是 | 厂站名称 | 220kV光华变电站 |
| substation_code | string | 是 | 厂站编码 | gh |
| max_load | string | 否 | 最大负荷 | |
| max_load_unit | string | 否 | 最大负荷单位 | |
| transmission_capacity | string | 否 | 输电量 | |
| transmission_capacity_unit | string | 否 | 输电量单位 | |
| power_loss | string | 否 | 损耗电量(包含母线损耗电量) | |
| power_loss_unit | string | 否 | 损耗电量单位 | |
| create_date | string | 否 | 数据推送时间 | "2025-08-29 11:12:20" |
4. 数据推送频率
一天更新一次即可（1次/天）
微信扫描二维码修改于 2025-09-18 05:31:58