自定义报表数据查询接口
接口地址
POST http://m.icsoc.net/api/v3/dm-core/report/newReport
接口header
| key | value | 备注 |
|---|
| Content-Type | application/json | 标识请求参数为json |
| Authorization | d5156955e2a6ec760f25366f5626b167ac8bfc97 | Authorization为token,用于认证,token获取方式参考最下面的附录 |
接口参数
{"templateId":438,"reportType":"P1W_DETAIL","startTime":"2019-04-01 00:00:00","endTime":"2019-04-05 12:00:00"}
参数说明
| 字段 | 说明 |
|---|
| templateId | 对应报表模板id,示例如下: 报表 模板id 坐席工作表现报表(new) 438 呼叫中心话务报表(new) 440 技能组话务报表（new） 439 业务组话务报表（new） 441 |
| reportType | 报表类型,对应枚举如下: 类型 枚举值 月报 P1M_DETAIL 日报 P1D_DETAIL 周报 P1W_DETAIL 小时明细 PT1H_DETAIL 小时叠加 PT1H_ADD 半小时明细 PT30M_DETAIL 半小时叠加 PT30M_ADD |
| startTime | 开始时间,格式为yyyy-MM-dd HH:mm:ss |
| endTime | 结束时间,格式为yyyy-MM-dd HH:mm:ss |
接口返回结果示例:
{
"code": 0,
"message": "成功",
"data": {
"reportData": [
{
"TalkTime_ACD_IB": 1005,
"ReadyTime": 2751,
"TotalHoldTime": 0,
"agName": "公司123 4308",
"MadeTransferNum_IB": 0,
"AvgConferenceTime": "0",
"TotalCallAnsweredNum_Directed_Inter_IN": 0,
"TotalConsultNum": 0,
"TotalCallAnsweredNum_Disconnect_IB": 0,
"TotalCallAnsweredNum_Disconnect_Inter_IN": 0,
"RingTime_IB": 154,
"TotalConferencedTime": 0,
"TotalTalkTime": 1010,
"TotalTransferNum": 0,
"TotalCallNum_Transfer_IB": 0,
"NotReadyTime": 232,
"TotalConferenceNum": 0,
"uZDZpunZ8YWhx": "281",
"AvgRingTime_IB": "0",
"TotalCallAnsweredNum_Direct_Inter_OUT": 0,
"EvaluateNum_FE": 0,
"TotalLoginTime": 1300,
"RingNum_OB": 53,
"TotalCallTalkTime_TakeTransfer_IB": 0,
"MadeTransferNum_Inter": 0,
"TotalCallNum_Consulted_Inter_IN": 0,
"notReadyTime_382": 0,
"TotalCallAnsweredNum_ACD_IB": 352,
"groupName": "业务组123",
"notReadyTime_380": 11286,
"notReadyTime_383": 11964,
"TotalCallNum_Directed_Inter": 0,
"TotalCallTalkTime_Disconnect_IB": 0,
"AvgConsultTime": "0",
"TotalCallTalkTime_Directed_Inter_IN": 0,
"notReadyNum_556": 0,
"TotalConferenceTime_Made": 0,
"TotalAbandonedNum_ACD_IB_A": 1,
"agId": "249901",
"TotalConferenceNum_Made": 0,
"NotReadyRate_Time": "17.88%",
"notReadyTime_556": 0,
"CallNum_OB": 53,
"TotalConferencedNum": 0,
"TotalCallAnsweredNum_TakeTransfer_IB": 0,
"CallAnsweredNum_OB": 8,
"AvgRingTime_OB": "11",
"MadeTransferNum_OB": 0,
"AvgTalkTime_OB": "82",
"TotalCallTalkTime_Direct_Inter_OUT": 0,
"RingNum_IB": 353,
"TalkTime_OB": 658,
"UtilizationRate": "79.39%",
"RingTime_OB": 579,
"TotalACWTime": 2157,
"key": 1,
"TotalCallTalkTime_Disconnect_Inter_IN": 0,
"dataDate": "2019第1周",
"TotalConsultTime_Made": 0,
"TotalCallAnsweredNum_IN": 352,
"TotalConferenceTime": 0,
"notReadyNum_380": 129,
"notReadyNum_382": 0,
"notReadyNum_383": 4,
"TotalACWNum": 406,
"TotalCallAnsweredNum_Consulted_Inter_IN": 0,
"AvgHoldTime": "0",
"TotalHoldNum": 0,
"TotalCallNum_Transfer_Inter_IN": 0,
"TotalConsultTime": 0,
"TotalConsultNum_Made": 0,
"AvgACWTime": "5",
"TotalCallTalkTime_TakeTransfer_Inter_IN": 0,
"TotalCallAnsweredNum_TakeTransfer_Inter_IN": 0,
"TotalCallTalkTime_Consult_Inter_IN": 0
}
],
"columns": [
{
"code": "agName",
"title": "坐席工号"
},
{
"code": "groupName",
"title": "业务组"
},
{
"code": "dataDate",
"title": "时间"
},
{
"code": "TotalCallAnsweredNum_IN",
"title": "总呼入接通量"
},
{
"code": "CallAnsweredNum_OB",
"title": "外呼接通量"
},
{
"code": "CallNum_OB",
"title": "外呼量"
},
{
"code": "TalkTime_OB",
"title": "外呼通话时长"
},
{
"code": "AvgTalkTime_OB",
"title": "外呼平均通话时长"
},
{
"code": "TotalTalkTime",
"title": "总通话时长"
},
{
"code": "uZDZpunZ8YWhx",
"title": "平均总通话时长"
},
{
"code": "TotalCallNum_Directed_Inter",
"title": "总内部直接通话量"
},
{
"code": "RingNum_IB",
"title": "呼入振铃次数"
},
{
"code": "RingTime_IB",
"title": "呼入振铃总时长"
},
{
"code": "AvgRingTime_IB",
"title": "呼入平均振铃时长"
},
{
"code": "RingNum_OB",
"title": "外呼拨打次数"
},
{
"code": "RingTime_OB",
"title": "外呼拨打时长"
},
{
"code": "AvgRingTime_OB",
"title": "外呼平均拨打时长"
},
{
"code": "TotalConsultNum",
"title": "咨询量"
},
{
"code": "TotalConsultTime",
"title": "咨询时长"
},
{
"code": "AvgConsultTime",
"title": "平均咨询时长"
},
{
"code": "TotalHoldNum",
"title": "总保持次数"
},
{
"code": "TotalHoldTime",
"title": "总保持时长"
},
{
"code": "AvgHoldTime",
"title": "平均保持时长"
},
{
"code": "TotalConferenceNum",
"title": "三方次数"
},
{
"code": "TotalConferenceTime",
"title": "三方时长"
},
{
"code": "AvgConferenceTime",
"title": "平均三方时长"
},
{
"code": "TotalTransferNum",
"title": "总转接数"
},
{
"code": "TotalACWNum",
"title": "总事后整理量"
},
{
"code": "TotalACWTime",
"title": "总事后整理时长"
},
{
"code": "AvgACWTime",
"title": "平均事后整理时长"
},
{
"code": "TotalLoginTime",
"title": "总登录时长"
},
{
"code": "ReadyTime",
"title": "置闲时长"
},
{
"code": "NotReadyTime",
"title": "总置忙时长"
},
{
"code": "NotReadyRate_Time",
"title": "置忙占比"
},
{
"code": "UtilizationRate",
"title": "工时利用率"
},
{
"code": "EvaluateNum_FE",
"title": "评价失败量"
},
{
"code": "TotalAbandonedNum_ACD_IB_A",
"title": "ACD呼入未接通量（坐席挂机)"
},
{
"code": "notReadyTime_380",
"title": "小休时长"
},
{
"code": "notReadyNum_380",
"title": "小休次数"
},
{
"code": "notReadyTime_382",
"title": "培训时长"
},
{
"code": "notReadyNum_382",
"title": "培训次数"
},
{
"code": "notReadyTime_383",
"title": "就餐时长"
},
{
"code": "notReadyNum_383",
"title": "就餐次数"
},
{
"code": "notReadyTime_556",
"title": "系统示忙时长"
},
{
"code": "notReadyNum_556",
"title": "系统示忙次数"
}
],
"dataCount": 7,
"pageCount": 1
}
}
| 字段 | 说明 |
|---|
| code | 0:接口正常返回,-1:调用接口出错 |
message | 调用接口成功或异常信息 |
data | 报表数据 |
dataCount | 数据条数 |
columns | 报表指标编码对应中文解释 |
附:获取token方式
接口:https://account.icsoc.net/oauth2/token
请求参数:
| 参数 | 说明 | 示例值 |
|---|
| client_id | 客户端唯一标识,须申请 | client-123 |
| client_secret | 客户端密码,须申请 | 923d6425151de64e474f1e10c13c775612xx |
| grant_type | 使用密码方式 | password |
| scope | 固定为openid | openid |
| username | 企业账号加用户名,中间用|隔开 | 4216082301|zhangsan |
| password | 登录密码 | 123456 |
原始参考文档:http://dev.icsoc.net/docs/develop/authentication/
