如何通过REST API使用SAP BO Web Intelligence导出CSV? [英] How to export CSV's using SAP BO web intelligence through REST API?

问题描述

我有一个需要使用GUI或API自动化从SAP BO webi报表导出CSV文件的要求.有什么方法可以使用REST API将报告数据导出到CSV文件中?我尝试了OpenDocument文档中的以下选项，但是没有导出用于网络智能的CSV文件的选项.

I have a requirement where i need to export CSV files from SAP BO webi reports using GUI or API automation. Is there any way we can export report's data into CSV files using REST API's ? I have tried following options from OpenDocument documentation but there is no option to export CSV file for webintelligence.

url='http://'+obr_ip+':6405/biprws/logon/long'
base_url='https://'+obr_ip+':8443/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID='
export_options = '&sOutputFormat=H&sRefresh=Y&lsSEnter+number+of+days(X):=100&lsSEnter+values+for+Job+Type:=no_value'

推荐答案

这取决于您要导出报表查询(即原始数据)还是报表(半格式).要查询，请使用以下内容:

It depends on whether you want to export the report query (i.e., raw data), or report (semi-formatted). For query, use the following:

http://<serverName>:6405/biprws/raylight/v1/documents/{documentID}/dataproviders/{dataproviderID}/flows/{flowID}

将接受设置为文本/纯文本，以CSV格式接收结果.

Set accept to text/plain to receive the result in CSV format.

对于CSV格式的报告，请使用:

For reports in CSV format, use:

http://<serverName>:6405/biprws/raylight/v1/documents/{documentID}/reports/{reportID}

将接受设置为 text/csv ，以CSV格式接收结果.

Set accept to text/csv to receive the result in CSV format.

对于两者，请分别替换< serverName>，{documentID}，{dataproviderID}，{documentID}，{reportID]和{flowID}

For both, replace <serverName>, {documentID}, {dataproviderID}, {documentID}, {reportID], and {flowID} as appropriate

这篇关于如何通过REST API使用SAP BO Web Intelligence导出CSV?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！