nVisual批量excel导入设备与线缆生成可视化视图-接口文档

nVisual提供了excel数据批量导入接口，通过excel批量导入restful api接口，可以快速实现设备与线缆的批量上架可视化。批量导入接口需要通过 authorization:Bearer token认证，token可以通过nVisual的用户权限管理里面的API token申请，具体接口描述如下：

Excel批量导入设备接口

1. 接口说明

https://cloud.nvisual.com/diagramApi/wapi/v1/synchronizationByExcel/node/batch#根据实际地址替换https://cloud.nvisual.com
批量导入设备到nVisual机房

2. 请求方式

POST

3. 请求头

Content-Type: application/json

4.请求参数

请求示例:

[{"num":1,"status":"","name":"yftest","type":"1U4M角型模块化配线架","cards":"A:1U4M-12LC-T;B:1U4M-06CoP","parent":"导入测试1104-A01","coordinate":null,"startUposition":32,"orientation":"f","properties":[{"name":"重量","value":"1Kg"}]},{"num":2,"status":"","name":"yftest2","type":"1U4M角型模块化配线架","cards":"A:1U4M-12LC-T;B:1U4M-06CoP","parent":"导入测试1104-A01","coordinate":null,"startUposition":32,"orientation":"b","properties":[{"name":"重量","value":"1Kg"}]}]

5. 响应参数

成功响应:

[{"code":200,"data":"24749005258543","num":1},{"code":200,"data":"24749005258548","num":2}]

失败响应:

[{"code":800198,"data":null,"num":1,"message":"device model not found:1U4M角型模块化配线架12312"},{"code":800199,"data":null,"num":2,"message":"parent node not found:导入测试1104-A0112312"}]

Excel批量导入线缆接口

1. 接口说明

https://cloud.nvisual.com/diagramApi/wapi/v1/synchronizationByExcel/link/batch#根据实际地址替换https://cloud.nvisual.com
批量导入线缆连接数据到nVisual创建线缆

2. 请求方式

POST

3. 请求头

Content-Type: application/json

4.请求参数

请求示例:

[{"num":1,"status":"","name":"","type":"CAT6","startNode":"yftest110401","endNode":"yftest110402","startSlot":"A","endSlot":"A","startPort":"01A/01B","endPort":"01A/01B","properties":[{"name":"流量","value":"100M/S"}]},{"num":2,"status":"","name":"","type":"CAT6","startNode":"yftest110401","endNode":"yftest110402","startSlot":"A","endSlot":"A","startPort":"07B/07A","endPort":"07B/07A","properties":[{"name":"流量","value":"100M/S"}]}]

5. 响应参数

成功响应:

[{"code":200,"data":"24749005258543","num":1},{"code":200,"data":"24749005258548","num":2}]

失败响应:

[{"code":800204,"data":null,"num":1,"message":"no such cable model CAT6123"},{"code":800224,"data":null,"num":2,"message":"imported cable missing diagram id"}]