简要描述：
- 获取导入excel的暂存的所有记录，系统只会保留24小时记录，24小时后，自动删除。
接口版本：
| 版本号 | 制定人 | 制定日期 | 修订日期 |
|---|---|---|---|
| 0.0.1 | 宋德美 | 2024-22-22 |
请求URL:
- /gw/fs/getExcelList
请求方式：
- POST
请求头：
| 参数名 | 是否必须 | 类型 | 说明 |
|---|---|---|---|
| Content-Type | 是 | string | 请求类型： application/json |
| Token | 是 | 登录token |
请求参数:
| 参数名 | 是否必须 | 类型 | 说明 |
|---|---|---|---|
| import_id | 是 | string | 导入接口返回的import_id |
返回示例:
参数含议，参考获取导入结果内说明
正确时返回:
{
"code": 200,
"data": [
{
"config": [
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
}
],
"file_path": "/data/git/photos/uploads/excels/202411/8ec796bea1d54af819181311.xlsx",
"file_key": "uploads/excels/202411/8ec796bea1d54af819181311.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "running",
"msg": "",
"start_time": "2024-11-19 18:13:11",
"end_time": null
},
{
"config": [
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
}
],
"file_path": "/data/git/photos/uploads/excels/202411/24a6013de3df655c19173433.xlsx",
"file_key": "uploads/excels/202411/24a6013de3df655c19173433.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "running",
"msg": "",
"start_time": "2024-11-19 17:34:33",
"end_time": null
},
{
"config": [
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
}
],
"file_path": "/data/git/photos/uploads/excels/202411/32d5b8408afaad0c19173301.xlsx",
"file_key": "uploads/excels/202411/32d5b8408afaad0c19173301.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "running",
"msg": "",
"start_time": "2024-11-19 17:33:01",
"end_time": null
},
{
"config": [
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
}
],
"file_path": "/data/git/photos/uploads/excels/202411/0a0dca03bf30161d19182118.xlsx",
"file_key": "uploads/excels/202411/0a0dca03bf30161d19182118.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "running",
"msg": "",
"start_time": "2024-11-19 18:21:18",
"end_time": null
},
{
"config": [
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 11,
"required": false,
"exist_field": true
},
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 2,
"required": false,
"exist_field": true
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 5,
"required": false,
"exist_field": true
},
{
"title": "登记日期",
"field": "dj_day",
"type": "datetime",
"max_length": 0,
"column": 8,
"required": false,
"exist_field": true
},
{
"title": "宝宝生日",
"field": "baby_birthday",
"type": "date",
"max_length": 0,
"column": 6,
"required": false,
"exist_field": true
}
],
"file_path": "/data/git/photos/uploads/excels/202411/024fac27f9b8817819185138.xlsx",
"file_key": "uploads/excels/202411/024fac27f9b8817819185138.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "success",
"msg": "导入成功",
"start_time": "2024-11-19 18:51:38",
"end_time": "2024-11-19 18:51:45"
},
{
"config": [
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
}
],
"file_path": "/data/git/photos/uploads/excels/202411/f53ffaaa8572b98519173722.xlsx",
"file_key": "uploads/excels/202411/f53ffaaa8572b98519173722.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "running",
"msg": "",
"start_time": "2024-11-19 17:37:22",
"end_time": null
},
{
"config": [
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
}
],
"file_path": "/data/git/photos/uploads/excels/202411/56dec40d56acae6f19173909.xlsx",
"file_key": "uploads/excels/202411/56dec40d56acae6f19173909.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "running",
"msg": "",
"start_time": "2024-11-19 17:39:09",
"end_time": null
},
{
"config": [
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
}
],
"file_path": "/data/git/photos/uploads/excels/202411/34870c967bd1a2bf19173152.xlsx",
"file_key": "uploads/excels/202411/34870c967bd1a2bf19173152.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "running",
"msg": "",
"start_time": "2024-11-19 17:31:52",
"end_time": null
},
{
"config": [
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 2,
"required": false,
"exist_field": true
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 5,
"required": false,
"exist_field": true
},
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 11,
"required": false,
"exist_field": true
}
],
"file_path": "/data/git/photos/uploads/excels/202411/e196f828e417c75419182422.xlsx",
"file_key": "uploads/excels/202411/e196f828e417c75419182422.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "success",
"msg": "导入成功",
"start_time": "2024-11-19 18:24:22",
"end_time": "2024-11-19 18:24:30"
},
{
"config": [
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 11,
"required": false,
"exist_field": true
},
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 2,
"required": false,
"exist_field": true
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 5,
"required": false,
"exist_field": true
},
{
"title": "登记日期",
"field": "dj_day",
"type": "datetime",
"max_length": 0,
"column": 8,
"required": false,
"exist_field": true
},
{
"title": "宝宝生日",
"field": "baby_birthday",
"type": "date",
"max_length": 0,
"column": 6,
"required": false,
"exist_field": true
}
],
"file_path": "/data/git/photos/uploads/excels/202411/2430304879428d0c19183041.xlsx",
"file_key": "uploads/excels/202411/2430304879428d0c19183041.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "success",
"msg": "导入成功",
"start_time": "2024-11-19 18:30:41",
"end_time": "2024-11-19 18:30:49"
},
{
"config": [
{
"title": "妈妈姓名",
"field": "customer_name",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "妈妈手机",
"field": "customer_tel",
"type": "varchar",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
},
{
"title": "",
"field": "import_id",
"type": "key",
"max_length": 0,
"column": 0,
"required": false,
"exist_field": false
}
],
"file_path": "/data/git/photos/uploads/excels/202411/98cd46b432b85c6119172330.xlsx",
"file_key": "uploads/excels/202411/98cd46b432b85c6119172330.xlsx",
"table_name": "crm_c_excel_import_data",
"status": "running",
"msg": "",
"start_time": "2024-11-19 17:23:30",
"end_time": null
}
],
"msg": ""
}错误时返回:
{
"code": 404,
"data": null,
"msg": "指定导入任务不存在:3kgwnbueluir6ghfflsyhxvg7mdit75p"
}返回参数说明:
| 参数名 | 类型 | 说明 |
|---|---|---|
| 。。。 |
备注:
- 更多返回错误代码请看首页的错误代码描述
作者：宋德美 创建时间：2024-11-22 15:01
最后编辑：宋德美 更新时间：2024-12-08 14:43
最后编辑：宋德美 更新时间：2024-12-08 14:43
