Exporting a Report in Listing Mode

Exports the report in one of the following formats:

  • HTML
  • zipped HTML
  • MHTML
  • XML
  • PDF
  • MS Excel 2003
  • MS Excel 2007
  • CSV
Note If you choose the HTML format, the web service generates the image links. Therefore, the logon token must still be valid when the HTML output is displayed.
Request

GET <webiURL>/documents/{documentId}/reports/{reportId}?[parameters]

Where:
  • {documentId} is the document identifier retrieved from the list of documents
  • {reportId} is the report identifier retrieved from the list of reports
Table 1: Optional Parameters
Parameter Description Supported Formats
dpi

Resolution in dots per inch (dpi) for generated charts. Value between 75 and 9600. Default is 300 for PDF format, 96 for all other formats.

All
chartOutputFormat

Output format for generated chart. Values are: jpeg, bmp, gif, and png (default).

HTML, ZIP, and MHTML

fileName

A string that defines the name of the ZIP file. If set, the HTML output is zipped to a fileName.zip file. Maximum string length is 96.

ZIP
unit

A string that defines the unit that sizes will be reported in. Values are "metric", "millimeter", "point", and "pixel" (default).

XML
optimized

Boolean. Default is false. If true, the generated output is optimized for calculations inside MS Excel.

MS Excel 2003 and MS Excel 2007

textQualifier

Character used to surround each column value. Values are' or ".

CSV
columnDelimiter

String that defines a character put between columns. Values are comma (,), semi-colon (;) or the special string Tab.

CSV
charset

String that defines a valid server charset retrieved from the list of charsets.

CSV
Response
Response type:
  • text/html for HTML
  • application/zip for zipped HTML
  • multipart/related for MHTML
  • text/xml
  • application/pdf
  • application/vnd.ms-excel for MS Excel 2003
  • application/vnd.openxmlformats-officedocument.spreadsheetml.sheet for MS Excel 2007
  • text/csv

Response body: the result of the exported report in the specified format.

Example

HTML
curl -G -s -H "accept:text/html" -H X-SAP-LogonToken:"""%tokenValue%"""
 "<webiURL>/documents/9512/reports/67?chartOutputFormat=jpeg" > exportedreport.htm