获取帆软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 @ 2021-10-16 17:00  linhuang  阅读(85)  评论(0编辑  收藏  举报  来源