获取帆软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
}
posted @   linhuang  阅读(117)  评论(0编辑  收藏  举报  
相关博文:
阅读排行:
· 10年+ .NET Coder 心语 ── 封装的思维:从隐藏、稳定开始理解其本质意义
· 地球OL攻略 —— 某应届生求职总结
· 提示词工程——AI应用必不可少的技术
· Open-Sora 2.0 重磅开源!
· 周边上新:园子的第一款马克杯温暖上架
点击右上角即可分享
微信分享提示