获取帆软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
}
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 10年+ .NET Coder 心语 ── 封装的思维:从隐藏、稳定开始理解其本质意义
· 地球OL攻略 —— 某应届生求职总结
· 提示词工程——AI应用必不可少的技术
· Open-Sora 2.0 重磅开源!
· 周边上新:园子的第一款马克杯温暖上架