excel import的api
GET ... /excel/import/template 下载excel导入的模板(下载文件 不需要参数)
POST ... /excel/import/create 导入excel
请求参数:
参数名称 | 是否必须 | 数据类型 | 描述 | 取值范围 |
---|---|---|---|---|
file | true | file | excel文件 | |
userEmail | true | String | 用户邮箱 |
响应数据:
参数名称 | 是否必须 | 数据类型 | 描述 | 取值范围 |
---|---|---|---|---|
status | true | 响应状态(1表示正确,其他的数字表示错误) | ||
data | false | excel的id | ||
message | false | String | 请求错误的时候会返回错误信息 |
请求响应例子:
/* post /excel/import/create */
{
"status": 1,
"data": "cd8f8a70db0d40be8921cce0165f2d61"
}
GET .../download/error/excel 下载错误导入错误的excel数据
请求参数:
参数名称 | 是否必须 | 数据类型 | 描述 | 取值范围 |
---|---|---|---|---|
userEmail | true | String | 用户邮箱 | |
excelId | true | String | excel的id(唯一id) |
POST .../history 分页查询用户所有导入excel的历史数据
请求响应例子:
/* post /history
{
"userEmail": "tony@intramirror.com",
"limit": 10,
"offset": 0
}
Response 响应:
{
"status": 1,
"data": [
{
"taskType": "Product Import",
"userEmail": "tony@intramirror.com",
"status": "Completed",
"startTime": "2019-01-25 14:30:41",
"endTime": "2019-01-25 14:30:43"
},
{
"taskType": "Product Import",
"userEmail": "tony@intramirror.com",
"status": "Completed",
"startTime": "2019-01-25 14:27:54",
"endTime": "2019-01-25 14:27:56"
},
{
"taskType": "Product Import",
"userEmail": "tony@intramirror.com",
"status": "Completed",
"startTime": "2019-01-25 14:24:48",
"endTime": "2019-01-25 14:24:49"
},
{
"taskType": "Product Import",
"userEmail": "tony@intramirror.com",
"status": "Completed",
"startTime": "2019-01-25 14:14:22",
"endTime": "2019-01-25 14:14:23"
},
{
"taskType": "Product Import",
"userEmail": "tony@intramirror.com",
"status": "Completed",
"startTime": "2019-01-25 14:11:16",
"endTime": "2019-01-25 14:11:17"
},
{
"taskType": "Product Import",
"userEmail": "tony@intramirror.com",
"status": "Completed",
"startTime": "2019-01-25 14:10:14",
"endTime": "2019-01-25 14:10:15"
},
{
"taskType": "Product Import",
"userEmail": "tony@intramirror.com",
"status": "Completed",
"startTime": "2019-01-25 13:29:39",
"endTime": "2019-01-25 13:29:41"
},
{
"taskType": "Product Import",
"userEmail": "tony@intramirror.com",
"status": "Completed",
"startTime": "2019-01-24 18:54:23",
"endTime": "2019-01-24 18:54:29"
}
]
}
网友评论