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. 请求方式
POST3. 请求头
Content-Type: application/json4.请求参数
| 字段 | 类型 | 必填 | 说明 | 示例值 |
|---|---|---|---|---|
| num | Integer | 是 | 对象序号 | 1 |
| name | String | 是 | 设备名称 | “16800-001” |
| type | String | 是 | 设备型号名 | “1U4M角型模块化配线架” |
| cards | String | 是 | 板卡列表 | “A:1U4M-12LC-T;B:1U4M-06CoP” |
| parent | String | 是 | 设备所属机柜 | “导入测试1104-A01” |
| coordinate | String | 否 | 设备位置坐标 | |
| startUposition | Integer | 是 | 所属U位 | 30 |
| orientation | String | 是 | 设备朝向 | “f” |
| properties | List | 否 | 设备属性对象列表 | {“name”:“重量”,“value”:“1Kg”} |
请求示例:
[{"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 | Integer | 200=成功 |
| message | String | 执行结果消息 |
成功响应:
[{"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. 请求方式
POST3. 请求头
Content-Type: application/json4.请求参数
| 字段 | 类型 | 必填 | 说明 | 示例值 |
|---|---|---|---|---|
| num | Integer | 是 | 对象序号 | 1 |
| name | String | 是 | 线缆名称 | “yftest” |
| type | String | 是 | 线缆型号名 | “CAT6” |
| startNode | String | 是 | 起端设备名 | “yftest110401” |
| endNode | String | 是 | 对端设备名 | “yftest110402” |
| startSlot | String | 否 | 起端插槽名 | “A” |
| endSlot | String | 否 | 对端插槽名 | “A” |
| startPort | String | 否 | 起端端口名 | “01A/01B” |
| endPort | String | 否 | 对端端口名 | “01A/01B” |
| properties | List | 否 | 端口属性对象列表 | {“name”:“流量”,“value”:“100M/S”} |
请求示例:
[{"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 | Integer | 200=成功 |
| message | String | 执行结果消息 |
成功响应:
[{"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"}]
