获取某个项目的取数历史日志

接口说明:

获取某个项目的所有用户的取数历史日志

基本信息:

API /api/dash/easyFetchRecord/getHistoryLogsForProject
Method GET

请求参数:

字段名称 参数类型 参数说明
token String 鉴权token,该用户必须是项目管理员
projectId Int 项目ID
beginTime String 查询最大时间,格式 "2023-01-01 03:00:00"
endTime String 查询最晚时间,格式 "2023-01-01 03:00:00"
source Optional(String) 可选,取数模式,dragFetch 表示可视化取数,sqlFetch表示是sql取数,不传会返回全部
{
    "token": "1503575355359c4fdea8ec1683ed10edd91ae",
    "projectId": 64516,
    "beginTime": "2023-01-01 00:00:00",
    "endTime": "2023-12-01 00:00:00"
}

成功数据返回:

{
  "code": 200,
  "result": [
    {
      "id": 14004,
      "source": "dragFetch", // sql取数还是可视化取数
      "status": "ok", //取数的结果是成功还是失败
      "message": null, //失败的情况下有message
      "beginTime": "2023-12-07T07:11:02.863Z", //取数开始时间
      "dataModelId": 1782, //如果是可视化取数,取数对应的模型ID,对应的是 easy_fetch_data_model 这张表
      "dataConnectionId": null, //如果是sql取数,表示取数对应的数据连接ID,对应的是 easy_fetch_data_connection 这张表
      "creatorId": 11835, //取数的用户的ID
      "creatorInfo": { //取数的用户信息
        "id": 11835,
        "uniqueId": "linouya1@corp.netease.com", //账号
        "email": "linouya@126.com", //邮箱
        "nick": "林欧亚-编辑者" //昵称
      },
      "originDataModelId": 700298261 //原始的模型ID是什么, 对应的是 data_model这张表的id
    },
    {
      "id": 14013,
      "source": "sqlFetch",
      "status": "err",
      "message": "数据库SQL执行错误(DatasourceQueryError)",
      "beginTime": "2023-12-19T02:38:53.962Z",
      "dataModelId": null,
      "dataConnectionId": 242,
      "creatorId": 11835,
      "creatorInfo": {
        "id": 11835,
        "uniqueId": "linouya1@corp.netease.com",
        "email": "linouya@126.com",
        "nick": "林欧亚-编辑者"
      },
      "originDataConnectionId": 700318129 //原始的数据连接ID是什么,对应的是 data_connection这张表的id
    },

    {
      "id": 14020,
      "source": "sqlFetch",
      "status": "ok",
      "message": null,
      "beginTime": "2023-12-19T02:40:09.087Z",
      "dataModelId": null,
      "dataConnectionId": 242,
      "creatorId": 11835,
      "creatorInfo": {
        "id": 11835,
        "uniqueId": "linouya1@corp.netease.com",
        "email": "linouya@126.com",
        "nick": "林欧亚-编辑者"
      },
      "originDataConnectionId": 700318129
    }
  ],
  "apiCost": 23,
  "logPath": "http://127.0.0.1:8009/operation/log/hwyiVpvnr1wVmXqP7uDxRp"
}