




版權說明:本文檔由用戶提供并上傳,收益歸屬內容提供方,若內容存在侵權,請進行舉報或認領
文檔簡介
公共機構能源資源消費統計信息系統數據對接格式2020年11月總述本格式文檔提供了數據對接的接口,旨在將各地區自有系統中的統計數據對接入公共機構能源資源消費統計信息系統,包括基層表和綜合表。可按照下述步驟,完成采集平臺數據對接工作:完成采集平臺的授權工作;根據報告期和任務類型獲取任務;按照任務報表格式對接數據。在數據對接的過程中,涉及兩個部分的工作:采集平臺的授權、對接數據的接入。每部分對應的端口地址如表1所示,對接步驟中所需要的接口信息可在后續文檔中查詢。本文檔也提供了對接數據的查詢接口,可滿足后續工作的需求。表1測試環境接入端口整體說明端口地址端口說明備注http://39:8868/服務授權,token獲取http://39:8097/對接數據,數據查詢
服務登錄獲取CODE接口說明方法:GET目的:用于獲取服務授權的code接口地址測試環境地址:39:8868/oauth/authorize請求參數參數名稱參數值參數類型備注grant_typepasswordString固定值response_typecodeString固定值redirect_uri/oauth/codeString固定值client_idweb-stats-ggj-dataString系統代碼頭信息Authorization:"Basic"+base64(username:password)username:用戶名稱password:用戶密碼登錄的用戶名和密碼請找采集平臺要返回值code的字符串postman實例Method:GETurl:39:8868/oauth/authorizeparams={"grant_type":'password','response_type':'code','redirect_uri':'/oauth/code','client_id':'web-stats-ggj-data'}header={"Authorization":"BasicNDQwMDAwX05ZOllXSmpRREV5TXpRMU5nPT0="}返回值:KMpbH6獲取TOKEN接口說明方法:POST目的:用于獲取登錄成功后的授權token信息,包含用戶相關信息接口地址測試環境地址:39:8868/oauth/token請求參數參數名稱參數值參數類型備注grant_typeauthorization_codeString固定值redirect_uri/oauth/codeString固定值codeKMpbH6String1.1獲取CODE返回的code頭信息Authorization:"Basic"+base64(client_id:password)client_id:系統代碼password:密碼返回值token的相關信息postman實例Method:POSTurl:39:8868/oauth/tokenparams={"grant_type":'authorization_code','code':'KMpbH6','redirect_uri':'/oauth/code'}header={"Authorization":"Basicd2ViLXN0YXRzLWdnai1ueSUzQTEyMzQ1Ng=="}返回值:{"access_token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX25hbWUiOiI0NDAwMDBfTlkiLCJzY29wZSI6WyJhdXRoX2NsaWVudCJdLCJleHAiOjE1OTYwOTU3MDEsImNvbmZpZyI6eyJhcmVhSWQiOiI0NDAwMDAiLCJsb2dpbk5hbWUiOiI0NDAwMDBfTlkiLCJwcm9mZXNzaW9ucyI6WyJOWSJdLCJhY3RpdmUiOiIxIiwidXNlckNhcHRpb24iOiLlub_kuJznnIEiLCJhZ2VuY3lJZCI6Ik5PREU0NDAwMDAiLCJjbGFzc05hbWUiOiJvcmcueW91aS5vcGVyYXRvci5lbnRpdHkuVXNlciJ9LCJhdXRob3JpdGllcyI6WyJOWV9ST0xFX1JFU1BPTkRFTlRfUFJPVklOQ0VfQURNSU4iXSwianRpIjoiY2FkOTFlMDMtOWE3Mi00MWNkLTllMWItZDJhZjIyMDgxNmRmIiwiY2xpZW50X2lkIjoid2ViLXN0YXRzLWdnai1ueSJ9.yq_5BSNrAovuCf0xbirKHceHSNiJEPvcxMGd-ahE1Qo","token_type":"bearer","refresh_token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX25hbWUiOiI0NDAwMDBfTlkiLCJzY29wZSI6WyJhdXRoX2NsaWVudCJdLCJhdGkiOiJjYWQ5MWUwMy05YTcyLTQxY2QtOWUxYi1kMmFmMjIwODE2ZGYiLCJleHAiOjE1OTg2MDEzMDEsImNvbmZpZyI6eyJhcmVhSWQiOiI0NDAwMDAiLCJsb2dpbk5hbWUiOiI0NDAwMDBfTlkiLCJwcm9mZXNzaW9ucyI6WyJOWSJdLCJhY3RpdmUiOiIxIiwidXNlckNhcHRpb24iOiLlub_kuJznnIEiLCJhZ2VuY3lJZCI6Ik5PREU0NDAwMDAiLCJjbGFzc05hbWUiOiJvcmcueW91aS5vcGVyYXRvci5lbnRpdHkuVXNlciJ9LCJhdXRob3JpdGllcyI6WyJOWV9ST0xFX1JFU1BPTkRFTlRfUFJPVklOQ0VfQURNSU4iXSwianRpIjoiMzA3MWU3NjAtNGRkMS00ZTcwLTk4YmMtYzk4ZDhlZDA3MjE5IiwiY2xpZW50X2lkIjoid2ViLXN0YXRzLWdnai1ueSJ9.6EzoNeZAK9DJTLhwLWlZB_OiXxCAhfPm0YmNWGetKQE","expires_in":86400,"scope":"auth_client","jti":"cad91e03-9a72-41cd-9e1b-d2af220816df"}
業務的服務接口獲取相關任務接口說明方法:GET目的:根據報告期和任務類型獲取相關的任務接口地址測試環境地址:39:8083/gatherServices/services/gatherTaskService/getGatherTasksByTree.json請求參數參數名稱參數值參數說明surveyTaskId5dc274d08293a717085a639b方案Id(surveyTaskId)taskType0任務類型(taskType)periodId20180000報告期(periodId)reportingSystemCodeweb-stats-ggj-data系統代碼頭信息Authorization:“Bearer”+tokenValuetokenValue:從1.2獲取TOKEN接口返回值中獲取的access_token返回值任務的相關信息,如任務的主鍵,任務的code,任務的名稱,任務所有相關的報表表號。postman實例method:GETurl:39:8083/gatherServices/services/gatherTaskService/getGatherTasksByTree.jsonparams={"surveyTaskId":"5dc274d08293a717085a639b",'taskType':"0", "periodId":"20180000"}headers={'Authorization':“eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX25hbWUiOiI0NDAwMDBfTlkiLCJzY29wZSI6WyJhdXRoX2NsaWVudCJdLCJleHAiOjE1OTYwOTU3MDEsImNvbmZpZyI6eyJhcmVhSWQiOiI0NDAwMDAiLCJsb2dpbk5hbWUiOiI0NDAwMDBfTlkiLCJwcm9mZXNzaW9ucyI6WyJOWSJdLCJhY3RpdmUiOiIxIiwidXNlckNhcHRpb24iOiLlub_kuJznnIEiLCJhZ2VuY3lJZCI6Ik5PREU0NDAwMDAiLCJjbGFzc05hbWUiOiJvcmcueW91aS5vcGVyYXRvci5lbnRpdHkuVXNlciJ9LCJhdXRob3JpdGllcyI6WyJOWV9ST0xFX1JFU1BPTkRFTlRfUFJPVklOQ0VfQURNSU4iXSwianRpIjoiY2FkOTFlMDMtOWE3Mi00MWNkLTllMWItZDJhZjIyMDgxNmRmIiwiY2xpZW50X2lkIjoid2ViLXN0YXRzLWdnai1ueSJ9.yq_5BSNrAovuCf0xbirKHceHSNiJEPvcxMGd-ahE1Qo”}返回值:{"record":{"taskId":"5f30dd759422896718ac3cec","taskCode":"T00101","taskCaption":"2018年公共機構能源資源消費方案年報","periodId":"20180000","periodType":"1","areaId":"000000","reportCodes":["NY101_2020","NY201_2020","NY202_2020","NY203_2020"],"taskType":"0","taskStatus":"20","assignStatus":"1","fillDeadline":1609344000000,"remindTime":1608912000000,"pubTime":1597037952450,"completeTime":null,"areaLevels":["nationalArea","provincialArea","municipalArea","countyArea"]},"message":null,"totalCount":0,"records":null,"instanceId":null,"trancode":"gatherTaskService.getGatherTasksByTree","trancaption":""}數據對接接口說明方法:POST目的:將對應的報表數據對接到采集系統注意事項:reportCode:特定的報表指定特定的數據格式,不然數據會導入失敗的接口地址測試環境地址:39:8083/workingServices/services/accessSystemTaskService/dockingSystemData.json請求參數參數名稱參數值參數類型參數說明accTaskId對應2.1獲取相關任務接口的返回值taskIdString任務IdaccTaskCode對應2.1獲取相關任務接口的返回值taskCodeString任務CodesurveyTaskId5dc274d08293a717085a639bString方案參數reportingSystemCodeweb-stats-ggj-dataString系統代碼reportCode報表Code(reportCode)String填報表單的表號accessDatas數據類型List<String>填報的數據,一條數據代表一家單位頭信息Authorization:“Bearer”+tokenValuetokenValue:從1.2獲取TOKEN接口返回值中獲取的access_token3.2.5返回值返回值html,html中對應的值可以查詢對接的結果3.2.6postman實例以《公共機構能源資源消費狀況》為例method:POSTurl:39:8083/workingServices/services/accessSystemTaskService/dockingSystemData.jsonparams={"accTaskId":"5f310c1ace4e0556a4df9a24",“accTaskCode”:"T00018","surveyTaskId":"5dc274d08293a717085a639b",“reportingSystemCode”:”web-stats-ggj-data”,“reportCode”:”NY201_2020”,"accessDatas[0]":"{"respondentId":"xxxxxxxxx","areaId":"xxxxxxxxx000000","rowDatas":[{"rowKey":"009","datas":["0"]},{"rowKey":"101","datas":["1"]},{"rowKey":"102","datas":["2"]},{"rowKey":"1021","datas":["3"]},{"rowKey":"103","datas":["4"]},{"rowKey":"1031","datas":["5"]},{"rowKey":"1032","datas":["6"]},{"rowKey":"1033","datas":["7"]},{"rowKey":"110","datas":["8"]},{"rowKey":"111","datas":["9"]},{"rowKey":"120","datas":["10"]},{"rowKey":"121","datas":["11"]},{"rowKey":"130","datas":["12"]},{"rowKey":"131","datas":["13"]},{"rowKey":"140","datas":["14"]},{"rowKey":"141","datas":["15"]},{"rowKey":"150","datas":["16"]},{"rowKey":"151","datas":["17"]},{"rowKey":"1501","datas":["18"]},{"rowKey":"1511","datas":["19"]},{"rowKey":"1502","datas":["20"]},{"rowKey":"1512","datas":["21"]},{"rowKey":"160","datas":["22"]},{"rowKey":"161","datas":["23"]},{"rowKey":"1601","datas":["24"]},{"rowKey":"1611","datas":["25"]},{"rowKey":"1602","datas":["26"]},{"rowKey":"1612","datas":["27"]},{"rowKey":"104","datas":["28"]},{"rowKey":"1041","datas":["29"]},{"rowKey":"170","datas":["30"]},{"rowKey":"171","datas":["31"]},{"rowKey":"180","datas":["32"]},{"rowKey":"181","datas":["33"]},{"rowKey":"105","datas":["34"]},{"rowKey":"ignore","datas":[]},{"rowKey":"190","datas":["36"]},{"rowKey":"191","datas":["37"]},{"rowKey":"192","datas":["38"]},{"rowKey":"401","datas":["39"]},{"rowKey":"402","datas":["40"]},{"rowKey":"403","datas":["41"]},{"rowKey":"404","datas":["42"]},{"rowKey":"405","datas":["43"]},{"rowKey":"406","datas":["44"]}],"respondentReportFootInfo":{"companyLeader":"張三","statsLeader":"張三","preparer":"張三","phoneNum":"12233334444","fixTelephone":"12233334444"}}"“accessDatas[1]”:”{"respondentId":"xxxxxxxxy","areaId":"xxxxxxxxy000000","rowDatas":[{"rowKey":"009","datas":["0"]},{"rowKey":"101","datas":["1"]},{"rowKey":"102","datas":["2"]},{"rowKey":"1021","datas":["3"]},{"rowKey":"103","datas":["4"]},{"rowKey":"1031","datas":["5"]},{"rowKey":"1032","datas":["6"]},{"rowKey":"1033","datas":["7"]},{"rowKey":"110","datas":["8"]},{"rowKey":"111","datas":["9"]},{"rowKey":"120","datas":["10"]},{"rowKey":"121","datas":["11"]},{"rowKey":"130","datas":["12"]},{"rowKey":"131","datas":["13"]},{"rowKey":"140","datas":["14"]},{"rowKey":"141","datas":["15"]},{"rowKey":"150","datas":["16"]},{"rowKey":"151","datas":["17"]},{"rowKey":"1501","datas":["18"]},{"rowKey":"1511","datas":["19"]},{"rowKey":"1502","datas":["20"]},{"rowKey":"1512","datas":["21"]},{"rowKey":"160","datas":["22"]},{"rowKey":"161","datas":["23"]},{"rowKey":"1601","datas":["24"]},{"rowKey":"1611","datas":["25"]},{"rowKey":"1602","datas":["26"]},{"rowKey":"1612","datas":["27"]},{"rowKey":"104","datas":["28"]},{"rowKey":"1041","datas":["29"]},{"rowKey":"170","datas":["30"]},{"rowKey":"171","datas":["31"]},{"rowKey":"180","datas":["32"]},{"rowKey":"181","datas":["33"]},{"rowKey":"105","datas":["34"]},{"rowKey":"ignore","datas":[]},{"rowKey":"190","datas":["36"]},{"rowKey":"191","datas":["37"]},{"rowKey":"192","datas":["38"]},{"rowKey":"401","datas":["39"]},{"rowKey":"402","datas":["40"]},{"rowKey":"403","datas":["41"]},{"rowKey":"404","datas":["42"]},{"rowKey":"405","datas":["43"]},{"rowKey":"406","datas":["44"]}],"respondentReportFootInfo":{"companyLeader":"張三","statsLeader":"張三","preparer":"張三","phoneNum":"12233334444","fixTelephone":"12233334444"}}”}headers={'Authorization':“eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX25hbWUiOiI0NDAwMDBfTlkiLCJzY29wZSI6WyJhdXRoX2NsaWVudCJdLCJleHAiOjE1OTYwOTU3MDEsImNvbmZpZyI6eyJhcmVhSWQiOiI0NDAwMDAiLCJsb2dpbk5hbWUiOiI0NDAwMDBfTlkiLCJwcm9mZXNzaW9ucyI6WyJOWSJdLCJhY3RpdmUiOiIxIiwidXNlckNhcHRpb24iOiLlub_kuJznnIEiLCJhZ2VuY3lJZCI6Ik5PREU0NDAwMDAiLCJjbGFzc05hbWUiOiJvcmcueW91aS5vcGVyYXRvci5lbnRpdHkuVXNlciJ9LCJhdXRob3JpdGllcyI6WyJOWV9ST0xFX1JFU1BPTkRFTlRfUFJPVklOQ0VfQURNSU4iXSwianRpIjoiY2FkOTFlMDMtOWE3Mi00MWNkLTllMWItZDJhZjIyMDgxNmRmIiwiY2xpZW50X2lkIjoid2ViLXN0YXRzLWdnai1ueSJ9.yq_5BSNrAovuCf0xbirKHceHSNiJEPvcxMGd-ahE1Qo”}返回值{
"record":
{
"html":
"5f3b8a11ce4e0573c0e7e2a6"
},
"message":
null,
"totalCount":
0,
"records":
null,
"instanceId":
null,
"trancode":
"accessSystemTaskService.dockingSystemData",
"trancaption":
""}數據對接的結果查詢接口說明方法:GET目的:對數據對接的結果進行查詢接口地址測試環境地址:39:8083/workingServices/services/accessSystemTaskManager/viewAccessSystemTaskLogList.json請求參數參數名稱參數值參數類型參數說明surveyTaskId5dc274d08293a717085a639bString方案參數reportingSystemCodeweb-stats-ggj-dataString系統代碼msgId5f3b8a11ce4e0573c0e7e2a6String可選項,值是對接數據的接口的返回值,如果不選擇,則是所有對接的結果頭信息Authorization:“Bearer”+tokenValuetokenValue:從1.2獲取TOKEN接口返回值中獲取的access_token返回值返回值是對接數據的成功條數和失敗條數的結果postman實例method:GETurl:39:8083/gatherServices/services/gatherTaskService/getGatherTasksByTree.jsonparams={“reportingSystemCode”:“web-stats-ggj-data”,“surveyTaskId”:”5dc274d08293a717085a639b”,“msgId:”5f3b8a11ce4e0573c0e7e2a6”}headers={'Authorization':“eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX25hbWUiOiI0NDAwMDBfTlkiLCJzY29wZSI6WyJhdXRoX2NsaWVudCJdLCJleHAiOjE1OTYwOTU3MDEsImNvbmZpZyI6eyJhcmVhSWQiOiI0NDAwMDAiLCJsb2dpbk5hbWUiOiI0NDAwMDBfTlkiLCJwcm9mZXNzaW9ucyI6WyJOWSJdLCJhY3RpdmUiOiIxIiwidXNlckNhcHRpb24iOiLlub_kuJznnIEiLCJhZ2VuY3lJZCI6Ik5PREU0NDAwMDAiLCJjbGFzc05hbWUiOiJvcmcueW91aS5vcGVyYXRvci5lbnRpdHkuVXNlciJ9LCJhdXRob3JpdGllcyI6WyJOWV9ST0xFX1JFU1BPTkRFTlRfUFJPVklOQ0VfQURNSU4iXSwianRpIjoiY2FkOTFlMDMtOWE3Mi00MWNkLTllMWItZDJhZjIyMDgxNmRmIiwiY2xpZW50X2lkIjoid2ViLXN0YXRzLWdnai1ueSJ9.yq_5BSNrAovuCf0xbirKHceHSNiJEPvcxMGd-ahE1Qo”}返回值:{
"record":
null,
"message":
null,
"totalCount":
0,
"records":
[
{
"accTaskId":
"5f310c1ace4e0556a4df9a24",
"accTaskCaption":
null,
"accTaskCode":
"T00018",
"surveyTaskId":
"5dc274d08293a717085a639b",
"periodId":
"20180000",
"reportingSystemCode":
"web-stats-ggj-data",
"reportCode":
"NY201_2020",
"dockingDeadline":
"2020-08-18
15:58:09",
"successMsg":
[
"{\"respondentId\":\"xxxxxxxxx\",\"areaId\":\"440000000000\",\"rowDatas\":[{\"rowKey\":\"009\",\"datas\":[\"0\"]},{\"rowKey\":\"101\",\"datas\":[\"1\"]},{\"rowKey\":\"102\",\"datas\":[\"2\"]},{\"rowKey\":\"1021\",\"datas\":[\"3\"]},{\"rowKey\":\"103\",\"datas\":[\"4\"]},{\"rowKey\":\"1031\",\"datas\":[\"5\"]},{\"rowKey\":\"1032\",\"datas\":[\"6\"]},{\"rowKey\":\"1033\",\"datas\":[\"7\"]},{\"rowKey\":\"110\",\"datas\":[\"8\"]},{\"rowKey\":\"111\",\"datas\":[\"9\"]},{\"rowKey\":\"120\",\"datas\":[\"10\"]},{\"rowKey\":\"121\",\"datas\":[\"11\"]},{\"rowKey\":\"130\",\"datas\":[\"12\"]},{\"rowKey\":\"131\",\"datas\":[\"13\"]},{\"rowKey\":\"140\",\"datas\":[\"14\"]},{\"rowKey\":\"141\",\"datas\":[\"15\"]},{\"rowKey\":\"150\",\"datas\":[\"16\"]},{\"rowKey\":\"151\",\"datas\":[\"17\"]},{\"rowKey\":\"1501\",\"datas\":[\"18\"]},{\"rowKey\":\"1511\",\"datas\":[\"19\"]},{\"rowKey\":\"1502\",\"datas\":[\"20\"]},{\"rowKey\":\"1512\",\"datas\":[\"21\"]},{\"rowKey\":\"160\",\"datas\":[\"22\"]},{\"rowKey\":\"161\",\"datas\":[\"23\"]},{\"rowKey\":\"1601\",\"datas\":[\"24\"]},{\"rowKey\":\"1611\",\"datas\":[\"25\"]},{\"rowKey\":\"1602\",\"datas\":[\"26\"]},{\"rowKey\":\"1612\",\"datas\":[\"27\"]},{\"rowKey\":\"104\",\"datas\":[\"28\"]},{\"rowKey\":\"1041\",\"datas\":[\"29\"]},{\"rowKey\":\"170\",\"datas\":[\"30\"]},{\"rowKey\":\"171\",\"datas\":[\"31\"]},{\"rowKey\":\"180\",\"datas\":[\"32\"]},{\"rowKey\":\"181\",\"datas\":[\"33\"]},{\"rowKey\":\"105\",\"datas\":[\"34\"]},{\"rowKey\":\"ignore\",\"datas\":[]},{\"rowKey\":\"190\",\"datas\":[\"36\"]},{\"rowKey\":\"191\",\"datas\":[\"37\"]},{\"rowKey\":\"192\",\"datas\":[\"38\"]},{\"rowKey\":\"401\",\"datas\":[\"39\"]},{\"rowKey\":\"402\",\"datas\":[\"40\"]},{\"rowKey\":\"403\",\"datas\":[\"41\"]},{\"rowKey\":\"404\",\"datas\":[\"42\"]},{\"rowKey\":\"405\",\"datas\":[\"43\"]},{\"rowKey\":\"406\",\"datas\":[\"44\"]}],\"respondentReportFootInfo\":{\"companyLeader\":\"張三\",\"statsLeader\":\"張三\",\"preparer\":\"張三\",\"phoneNum\":\"12233334444\",\"fixTelephone\":\"12233334444\"}}",
"{\"respondentId\":\"xxxxxxxxy\",\"areaId\":\"440000000000\",\"rowDatas\":[{\"rowKey\":\"009\",\"datas\":[\"0\"]},{\"rowKey\":\"101\",\"datas\":[\"1\"]},{\"rowKey\":\"102\",\"datas\":[\"2\"]},{\"rowKey\":\"1021\",\"datas\":[\"3\"]},{\"rowKey\":\"103\",\"datas\":[\"4\"]},{\"rowKey\":\"1031\",\"datas\":[\"5\"]},{\"rowKey\":\"1032\",\"datas\":[\"6\"]},{\"rowKey\":\"1033\",\"datas\":[\"7\"]},{\"rowKey\":\"110\",\"datas\":[\"8\"]},{\"rowKey\":\"111\",\"datas\":[\"9\"]},{\"rowKey\":\"120\",\"datas\":[\"10\"]},{\"rowKey\":\"121\",\"datas\":[\"11\"]},{\"rowKey\":\"130\",\"datas\":[\"12\"]},{\"rowKey\":\"131\",\"datas\":[\"13\"]},{\"rowKey\":\"140\",\"datas\":[\"14\"]},{\"rowKey\":\"141\",\"datas\":[\"15\"]},{\"rowKey\":\"150\",\"datas\":[\"16\"]},{\"rowKey\":\"151\",\"datas\":[\"17\"]},{\"rowKey\":\"1501\",\"datas\":[\"18\"]},{\"rowKey\":\"1511\",\"datas\":[\"19\"]},{\"rowKey\":\"1502\",\"datas\":[\"20\"]},{\"rowKey\":\"1512\",\"datas\":[\"21\"]},{\"rowKey\":\"160\",\"datas\":[\"22\"]},{\"rowKey\":\"161\",\"datas\":[\"23\"]},{\"rowKey\":\"1601\",\"datas\":[\"24\"]},{\"rowKey\":\"1611\",\"datas\":[\"25\"]},{\"rowKey\":\"1602\",\"datas\":[\"26\"]},{\"rowKey\":\"1612\",\"datas\":[\"27\"]},{\"rowKey\":\"104\",\"datas\":[\"28\"]},{\"rowKey\":\"1041\",\"datas\":[\"29\"]},{\"rowKey\":\"170\",\"datas\":[\"30\"]},{\"rowKey\":\"171\",\"datas\":[\"31\"]},{\"rowKey\":\"180\",\"datas\":[\"32\"]},{\"rowKey\":\"181\",\"datas\":[\"33\"]},{\"rowKey\":\"105\",\"datas\":[\"34\"]},{\"rowKey\":\"ignore\",\"datas\":[]},{\"rowKey\":\"190\",\"datas\":[\"36\"]},{\"rowKey\":\"191\",\"datas\":[\"37\"]},{\"rowKey\":\"192\",\"datas\":[\"38\"]},{\"rowKey\":\"401\",\"datas\":[\"39\"]},{\"rowKey\":\"402\",\"datas\":[\"40\"]},{\"rowKey\":\"403\",\"datas\":[\"41\"]},{\"rowKey\":\"404\",\"datas\":[\"42\"]},{\"rowKey\":\"405\",\"datas\":[\"43\"]},{\"rowKey\":\"406\",\"datas\":[\"44\"]}],\"respondentReportFootInfo\":{\"companyLeader\":\"張三\",\"statsLeader\":\"張三\",\"preparer\":\"張三\",\"phoneNum\":\"12233334444\",\"fixTelephone\":\"12233334444\"}}"
],
"errorMsg":
[]
}
],
"instanceId":
null,
"trancode":
"accessSystemTaskManager.viewAccessSystemTaskLogList",
"trancaption":
""}
附錄信息系統代碼每個對接的系統都會有個特定的系統代碼,系統代碼會在后面的授權和數據對接方面有很重要的作用,并且系統代碼會有特定的密碼。具體的系統代碼需要找采集平臺要。方案Id(surveyTaskId)固定值:5dc274d08293a717085a639b,整個對接的過程中,方案參數都是固定值任務類型(taskType)任務分成基層任務和綜合任務基層任務:0綜合任務:1報告期(periodId)報告期分為年報,半年報,季報,月報年報:xxxx0000xxxx指具體年份,如2020年,年報的標準就是20200000半年報:xxxxy000xxxx指具體年份y分為5和65代表上半年,6代表下半年,如20205000指2020年上半年報季報:xxxxy000xxxx指具體年份y分為1,2,3和4,分別代表第一季度,第二季度,第三季度,第四季度,如20201000指2020年第一季度報月報:xxxx0yy0xxxx指具體年份yy是從1到12,分別代表1到12月,1月20200010,12月20200120報表Code(reportCode)NY101_2020:公共基本信息表NY201_2020:公共機構能源資源消費狀況NY202_2020:公共機構數據中心機房能源消費狀況NY203_2020:公共機構采暖能源資源消費狀況NY304_2020:公共機構能源資源消費統計分級匯總情況NY301_2020:公共機構能源資源消費統計分類匯總情況NY302_2020:公共機構數據中心機房能源消費統計匯總情況NY303_2020:公共機構采暖能源資源消費統計匯總情況對接數據的時候,請根據任務選擇正確的報表表號數據類型(accessData)基層任務需要對接的表單,rowKey是固定值,不需要改動,texts和datas是數組,但是只需要在第一位填寫數據,datas中只能放在數字,不能放入其他類型的字符。機構類型機構類型代碼機構類型01國家機關02事業單位021教育事業022科技事業023文化事業024衛生事業025體育事業026其他03團體組織行業代碼參見附件能源報表和對應字段
公共基本信息表(NY101_2020){"respondentId":"xxxxxxxxx","areaId":"xxxxxx000000","rowDatas":[{"rowKey":"COL001","texts":["節能司"]},{"rowKey":"COL002","texts":["xxxxxxxxx"]},{"rowKey":"COL003","texts":["11100000000014306T"]},{"rowKey":"COL004","texts":["023"]},{"rowKey":"COL005","texts":["4412"]},{"rowKey":"COL006","texts":["北京市"]},{"rowKey":"COL007","texts":["北京市"]},{"rowKey":"COL008","texts":["西城區"]},{"rowKey":"COL009","texts":[""]},{"rowKey":"COL010","texts":["西安門大街"]},{"rowKey":"COL011","texts":["22號"]},{"rowKey":"COL012","texts":["110000000000"]},{"rowKey":"COL013","texts":[]},{"rowKey":"COL014","texts":["張三"]},{"rowKey":"COL015","texts":["yyyyyyyyy"]}],"respondentReportFootInfo":{"companyLeader":"張三","statsLeader":"張三","preparer":"張三","phoneNum":"12233334444","fixTelephone":"12233334444"}}字段對照:字段標識字段解釋respondentId組織機構代碼areaId當前機構所在地的管理機構的行政區劃代碼+000000rowDatas具體的數據rowKey表單填報項的表示COL001單位詳細名稱COL002組織機構代碼COL003統一社會信用代碼COL004機構類型COL005行業代碼COL006省(自治區、直轄市)COL007地(區、市、州)COL008縣(市、區、旗)COL009鄉(鎮)COL010街(村)COL011門牌號COL012單位所在地區劃代碼COL013聯系電話COL014其他COL015 父節點(上級單位的組織機構代碼)texts具體數據放置的位置,因為是數組,所以數據放置在第一位respondentReportFootInfo表腳信息(map結構)companyLeader單位負責人statsLeader統計負責人preparer填表人phoneNum聯系電話submitDate填報日期機構類型和行業代碼請參考附錄
公共機構能源資源消費狀況(NY201_2020){"respondentId":"xxxxxxxxx","areaId":"xxxxxx000000","rowDatas":[{"rowKey":"009","datas":["0"]},{"rowKey":"101","datas":["1"]},{"rowKey":"102","datas":["2"]},{"rowKey":"1021","datas":["3"]},{"rowKey":"103","datas":["4"]},{"rowKey":"1031","datas":["5"]},{"rowKey":"1032","datas":["6"]},{"rowKey":"1033","datas":["7"]},{"rowKey":"110","datas":["8"]},{"rowKey":"111","datas":["9"]},{"rowKey":"120","datas":["10"]},{"rowKey":"121","datas":["11"]},{"rowKey":"130","datas":["12"]},{"rowKey":"131","datas":["13"]},{"rowKey":"140","datas":["14"]},{"rowKey":"141","datas":["15"]},{"rowKey":"150","datas":["16"]},{"rowKey":"151","datas":["17"]},{"rowKey":"1501","datas":["18"]},{"rowKey":"1511","datas":["19"]},{"rowKey":"1502","datas":["20"]},{"rowKey":"1512","datas":["21"]},{"rowKey":"160","datas":["22"]},{"rowKey":"161","datas":["23"]},{"rowKey":"1601","datas":["24"]},{"rowKey":"1611","datas":["25"]},{"rowKey":"1602","datas":["26"]},{"rowKey":"1612","datas":["27"]},{"rowKey":"104","datas":["28"]},{"rowKey":"1041","datas":["29"]},{"rowKey":"170","datas":["30"]},{"rowKey":"171","datas":["31"]},{"rowKey":"180","datas":["32"]},{"rowKey":"181","datas":["33"]},{"rowKey":"105","datas":["34"]},{"rowKey":"ignore","datas":[]},{"rowKey":"190","datas":["36"]},{"rowKey":"191","datas":["37"]},{"rowKey":"192","datas":["38"]},{"rowKey":"401","datas":["39"]},{"rowKey":"402","datas":["40"]},{"rowKey":"403","datas":["41"]},{"rowKey":"404","datas":["42"]},{"rowKey":"405","datas":["43"]},{"rowKey":"406","datas":["44"]}],"respondentReportFootInfo":{"companyLeader":"張三","statsLeader":"張三","preparer":"張三","phoneNum":"12233334444","fixTelephone":"12233334444"}}參照公共基本信息表的字段映射rowKey字段對照字段標識字段解釋009用地面積101建筑面積102用能人數1021編制人數103車輛數量1031汽油車數量1032柴油車數量1033新能源汽車數量110電消費量111電消費量/費用120水消費量121水消費量/費用130煤炭消費量131煤炭消費量/費用140天然氣消費量141天然氣消費量/費用150汽油消費量151汽油消費量/費用1501汽油消費量/車輛用油量1511汽油消費量/車輛用油量/費用1502汽油消費量/其他用油量1512汽油消費量/其他用油量/費用160柴油消費量161柴油消費量/費用1601柴油消費量/車輛用油量1611柴油消費量/車輛用油量/費用1602柴油消費量/其他用油量1612柴油消費量/其他用油量/費用104液化石油氣消費量1041液化石油氣消費量/費用170熱力消費量171熱力消費量/費用180其他能源消費量181其他能源消費量/費用105充電樁數量ignore可再生能源應用(不需要添加數據)190其中:太陽能光熱利用系統集熱器面積191太陽能光電利用系統裝機容量192地熱能利用系統裝機容量401人均用電量402人均用水量403單位面積用電量404綜合能耗405人均綜合能耗406單位建筑面積能耗
公共機構數據中心機房能源消費狀況(NY202_2020){"respondentId":"xxxxxxxxx","areaId":"xxxxxx000000","subReportCode":"NY202_2020_xxxxxxxxx_yyyyyy","rowDatas":[{"rowKey":"201","datas":["0"]},{"rowKey":"210","datas":["1"]},{"rowKey":"220","datas":["2"]},{"rowKey":"2201","datas":["3"]},{"rowKey":"2202","datas":["4"]},{"rowKey":"2203","datas":["5"]},{"rowKey":"230","datas":["6"]},{"rowKey":"240","datas":["7"]},{"rowKey":"2401","datas":["8"]},{"rowKey":"2402","datas":["9"]},{"rowKey":"2403","datas":["10"]},{"rowKey":"250","datas":["11"]}],"respondentReportFootInfo":{"companyLeader":"張三","statsLeader":"張三","preparer":"張三","phoneNum":"12233334444","fixTelephone":"12233334444"}}參照公共基本信息表的字段映射字段標識字段解釋subReportCodeNY202_2020_xxxxxxxxx_yyyyyyNY202_2020固定值xxxxxxxxx組織機構代碼yyyyy機房的code值,不能重復,code值確認只能使用英文字母和數字201機房建筑面積210機柜總數量220設備總功率2201其中:IT設備功率2202空氣調節設備功率2203配電及附屬設備功率230UPS裝機容量240總用電量2401其中:IT設備用電量2402空氣調節設備用電量2403配電及附屬設備用電量250其他能源消費量()
公共機構采暖能源資源消費狀況(NY203_2020){"respondentId":"xxxxxxxxx","areaId":"xxxxxx000000","rowDatas":[{"rowKey":"301","datas":["1"]},{"rowKey":"3011","datas":["2"]},{"rowKey":"3012","datas":["3"]},{"rowKey":"3013","datas":["4"]},{"rowKey":"302","datas":["5"]},{"rowKey":"ignore","datas":[]},{"rowKey":"303","datas":["6"]},{"rowKey":"304","datas":["7"]},{"rowKey":"310","datas":["8"]},{"rowKey":"311","datas":["9"]},{"rowKey":"320","datas":["10"]},{"rowKey":"321","datas":["11"]},{"rowKey":"330","datas":["12"]},{"rowKey":"331","datas":["13"]},{"rowKey":"340","datas":["14"]},{"rowKey":"341","datas":["15"]},{"rowKey":"350","datas":["16"]},{"rowKey":"351","datas":["17"]},{"rowKey":"380","datas":["18"]},{"rowKey":"360","datas":["19"]},{"rowKey":"361","datas":["20"]},{"rowKey":"370","datas":["21"]},{"rowKey":"371","datas":["22"]}],"respondentReportFootInfo":{"companyLeader":"張三","statsLeader":"張三","preparer":"張三","phoneNum":"12233334444","fixTelephone":"12233334444"}}參照公共基本信息表的字段映射字段標識字段解釋301采暖面積3011其中:獨立供暖面積3012集中供暖面積(按面積收費)3013集中供暖面積(按熱量收費)302采暖天數ignore獨立供暖供熱能力(不需要填寫數據)303熱水鍋爐熱功率304蒸汽鍋爐蒸發量310水消費量311水消費量/費用320電消費量321電消費量/費用330煤炭消費量331煤炭消費量/費用340天然氣消費量341天然氣消費量/費用350柴油消費量351柴油消費量/費用380集中供暖費用(按面積收費)360熱力消費量361熱力消費量/費用370其他能源消費量()371其他能源消費量()/費用
綜合表的數據格式和綜合表稍有不同公共機構能源資源消費統計分級匯總情況(NY304_2020){"respondentId":"xxxxxxxxx","areaId":"xxxxxx000000","rowDatas":[{"rowKey":"yyyyyy","catalogId":"agencyGroup","catalogInfos":["mmmmm","nnnnnn"],"datas":["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40"]},{"rowKey":"yyyyyyq","catalogId":"agencyGroup","catalogInfos":["ssssss","qqqqqq"],"datas":["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39"]}],"respondentReportFootInfo":{"companyLeader":"張三","statsLeader":"張三","preparer":"張三","phoneNum":"12233334444","fixTelephone":"12233334444"}}參照公共基本信息表的字段映射字段名稱字段解釋respondentId組織機構代碼areaId組織機構代碼+“000000”catalogId固定值,agencyGroupcatalogInfos數組格式,第一位為單位名稱,第二位為代碼rowKey分級匯總表是多行數據,每一行數據一個特定的key值,不能重復,key為英文和數字datas數據格式,每一位都代表一個指標datas[0]公共機構數量datas[1]用地面積datas[2]建筑面積datas[3]用能人數datas[4]編制人數datas[5]車輛總量datas[6]車輛總量/汽油車數量datas[7]車輛總量/柴油車數量datas[8]車輛總量/新能源汽車數量datas[9]電/消費量datas[10]電/費用datas[11]水/消費量datas[12]水/費用datas[13]煤炭/消費量datas[14]煤炭/費用datas[15]天然氣/消費量datas[16]天然氣/費用datas[17]汽油/消費總量datas[18]汽油/總費用datas[19]汽油/車輛用油量datas[20]汽油/車輛用油量/費用datas[21]汽油/其他用油量datas[22]汽油/其他用油量費用datas[23]柴油/消費總量datas[24]柴油/總費用datas[25]柴油/車輛用油量datas[26]柴油/車輛用油量/費用datas[27]柴油/其他用油量datas[28]柴油/其他用油量/費用datas[29]液化石油氣/消費量datas[30]液化石油氣/費用datas[31]熱力/消費量datas[32]熱力/費用datas[33]其他能源/消費量datas[34]其他能源/費用datas[35]充電樁數量datas[36]可再生能源應用/太陽能集熱器面積datas[37]可再生能源應用/太陽能光電裝機容量datas[38]可再生能源應用/地熱利用裝機容量
公共機構能源資源消費統計分類匯總情況(NY301_2020){"respondentId":"xxxxxxxxx","areaId":"xxxxxxxxx000000","rowDatas":[{"datas":[1,0,1,0,0,1,0,0,0,0]},{"datas":[0,0,0,0,0,0,0,0,0,0]},{"datas":[0.0001,0,0.0001,0,0,0.0001,0,0,0,0]},{"datas":[2,0,2,0,0,2,0,0,0,0]},{"datas":[3,0,3,0,0,3,0,0,0,0]},{"datas":[4,0,4,0,0,4,0,0,0,0]},{"datas":[5,0,5,0,0,5,0,0,0,0]},{"datas":[6,0,6,0,0,6,0,0,0,0]},{"datas":[7,0,7,0,0,7,0,0,0,0]},{"datas":[0.0008,0,0.0008,0,0,0.0008,0,0,0,0]},{"datas":[0.0009,0,0.0009,0,0,0.0009,0,0,0,0],"oneDimensionalIndicator":false},{"datas":[0.001,0,0.001,0,0,0.001,0,0,0,0]},{"datas":[0.0011,0,0.0011,0,0,0.0011,0,0,0,0]},{"datas":[12,0,12,0,0,12,0,0,0,0]},{"datas":[0.0013,0,0.0013,0,0,0.0013,0,0,0,0]},{"datas":[0.0014,0,0.0014,0,0,0.0014,0,0,0,0]},{"datas":[0.0015,0,0.0015,0,0,0.0015,0,0,0,0]},{"datas":[0.0016,0,0.0016,0,0,0.0016,0,0,0,0]},{"datas":[0.0017,0,0.0017,0,0,0.0017,0,0,0,0]},{"datas":[0.0018,0,0.0018,0,0,0.0018,0,0,0,0]},{"datas":[0.0019,0,0.0019,0,0,0.0019,0,0,0,0]},{"datas":[0.002,0,0.002,0,0,0.002,0,0,0,0]},{"datas":[0.0021,0,0.0021,0,0,0.0021,0,0,0,0]},{"datas":[0.0022,0,0.0022,0,0,0.0022,0,0,0,0]},{"datas":[0.0023,0,0.0023,0,0,0.0023,0,0,0,0]},{"datas":[0.0024,0,0.0024,0,0,0.0024,0,0,0,0]},{"datas":[0.0025,0,0.0025,0,0,0.0025,0,0,0,0]},{"datas":[0.0026,0,0.0026,0,0,0.0026,0,0,0,0]},{"datas":[0.0027,0,0.0027,0,0,0.0027,0,0,0,0]},{"datas":[0.028,0,0.028,0,0,0.028,0,0,0,0]},{"datas":[0.0029,0,0.0029,0,0,0.0029,0,0,0,0]},{"datas":[0.003,0,0.003,0,0,0.003,0,0,0,0]},{"datas":[0.0031,0,0.0031,0,0,0.0031,0,0,0,0]},{"datas":[32,0,32,0,0,32,0,0,0,0]},{"datas":[0.0033,0,0.0033,0,0,0.0033,0,0,0,0]},{"datas":[34,0,34,0,0,34,0,0,0,0]},{"datas":[]},{"datas":[36,0,36,0,0,36,0,0,0,0]},{"datas":[37,0,37,0,0,37,0,0,0,0]},{"datas":[38,0,38,0,0,38,0,0,0,0]}],"respondentReportFootInfo":{"companyLeader":"張三","statsLeader":"張三","preparer":"張三","phoneNum":"12233334444","fixTelephone":"12233334444"}}參照公共基本信息表的字段映射字段名稱字段解釋respondentId組織機構代碼areaId組織機構代碼+“000000”rowDatas[0]公共機構數量rowDatas[1]用地面積rowDatas[2]建筑面
溫馨提示
- 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯系上傳者。文件的所有權益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網頁內容里面會有圖紙預覽,若沒有圖紙預覽就沒有圖紙。
- 4. 未經權益所有人同意不得將文件中的內容挪作商業或盈利用途。
- 5. 人人文庫網僅提供信息存儲空間,僅對用戶上傳內容的表現方式做保護處理,對用戶上傳分享的文檔內容本身不做任何修改或編輯,并不能對任何下載內容負責。
- 6. 下載文件中如有侵權或不適當內容,請與我們聯系,我們立即糾正。
- 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。
評論
0/150
提交評論