本文講解FineBI中資料更新相關API。
API簡介
回應實例
http://192.168.101.92:8883/webroot/decision/v5/api/conf/update/generate
注:使用API時需要登入,需要傳遞token參數。
正式工程推薦配置單點登入,否則嵌入式整合後,需要反覆登入
測試階段可透過「Authorization>Bearer Token」輸入 token 值
callback({
"success": true,
"code": "200",
"message": "success",
"data": {
"taskInstanceId": "c16a6f89-1a57-4ed4-aecd-8721045db990",
"failBeans": []
},
"errorCode": null,
"detailErrorMsg": null,
"errorMsg": null
})
請求參數-Query參數
1)資料夾ID:
2)表轉義名:
表轉義名即為在資料目錄中看到的表名稱
3)fullload:
false:增量更新
true:全量更新
不填:預設為 true
回應實體
編碼前參數值:
{"packageId":"6fb11e7b1e6e4ff3bcb907a5747527b0","tableName":"各省招生人數表","fullLoad":"true"}
編碼後參數值:
%7B%22packageId%22%3A%226fb11e7b1e6e4ff3bcb907a5747527b0%22%2C%22tableName%22%3A%22%E5%90%84%E7%9C%81%E6%8B%9B%E7%94%9F%E4%BA%BA%E6%95%B0%E8%A1%A8%22%2C%22fullLoad%22%3A%22true%22%7D
連結:
http://192.168.101.92:8883/webroot/decision/v5/api/conf/update/pack/table?info=%7B%22packageId%22%3A%226fb11e7b1e6e4ff3bcb907a5747527b0%22%2C%22tableName%22%3A%22%E5%90%84%E7%9C%81%E6%8B%9B%E7%94%9F%E4%BA%BA%E6%95%B0%E8%A1%A8%22%2C%22fullLoad%22%3A%22true%22%7D
"taskInstanceId": "4575b222-f549-4869-97b6-030d01e4eb50",
/v5/api/conf/update/batch
請求參數-body參數
[
{
"packageId":"資料夾ID",
"fullLoad":false
}
]
2)fullload:
http://192.168.101.92:8883/webroot/decision/v5/api/conf/update/batch
"packageId":"6fb11e7b1e6e4ff3bcb907a5747527b0",
"taskInstanceId": "e193cba7-2b2c-48c7-8388-c0ff4796975c",
/v5/api/conf/update/instance/{taskInstanceId}
taskInstanceId為更新任務ID
http://192.168.101.92:8883/webroot/decision/v5/api/conf/update/instance/c881e324-a582-417b-aa29-a5c743b4ae68
"taskInstanceId": "c881e324-a582-417b-aa29-a5c743b4ae68",
"taskName": "BI-Update_Api_Batch_Update",
"startTime": 1765939626598,
"endTime": 1765939629783,
"state": 1,
"waitStatus": 0,
"triggerMode": 1,
"triggerType": 3,
"costTime": 3185,
"resultType": 1,
"roleName": "API",
"baseTableExpect": 6,
"baseTableFinish": 6,
"analysisTableExpect": 1,
"analysisTableFinish": 1,
"relationExpect": 0,
"relationFinish": 0,
"notExtractExpect": 1,
"notExtractFinish": 1,
"modelExpect": 0,
"modelFinish": 0,
"relationAccelerateExpect": 0,
"relationAccelerateFinish": 0,
"auth": true,
"process": 0.0,
"cancel": false,
"inLine": false
回應參數說明
更新狀態
1:已結束
2:正在運作中
觸發方式
1:手動
2:定時
3:內部
1:全部成功
2:部分成功
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
反馈已提交
网络繁忙