获取帆软BI数据
1、获取token
地址:http://ip:port/webroot/decision/login
方式:POST
请求参数:{
"origin":"",
"password":"password",
"username":"joker",
"encrypted":false,
"macAddress":"E4-54-E8-BB-60-80",
"supportCustomEncrypt":"true",
"deviceName":"ds"
}
返回参数
{
"data": {
"username": "joker",
"validity": 0,
"callback": null,
"accessToken": "eyJhbG1234JIUzI1NiJ9.eyJpc3MiOiJmYW5ydWFuIiwiaWF0IjoxNjM0Mzc0MzM1LCJleHAiOjE2MzQ0MjgzMzUsInN1YiI6Imxpbmh1YW5nIiwiZGVzY3JpcHRpb24iOiJbNjc5N11bNzE0Y10obGluaHVhbmcpIiwianRpIjoiand0In0.rSceIgm4STe5qO72uYn6Te022CWdgIFtOqKLbspJIUA",
"originUrlResponse": {
"originUrl": "/webroot/decision",
"method": "GET",
"parameters": {}
},
"url": "/webroot/decision"
}
}
2、调用对应的页面
地址:http://ip:port/webroot/decision/v5/conf/tables/TABLENAME/fields/page
如:http://127.0.0.1/webroot/decision/v5/conf/tables/SAPHRbi_PERSON_INFO/fields/page
方式:POST
head:{
"Authorization":Bearer+Token
}
请求参数:{
"tableName": "SAPHRbi_PERSON_INFO",
"pageIndex": 1,
"limit": 5000,
"keyword": ""
}
返回,其中data里就是返回的报表数据
{
"success": true,
"code": "200",
"message": "success",
"data": {
"fields": [
],
"data": [
],
"pageInfo": {
"totalRows": 5000,
"pageSize": 100,
"pageIndex": 1
},
"dataStatus": {
"tableName": "SAPHRbi_PERSON_INFO",
"updateStatus": 0,
"errorCode": 0,
"limit": 0
}
},
"errorCode": null,
"detailErrorMsg": null,
"errorMsg": null
}
浙公网安备 33010602011771号