{"info":{"_postman_id":"912f1fa8-3682-4223-a17f-7fea62f004e0","name":"iot-big-data","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"description":"<html><head></head><body></body></html>","owner":"5239352","collectionId":"912f1fa8-3682-4223-a17f-7fea62f004e0","publishedId":"RWaLvnj7","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2018-09-18T08:21:23.000Z"},"item":[{"name":"analysis","item":[{"name":"recent-device","id":"d4dbf69c-a67a-4b7e-8b1f-7e891a7e0a98","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/analysis/recent-device?tenantId=2&days=3","description":"<p>获取最近的设备信息, 结果示例如下:\n{\n    \"dataCount\": {\n        \"CH4(PPM)\": 4531,\n        \"dampness(%RH)\": 4539,\n        \"deformation\": 86789120,\n        \"humidity\": 76260590,\n        \"light\": 65284926,\n        \"pressure\": 37271572,\n        \"temperature\": 84220437,\n        \"temperature(?)\": 4539,\n        \"velocity\": 46262519\n    },\n    \"deviceCount\": {\n        \"CH4(PPM)\": 1,\n        \"dampness(%RH)\": 1,\n        \"deformation\": 95501,\n        \"humidity\": 94733,\n        \"light\": 98349,\n        \"pressure\": 86092,\n        \"temperature\": 99543,\n        \"temperature(?)\": 1,\n        \"velocity\": 73776\n    },\n    \"usualDataCount\": {\n        \"CH4(PPM)\": 4518,\n        \"dampness(%RH)\": 4539,\n        \"deformation\": 108148370,\n        \"humidity\": 97201737,\n        \"light\": 59584297,\n        \"pressure\": 58205905,\n        \"temperature\": 78791040,\n        \"temperature(?)\": 4539,\n        \"velocity\": 40563284\n    },\n    \"usualDataRate\": {\n        \"CH4(PPM)\": 0.9971308761862723460604723019,\n        \"dampness(%RH)\": 1,\n        \"deformation\": 1.246105156959766385463984426,\n        \"humidity\": 1.274599855574156979378208325,\n        \"light\": 0.9126807771827756992479397158,\n        \"pressure\": 1.561670245623125313845093521,\n        \"temperature\": 0.9355334976473703170169967178,\n        \"temperature(?)\": 1,\n        \"velocity\": 0.8768066434082415615976293898\n    }\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","analysis","recent-device"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>int 类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"2"},{"description":{"content":"<p>int 类型 最近多少天</p>\n","type":"text/plain"},"key":"days","value":"3"}],"variable":[]}},"response":[],"_postman_id":"d4dbf69c-a67a-4b7e-8b1f-7e891a7e0a98"},{"name":"recent-data","id":"8f2d2933-b6b8-4831-aa9a-e937450390a6","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/analysis/recent-data?tenantId=2&days=7","description":"<p>获取最近缓存的的数据, 结果示例如下:\n{\n    \"dataCount\": {\n        \"2018-06-29\": {\n            \"deformation\": 219,\n            \"humidity\": 220,\n            \"light\": 506,\n            \"pressure\": 184,\n            \"temperature\": 386,\n            \"velocity\": 802\n        },\n        \"2018-06-30\": {\n            \"deformation\": 790,\n            \"humidity\": 522,\n            \"light\": 83,\n            \"pressure\": 600,\n            \"temperature\": 859,\n            \"velocity\": 778\n        }\n    },\n    \"maxValue\": {\n        \"2018-06-29\": {\n            \"deformation\": 78.381112,\n            \"humidity\": 97.456826,\n            \"light\": 5.78391,\n            \"pressure\": 9.941406,\n            \"temperature\": 12.026623,\n            \"velocity\": 15.276296\n        },\n        \"2018-06-30\": {\n            \"deformation\": 34.82839,\n            \"humidity\": 96.361288,\n            \"light\": 5.120351,\n            \"pressure\": 6.111164,\n            \"temperature\": 5.524247,\n            \"velocity\": 35.804276\n        }\n    },\n    \"meanValue\": {\n        \"2018-06-29\": {\n            \"deformation\": 1.403396,\n            \"humidity\": 51.39486,\n            \"light\": 89.923052,\n            \"pressure\": 20.489162,\n            \"temperature\": 83.511109,\n            \"velocity\": 27.878094\n        },\n        \"2018-06-30\": {\n            \"deformation\": 95.216017,\n            \"humidity\": 33.059754,\n            \"light\": 54.509456,\n            \"pressure\": 31.095741,\n            \"temperature\": 86.486457,\n            \"velocity\": 93.543554\n        }\n    },\n    \"minValue\": {\n        \"2018-06-29\": {\n            \"deformation\": 21.491983,\n            \"humidity\": 29.441941,\n            \"light\": 32.87411,\n            \"pressure\": 8.60502,\n            \"temperature\": 54.391984,\n            \"velocity\": 16.183121\n        },\n        \"2018-06-30\": {\n            \"deformation\": 62.263719,\n            \"humidity\": 17.058905,\n            \"light\": 72.118294,\n            \"pressure\": 65.803719,\n            \"temperature\": 2.13505,\n            \"velocity\": 34.505765\n        }\n    },\n    \"stddevValue\": {\n        \"2018-06-29\": {\n            \"deformation\": 60.451306,\n            \"humidity\": 10.934592,\n            \"light\": 34.530417,\n            \"pressure\": 25.871549,\n            \"temperature\": 35.056091,\n            \"velocity\": 7.419157\n        },\n        \"2018-06-30\": {\n            \"deformation\": 41.452496,\n            \"humidity\": 83.21419,\n            \"light\": 70.195128,\n            \"pressure\": 63.267049,\n            \"temperature\": 46.483335,\n            \"velocity\": 76.002216\n        }\n    }\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","analysis","recent-data"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>int 类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"2"},{"description":{"content":"<p>int 类型 最近多少天</p>\n","type":"text/plain"},"key":"days","value":"7"}],"variable":[]}},"response":[],"_postman_id":"8f2d2933-b6b8-4831-aa9a-e937450390a6"},{"name":"data","id":"8fe6bb0f-2be8-4cfa-a2b3-6474904cfe72","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/analysis/data?tenantId=2&deviceType=velocity&startTime=1524258000000&endTime=1527643200000&partNum=3&deviceId=-1","description":"<p>获取指定时间的数据分析结果, 结果示例如下:\n{\n    \"data\": [\n        {\n            \"1524258000000\": 96.93867635170776,\n            \"1525386400000\": 100.58765374639222,\n            \"1526514800000\": 93.73837542674471\n        },\n        {\n            \"1524258000000\": 5.625151773077484,\n            \"1525386400000\": 8.103915613900234,\n            \"1526514800000\": 8.006349325947959\n        },\n        {\n            \"1524258000000\": 50.25411900709191,\n            \"1525386400000\": 49.97621095959662,\n            \"1526514800000\": 50.34329860719137\n        },\n        {\n            \"1524258000000\": 16.110347503336623,\n            \"1525386400000\": 15.266939112471773,\n            \"1526514800000\": 15.863417623356957\n        },\n        {\n            \"1524258000000\": 579,\n            \"1525386400000\": 565,\n            \"1526514800000\": 501\n        },\n        {\n            \"1524258000000\": 579,\n            \"1525386400000\": 564,\n            \"1526514800000\": 501\n        },\n        {\n            \"1524258000000\": 1,\n            \"1525386400000\": 0.9982300884955753,\n            \"1526514800000\": 1\n        }\n    ],\n    \"status\": \"success\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","analysis","data"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>int类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"2"},{"description":{"content":"<p>设备类型, 与设备id选一个</p>\n","type":"text/plain"},"key":"deviceType","value":"velocity"},{"description":{"content":"<p>开始时间13位时间戳</p>\n","type":"text/plain"},"key":"startTime","value":"1524258000000"},{"description":{"content":"<p>结束时间13位时间戳</p>\n","type":"text/plain"},"key":"endTime","value":"1527643200000"},{"description":{"content":"<p>分段数, 把起止时间内的数据分为几段</p>\n","type":"text/plain"},"key":"partNum","value":"3"},{"description":{"content":"<p>设备id, 与设备类型选一个</p>\n","type":"text/plain"},"key":"deviceId","value":"-1"}],"variable":[]}},"response":[],"_postman_id":"8fe6bb0f-2be8-4cfa-a2b3-6474904cfe72"},{"name":"device","id":"cc640636-5447-4ada-91e7-a4818859783f","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/analysis/device?tenantId=2&startTime=1524258000000&endTime=1527643200000","description":"<p>获取指定时间设备分析结果, 结果示例如下:\n{\n    \"data\": {\n        \"dataCount\": {\n            \"deformation\": 1605,\n            \"humidity\": 4295,\n            \"light\": 1637,\n            \"pressure\": 1635,\n            \"telemetry\": 26755,\n            \"temperature\": 9292,\n            \"velocity\": 1645\n        },\n        \"deviceCount\": {\n            \"deformation\": 10,\n            \"humidity\": 12,\n            \"light\": 10,\n            \"pressure\": 10,\n            \"telemetry\": 20,\n            \"temperature\": 15,\n            \"velocity\": 10\n        },\n        \"usualDataCount\": {\n            \"deformation\": 1602,\n            \"humidity\": 4293,\n            \"light\": 1636,\n            \"pressure\": 1631,\n            \"telemetry\": 26647,\n            \"temperature\": 9286,\n            \"velocity\": 1644\n        },\n        \"usualDataRate\": {\n            \"deformation\": 0.9981308411214953,\n            \"humidity\": 0.9995343422584401,\n            \"light\": 0.9993891264508247,\n            \"pressure\": 0.9975535168195718,\n            \"telemetry\": 0.9959633713324613,\n            \"temperature\": 0.9993542832544124,\n            \"velocity\": 0.9993920972644377\n        }\n    },\n    \"status\": \"success\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","analysis","device"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>int类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"2"},{"description":{"content":"<p>开始时间13位时间戳</p>\n","type":"text/plain"},"key":"startTime","value":"1524258000000"},{"description":{"content":"<p>结束时间13位时间戳</p>\n","type":"text/plain"},"key":"endTime","value":"1527643200000"}],"variable":[]}},"response":[],"_postman_id":"cc640636-5447-4ada-91e7-a4818859783f"}],"id":"b4ca5ba8-337f-41d2-bfe0-cc2191a2a203","description":"<p>数据分析接口\n1.近期数据分析\n2.近期设备分析\n3.指定时间数据分析\n4.指定时间设备分析</p>\n","event":[{"listen":"prerequest","script":{"id":"1fabbfc1-0222-469a-a7fb-dc3d556142fd","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"b4bbc1bf-6d83-4509-8797-772e6264f471","type":"text/javascript","exec":[""]}}],"_postman_id":"b4ca5ba8-337f-41d2-bfe0-cc2191a2a203"},{"name":"device","item":[{"name":"device-types","id":"2e66d5af-1d89-4e36-8022-4911aefa903e","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/device/device-types?tenantId=2","description":"<p>获取所有设备类型接口,结果示例如下:\n{\n    \"deviceTypes\": [\n        \"humidity\",\n        \"temperature\",\n        \"pressure\",\n        \"light\",\n        \"velocity\",\n        \"deformation\"\n    ]\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","device","device-types"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>int类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"2"}],"variable":[]}},"response":[],"_postman_id":"2e66d5af-1d89-4e36-8022-4911aefa903e"}],"id":"03ed86d3-fba0-4f1f-be39-388552608cb0","description":"<p>获取设备信息接口\n1.获取所有设备类型</p>\n","event":[{"listen":"prerequest","script":{"id":"286e0610-9261-4cd8-b9c6-03c4ddaee114","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"0f8c2726-fad3-48ab-9ef8-35b575359572","type":"text/javascript","exec":[""]}}],"_postman_id":"03ed86d3-fba0-4f1f-be39-388552608cb0"},{"name":"model","item":[{"name":"get-general-model","id":"b6d89536-758c-46dc-9487-ea5cb103a537","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/model/get-general-model","description":"<p>获取通用模型, 结果示例如下:\n{\n    \"data\": [\n        {\n            \"model_desc\": \"test_desc\",\n            \"model_id\": 1,\n            \"model_input\": [\n                \"tem\",\n                \"hum\"\n            ],\n            \"model_name\": \"test_name\",\n            \"model_path\": 2\n        },\n        {\n            \"model_desc\": \"this is a test model!\",\n            \"model_id\": 2,\n            \"model_input\": [\n                \"pressure\",\n                \"velocity\"\n            ],\n            \"model_name\": \"hello world\",\n            \"model_path\": 2\n        }\n    ]\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","model","get-general-model"],"host":["39","104","186","210"],"query":[],"variable":[]}},"response":[],"_postman_id":"b6d89536-758c-46dc-9487-ea5cb103a537"},{"name":"get-tenant-model","id":"d3625491-32c9-46b9-9c33-c4a7e804126d","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/model/get-tenant-model?tenantId=1","description":"<p>获取用户模型, 结果示例如下:\n{\n    \"data\": [\n        {\n            \"model_desc\": \"this is a test tenant model!\",\n            \"model_id\": 4,\n            \"model_input\": [\n                \"pressure\",\n                \"velocity\"\n            ],\n            \"model_name\": \"hello tenant\",\n            \"model_path\": 2\n        },\n        {\n            \"model_desc\": \"Features consist of  Temperature (T), Ambient Pressure (AP), Relative Humidity (RH) and Exhaust Vacuum (V) to predict the   electrical energy output (EP)  of the plant.\",\n            \"model_id\": 1537191320,\n            \"model_input\": [\n                \"AT\",\n                \"V\",\n                \"AP\",\n                \"RH\"\n            ],\n            \"model_name\": \"electrical energy output predict\",\n            \"model_path\": 1\n        }\n    ]\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","model","get-tenant-model"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>int 类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"1"}],"variable":[]}},"response":[],"_postman_id":"d3625491-32c9-46b9-9c33-c4a7e804126d"},{"name":"create-model","id":"2c87586c-8e3a-4587-9ba9-442ddb2e90d5","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/model/create-model?tenantId=1&input=[\"AT\",\"V\",\"AP\",\"RH\"]&modelName=electrical energy output predict&modelDesc=Features consist of  Temperature (T), Ambient Pressure (AP), Relative Humidity (RH) and Exhaust Vacuum (V) to predict the   electrical energy output (EP)  of the plant.","description":"<p>创建模型接口, 返回结果如下:\n{\n    \"model id\": 1537247116,\n    \"status\": \"create model success, next you need train model!\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","model","create-model"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>int类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"1"},{"description":{"content":"<p>模型的输入, 以JsonArray的形式给出, 表示输入类型, 与物接入中的设备上传数据的key对应. </p>\n","type":"text/plain"},"key":"input","value":"[\"AT\",\"V\",\"AP\",\"RH\"]"},{"description":{"content":"<p>模型名字, 默认为model_id(随机生成). 文本类型.</p>\n","type":"text/plain"},"key":"modelName","value":"electrical energy output predict"},{"description":{"content":"<p>模型描述, 默认为model_id(随机生成). 文本类型.</p>\n","type":"text/plain"},"key":"modelDesc","value":"Features consist of  Temperature (T), Ambient Pressure (AP), Relative Humidity (RH) and Exhaust Vacuum (V) to predict the   electrical energy output (EP)  of the plant."}],"variable":[]}},"response":[],"_postman_id":"2c87586c-8e3a-4587-9ba9-442ddb2e90d5"},{"name":"delete-model","id":"55fdbb0a-fca0-4525-80a5-d9ac7c643f94","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/model/delete-model?modelId=1537191320","description":"<p>删除模型接口, 返回结果如下:\n{\n    \"model id\": 1537247116,\n    \"status\": \"delete model success!\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","model","delete-model"],"host":["39","104","186","210"],"query":[{"disabled":true,"description":{"content":"<p>int类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"1"},{"description":{"content":"<p>模型id</p>\n","type":"text/plain"},"key":"modelId","value":"1537191320"}],"variable":[]}},"response":[],"_postman_id":"55fdbb0a-fca0-4525-80a5-d9ac7c643f94"},{"name":"train-model","id":"5821ea82-cc94-45e3-946f-25171385427e","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/model/train-model?modelId=1537633598&sourceTable=power_out&featureColumns=[\"AT\",\"V\",\"AP\",\"RH\"]&targetColumns=[\"PE\"]&modelType=reg&host=172.24.32.169&user=root&passwd=root&dbname=BUPT_IOT&port=3306","description":"<p>训练模型, 返回结果如下:\n{\n    \"model id\": 1537249793,\n    \"status\": \"train model success!\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","model","train-model"],"host":["39","104","186","210"],"query":[{"disabled":true,"description":{"content":"<p>int类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"1"},{"description":{"content":"<p>模型id</p>\n","type":"text/plain"},"key":"modelId","value":"1537633598"},{"description":{"content":"<p>训练模型所需要的数据表名</p>\n","type":"text/plain"},"key":"sourceTable","value":"power_out"},{"description":{"content":"<p>模型的输入对应的数据表字段, JsonArray格式, 需要与模型输入对应.</p>\n","type":"text/plain"},"key":"featureColumns","value":"[\"AT\",\"V\",\"AP\",\"RH\"]"},{"description":{"content":"<p>模型的输出对应的数据表字段, JsonArray格式.</p>\n","type":"text/plain"},"key":"targetColumns","value":"[\"PE\"]"},{"description":{"content":"<p>模型的类型, 目前支持(1).\"cla\":分类, (2).\"reg\":回归. 其中分类模型的输出只有一个字段. 但是支持多分类, 概率预测模型可以使用分类模型实现.</p>\n","type":"text/plain"},"key":"modelType","value":"reg"},{"description":{"content":"<p>可选, 数据库服务器地址, 需要与user,passwd,dbname一起使用. </p>\n","type":"text/plain"},"key":"host","value":"172.24.32.169"},{"description":{"content":"<p>可选, 数据库服务器登录名, 需要与host,passwd,dbname一起使用.</p>\n","type":"text/plain"},"key":"user","value":"root"},{"description":{"content":"<p>可选, 数据库服务器登录密码, 需要与后三天,user,dbname一起使用.</p>\n","type":"text/plain"},"key":"passwd","value":"root"},{"description":{"content":"<p>可选, 数据库服务器数据库名, 需要与user,passwd,host一起使用.</p>\n","type":"text/plain"},"key":"dbname","value":"BUPT_IOT"},{"description":{"content":"<p>可选, 数据库服务器端口号, 需要与host,user,passwd, dbname一起使用.</p>\n","type":"text/plain"},"key":"port","value":"3306"}],"variable":[]}},"response":[],"_postman_id":"5821ea82-cc94-45e3-946f-25171385427e"},{"name":"get-model-id","id":"74ce0692-a78b-4dcc-8b7f-13dd8da8c00b","request":{"method":"GET","header":[],"url":"http://39.104.186.210:8092/api/model/get-model-id?tenantId=1","urlObject":{"protocol":"http","port":"8092","path":["api","model","get-model-id"],"host":["39","104","186","210"],"query":[{"key":"tenantId","value":"1"}],"variable":[]}},"response":[],"_postman_id":"74ce0692-a78b-4dcc-8b7f-13dd8da8c00b"}],"id":"a4c8a5f3-de62-4855-957a-6f19c8554bf9","description":"<p>模型库接口\n1.获取通用模型\n2.获取用户模型\n3.创建模型\n4.训练模型\n5.删除模型</p>\n","event":[{"listen":"prerequest","script":{"id":"fb69dbcc-97dd-48b4-b9a1-0786b09a0ffd","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"41602bcb-e5d2-48ea-b626-1e60abe44763","type":"text/javascript","exec":[""]}}],"_postman_id":"a4c8a5f3-de62-4855-957a-6f19c8554bf9"},{"name":"app","item":[{"name":"get-app","id":"a4ad4bad-6ab0-4a84-b4f0-a4c75cde2219","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/app/get-app?tenantId=1","description":"<p>获取应用的相信信息, 返回结果如下:\n{\n    \"data\": [\n        {\n            \"app_id\": 1,\n            \"app_input\": [\n                {\n                    \"devide_id\": 1,\n                    \"type\": \"tem\"\n                },\n                {\n                    \"devide_id\": 1,\n                    \"type\": \"tem\"\n                }\n            ],\n            \"app_name\": \"lw_app\",\n            \"app_output\": [\n                {\n                    \"type\": \"aa\"\n                }\n            ],\n            \"model_id\": 1,\n            \"stop\": 0,\n            \"tenant_id\": 2\n        },\n        {\n            \"app_id\": 1530500013,\n            \"app_input\": [\n                {\n                    \"device_id\": \"1\",\n                    \"type\": \"tem\"\n                },\n                {\n                    \"device_id\": \"1\",\n                    \"type\": \"hum\"\n                }\n            ],\n            \"app_name\": \"\",\n            \"app_output\": [],\n            \"model_id\": 1,\n            \"stop\": 0,\n            \"tenant_id\": 2\n        }\n    ]\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","app","get-app"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>int 类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"1"},{"disabled":true,"description":{"content":"<p>可选, 模型id.</p>\n","type":"text/plain"},"key":"modelId","value":"1537191320"},{"disabled":true,"description":{"content":"<p>可选, 应用id.</p>\n","type":"text/plain"},"key":"appId","value":"1539245031"}],"variable":[]}},"response":[],"_postman_id":"a4ad4bad-6ab0-4a84-b4f0-a4c75cde2219"},{"name":"create-app","id":"d2083195-3de3-4a3e-a6ff-d2d37a141c4b","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/app/create-app?tenantId=2&modelId=1537191320&dataSource=[\"1\",\"2\",\"3\",\"4\"]&appName=power out&appOutput=PE","description":"<p>根据模型绑定数据源创建应用, 返回结果如下:\n{\n    \"app id\": 1537250702,\n    \"status\": \"create app success!\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","app","create-app"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>int类型 租户id</p>\n","type":"text/plain"},"key":"tenantId","value":"2"},{"description":{"content":"<p>模型id</p>\n","type":"text/plain"},"key":"modelId","value":"1537191320"},{"description":{"content":"<p>需要绑定的数据源, 需要与模型的输入相匹配, 每一项是传感器id. </p>\n","type":"text/plain"},"key":"dataSource","value":"[\"1\",\"2\",\"3\",\"4\"]"},{"description":{"content":"<p>模型名, 默认为app_id(随机生成).</p>\n","type":"text/plain"},"key":"appName","value":"power out"},{"description":{"content":"<p>可选, 模型的输出.</p>\n","type":"text/plain"},"key":"appOutput","value":"PE"}],"variable":[]}},"response":[],"_postman_id":"d2083195-3de3-4a3e-a6ff-d2d37a141c4b"},{"name":"delete-app","id":"18b2e139-accc-4404-8fca-8123a0d86e64","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/app/delete-app?appId=1539245067","description":"<p>删除应用, 返回结果如下:\n{\n    \"app id\": 1537250702,\n    \"status\": \"delete app success!\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","app","delete-app"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>应用id</p>\n","type":"text/plain"},"key":"appId","value":"1539245067"}],"variable":[]}},"response":[],"_postman_id":"18b2e139-accc-4404-8fca-8123a0d86e64"},{"name":"start-app","id":"dd1d7fbd-8cb9-4d52-8a98-8a5f1b3d3435","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/app/start-app?appId=1539246381","description":"<p>启动应用对绑定的数据源进行实时预测, 返回结果如下:\n{\n    \"app id\": 1537194005,\n    \"status\": \"start app success!\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","app","start-app"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>app id</p>\n","type":"text/plain"},"key":"appId","value":"1539246381"}],"variable":[]}},"response":[],"_postman_id":"dd1d7fbd-8cb9-4d52-8a98-8a5f1b3d3435"},{"name":"stop-app","id":"a358d562-ba7b-48ce-9bc1-942562137ba6","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/app/stop-app?appId=1539246381","description":"<p>停止应用, 返回的结果如下:\n{\n    \"app id\": 1537194005,\n    \"status\": \"stop app success!\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","app","stop-app"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>应用id</p>\n","type":"text/plain"},"key":"appId","value":"1539246381"}],"variable":[]}},"response":[],"_postman_id":"a358d562-ba7b-48ce-9bc1-942562137ba6"},{"name":"real-predict","id":"6b35d76b-b6d7-43ba-b6bd-cb46b2f69d23","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/app/real-predict?appId=1539246381","description":"<p>获取应用的实时预测结果, 返回结果如下:\n{\n    \"app id\": 1537194005,\n    \"predict\": [\n        443.00987838\n    ]\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","app","real-predict"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>应用id</p>\n","type":"text/plain"},"key":"appId","value":"1539246381"}],"variable":[]}},"response":[],"_postman_id":"6b35d76b-b6d7-43ba-b6bd-cb46b2f69d23"}],"id":"1c03091f-5b62-47b0-9281-dfb786c1a577","description":"<p>模型应用接口\n1.获取应用信息\n2.创建应用\n3.删除应用\n4.启动应用\n5.实时预测\n6.停止应用</p>\n","_postman_id":"1c03091f-5b62-47b0-9281-dfb786c1a577"},{"name":"etl","item":[{"name":"table-struct-mysql","id":"f5def820-818e-4757-853e-3fdad4324d01","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/etl/table-struct?db_type=mysql&host=172.24.32.169&dbname=BUPT_IOT&port=3306&passwd=root&user=root","description":"<p>获取关系型数据库表结构, 支持mysql或者postgresql, 结果示例如下:\n[\n    {\n        \"columns\": [\n            \"ability_id\",\n            \"model_id\",\n            \"ability_des\"\n        ],\n        \"table_name\": \"ability\"\n    },\n    {\n        \"columns\": [\n            \"ability_id\",\n            \"model_id\",\n            \"ability_des\"\n        ],\n        \"table_name\": \"ability1\"\n    },\n    {\n        \"columns\": [\n            \"ability_id\",\n            \"model_id\",\n            \"ability_des\"\n        ],\n        \"table_name\": \"ability2\"\n    }\n]</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","etl","table-struct"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>数据库类型, mysql或者postgresql.</p>\n","type":"text/plain"},"key":"db_type","value":"mysql"},{"description":{"content":"<p>数据库服务器地址.</p>\n","type":"text/plain"},"key":"host","value":"172.24.32.169"},{"description":{"content":"<p>数据库名.</p>\n","type":"text/plain"},"key":"dbname","value":"BUPT_IOT"},{"description":{"content":"<p>可选, 数据库服务器端口号.</p>\n","type":"text/plain"},"key":"port","value":"3306"},{"description":{"content":"<p>数据库登陆密码.</p>\n","type":"text/plain"},"key":"passwd","value":"root"},{"description":{"content":"<p>数据库登录名.</p>\n","type":"text/plain"},"key":"user","value":"root"}],"variable":[]}},"response":[],"_postman_id":"f5def820-818e-4757-853e-3fdad4324d01"},{"name":"table-struct-nosql","id":"1280343d-1d47-4e4e-aa0f-4ab7e2efd885","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/etl/table-struct?db_type=nosql&host=39.104.165.155&port=9042&dbname=bupt_iot&user&passwd","description":"<p>获取分关系型数据的表结构, 返回结果示例如下:\n[\n    {\n        \"columns\": [\n            \"attribute_key\",\n            \"bool_v\",\n            \"dbl_v\",\n            \"entity_id\",\n            \"last_update_ts\",\n            \"long_v\",\n            \"str_v\"\n        ],\n        \"table_name\": \"attributes_kv_cf\"\n    },\n    {\n        \"columns\": [\n            \"additional_info\",\n            \"customer_id\",\n            \"device_type\",\n            \"id\",\n            \"life_time\",\n            \"location\",\n            \"manufacture\",\n            \"model\",\n            \"name\",\n            \"parent_device_id\",\n            \"search_text\",\n            \"site_id\",\n            \"status\",\n            \"tenant_id\"\n        ],\n        \"table_name\": \"device\"\n    }\n]</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","etl","table-struct"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>数据库类型, 只能选择nosql.</p>\n","type":"text/plain"},"key":"db_type","value":"nosql"},{"description":{"content":"<p>数据库服务器集群地址, 多个ip以英文逗号分隔开.</p>\n","type":"text/plain"},"key":"host","value":"39.104.165.155"},{"description":{"content":"<p>可选, 数据库服务器集群端口号.</p>\n","type":"text/plain"},"key":"port","value":"9042"},{"description":{"content":"<p>数据库名.</p>\n","type":"text/plain"},"key":"dbname","value":"bupt_iot"},{"description":{"content":"<p>可选, 数据库登录名.</p>\n","type":"text/plain"},"key":"user","value":null},{"description":{"content":"<p>可选,  数据库登录密码.</p>\n","type":"text/plain"},"key":"passwd","value":null}],"variable":[]}},"response":[],"_postman_id":"1280343d-1d47-4e4e-aa0f-4ab7e2efd885"},{"name":"transform-sql","id":"aa7f5721-3ffd-43e0-a93a-e1fff98f5435","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\"source_table\":\"test\",\"db_type\":\"mysql\",\"transform_args\":[{\"type\":\"merge\",\"args\":[{\"source_columns\":[\"hah\",\"test\"],\"split_flag\":\"-\",\"drop_source_columns\":0},{\"source_columns\":[\"hah\",\"merge_hah_test\"],\"split_flag\":\"-\",\"drop_source_columns\":0}]},{\"type\":\"math\",\"args\":[{\"function\":\"mean\",\"source_columns\":[\"1\",\"2\",\"3\"],\"new_column_name\":\"ttsdffds\"},{\"function\":\"min\",\"source_columns\":[\"1\",\"2\",\"3\"],\"drop_source_columns\":0}]},{\"type\":\"split\",\"args\":[{\"source_column\":\"hah\",\"split_flag\":\"-\",\"drop_source_column\":0},{\"source_column\":\"test\",\"split_flag\":\"-\",\"drop_source_column\":1}]}]}"},"url":"http://39.104.186.210:8092/api/etl/transform","description":"<p>关系型数据库的etl操作, 参数复杂将json格式的参数放在body中, 格式说明如下:\nsource_table: 源表名\ntarget_table: 可选, 目标表名\ndb_type: 数据库类型, mysql或者postpresql\ntransform_args: 数据transform的参数, 为一个JsonArray, 每一个元素对应一种操作, 一种操作中可以有多个操作, 操作种类可以重复, 后台按JsonArray的顺序执行操作.具体格式见示例.\ndb_con_args: 可选, 数据库连接参数, 默认系统的mysql数据库. \n返回结果如下:\n{\n    \"length of data after transform\": 3,\n    \"length of data before transform\": 8,\n    \"target table\": \"test\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","etl","transform"],"host":["39","104","186","210"],"query":[],"variable":[]}},"response":[],"_postman_id":"aa7f5721-3ffd-43e0-a93a-e1fff98f5435"},{"name":"transform-nosql","id":"ff7d2bbb-7365-4c8d-8a6b-fc391d64b02d","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\"source_table\":\"group\",\"target_table\":\"group_test\",\n\"db_type\":\"nosql\",\n\"transform_args\":[{\"type\":\"split\",\"args\":[{\"source_column\":\"id\",\"split_flag\":\"-\",\"drop_source_columns\":0}]},\n{\"type\":\"filter\",\"args\":[{\"column\":\"search_text\",\"cmp\":\"like\",\"value\":\"t\"}]}]\n}"},"url":"http://39.104.186.210:8092/api/etl/transform","description":"<p>对非关系型数据库进行ETL操作, 格式说明如下:\nsource_table: 源表名\ntarget_table: 可选, 目标表名\ndb_type: 数据库类型, nosql\ntransform_args: 数据transform的参数, 为一个JsonArray, 每一个元素对应一种操作, 一种操作中可以有多个操作, 操作种类可以重复, 后台按JsonArray的顺序执行操作.具体格式见示例.\ndb_con_args: 可选, 数据库连接参数, 默认系统的mysql数据库. 返回结果如下:</p>\n<p>{\n    \"length of data after transform\": 3,\n    \"length of data before transform\": 8,\n    \"target table\": \"group_test\"\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","etl","transform"],"host":["39","104","186","210"],"query":[],"variable":[]}},"response":[],"_postman_id":"ff7d2bbb-7365-4c8d-8a6b-fc391d64b02d"},{"name":"upload-csv-file","id":"5b75bc36-80a8-44f6-9587-397b486bf8ae","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"formdata","formdata":[{"key":"csv_file","value":null,"description":"<p>要上传的csv文件, 分隔符为英文逗号.</p>\n","type":"file"},{"key":"target_table","value":"test_0918","description":"<p>要存入的数据库表名</p>\n","type":"text"},{"key":"host","value":"172.24.32.169","description":"<p>可选, 数据库服务器地址.</p>\n","type":"text"},{"key":"user","value":"root","description":"<p>可选, 数据库服务器登录名.</p>\n","type":"text"},{"key":"passwd","value":"root","description":"<p>可选, 数据库服务器登陆密码.</p>\n","type":"text"},{"key":"dbname","value":"BUPT_IOT","description":"<p>数据库名.</p>\n","type":"text"},{"key":"port","value":"3306","description":"<p>可选, 数据库服务器端口号.</p>\n","type":"text"},{"key":"db_type","value":"mysql","description":"<p>可选, 数据库类型, 默认mysql.</p>\n","type":"text"}]},"url":"http://39.104.186.210:8092/api/etl/upload-csv-file","description":"<p>上传csv文件到数据库表, 便于之后的ETL处理, 返回结果如下:\n{\n    \"database table name\": \"test_0918\",\n    \"length of data  insert into database\": 100\n}</p>\n","urlObject":{"protocol":"http","port":"8092","path":["api","etl","upload-csv-file"],"host":["39","104","186","210"],"query":[],"variable":[]}},"response":[],"_postman_id":"5b75bc36-80a8-44f6-9587-397b486bf8ae"}],"id":"d9edb05c-f031-47f2-a5e5-6c3c7aaf6d36","description":"<p>数据ETL接口\n1.关系型数据库ETL\n2.非关系型数据库ETL\n3.获取关系型数据表结构\n4.获取非关系型数据库表结构\n5.上传csv文件ETL</p>\n","event":[{"listen":"prerequest","script":{"id":"6caae72a-948e-4b98-b975-447f1c4cc24b","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"c1e6ee89-4080-4581-8652-b5215ca68658","type":"text/javascript","exec":[""]}}],"_postman_id":"d9edb05c-f031-47f2-a5e5-6c3c7aaf6d36"},{"name":"mining","item":[{"name":"k-means","id":"86d36f13-3eda-426f-ac3d-3e6e43f4f90a","request":{"method":"GET","header":[],"body":{"mode":"formdata","formdata":[]},"url":"http://39.104.186.210:8092/api/mining/k-means?sourceTable=power_out&featureColumns=[\"AT\",\"V\",\"AP\",\"RH\"]&host=172.24.32.169&user=root&passwd=root&dbname=BUPT_IOT&port=3306&n_clusters=4","urlObject":{"protocol":"http","port":"8092","path":["api","mining","k-means"],"host":["39","104","186","210"],"query":[{"description":{"content":"<p>源表</p>\n","type":"text/plain"},"key":"sourceTable","value":"power_out"},{"description":{"content":"<p>特征列</p>\n","type":"text/plain"},"key":"featureColumns","value":"[\"AT\",\"V\",\"AP\",\"RH\"]"},{"key":"host","value":"172.24.32.169"},{"key":"user","value":"root"},{"key":"passwd","value":"root"},{"key":"dbname","value":"BUPT_IOT"},{"key":"port","value":"3306"},{"description":{"content":"<p>类别的个数</p>\n","type":"text/plain"},"key":"n_clusters","value":"4"}],"variable":[]}},"response":[],"_postman_id":"86d36f13-3eda-426f-ac3d-3e6e43f4f90a"}],"id":"7177296c-b10e-4c36-90f4-0bae0e62c534","description":"<p>data mining</p>\n","_postman_id":"7177296c-b10e-4c36-90f4-0bae0e62c534"},{"name":"fade","item":[{"name":"device-status","id":"55b7a74a-7787-4e6e-a5d0-e470d0545b3a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"139.159.242.107:8092/api/dashboard/device-status","urlObject":{"port":"8092","path":["api","dashboard","device-status"],"host":["139","159","242","107"],"query":[],"variable":[]}},"response":[],"_postman_id":"55b7a74a-7787-4e6e-a5d0-e470d0545b3a"},{"name":"device-type","id":"9edd804a-7270-4050-b9de-2fd27f680e6c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"139.159.242.107:8092/api/dashboard/device-type","urlObject":{"port":"8092","path":["api","dashboard","device-type"],"host":["139","159","242","107"],"query":[],"variable":[]}},"response":[],"_postman_id":"9edd804a-7270-4050-b9de-2fd27f680e6c"},{"name":"device-count","id":"5b4e0d37-f920-4e2b-a8f6-742f67101a91","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"139.159.242.107:8092/api/dashboard/device-count","urlObject":{"port":"8092","path":["api","dashboard","device-count"],"host":["139","159","242","107"],"query":[],"variable":[]}},"response":[],"_postman_id":"5b4e0d37-f920-4e2b-a8f6-742f67101a91"},{"name":"user-satis-level","id":"2a042458-b6f9-4011-88cf-1bc62b6e39ba","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"139.159.242.107:8092/api/dashboard/user-satis-level","urlObject":{"port":"8092","path":["api","dashboard","user-satis-level"],"host":["139","159","242","107"],"query":[],"variable":[]}},"response":[],"_postman_id":"2a042458-b6f9-4011-88cf-1bc62b6e39ba"},{"name":"user-satis-reason","id":"9cac678e-c7a4-4892-992c-09de1099f2e3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"139.159.242.107:8092/api/dashboard/user-satis-reason","urlObject":{"port":"8092","path":["api","dashboard","user-satis-reason"],"host":["139","159","242","107"],"query":[],"variable":[]}},"response":[],"_postman_id":"9cac678e-c7a4-4892-992c-09de1099f2e3"},{"name":"failure-rate","id":"8c71af75-6aa3-49d7-8add-afce58d6e746","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"139.159.242.107:8092/api/dashboard/failure-rate","urlObject":{"port":"8092","path":["api","dashboard","failure-rate"],"host":["139","159","242","107"],"query":[],"variable":[]}},"response":[],"_postman_id":"8c71af75-6aa3-49d7-8add-afce58d6e746"},{"name":"failure-reason","id":"dd8c493a-dbb8-4a1c-a052-b8e48c102a56","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"139.159.242.107:8092/api/dashboard/failure-reason","urlObject":{"port":"8092","path":["api","dashboard","failure-reason"],"host":["139","159","242","107"],"query":[],"variable":[]}},"response":[],"_postman_id":"dd8c493a-dbb8-4a1c-a052-b8e48c102a56"},{"name":"maintenance","id":"87c88a60-7598-405e-b8fb-5c3b1d90119b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"139.159.242.107:8092/api/dashboard/maintenance","urlObject":{"port":"8092","path":["api","dashboard","maintenance"],"host":["139","159","242","107"],"query":[],"variable":[]}},"response":[],"_postman_id":"87c88a60-7598-405e-b8fb-5c3b1d90119b"}],"id":"d9991c1b-2006-4437-b8b4-b717da2670b9","_postman_id":"d9991c1b-2006-4437-b8b4-b717da2670b9","description":""}]}