# Export a specified query report as a PDF or CSV file

Exports a previously saved query report as a downloadable file in the specified format (PDF or CSV). The report is looked up by its ID, the associated SQL query is executed, and the result is downloaded as a file.

## Endpoint

`GET /dcapi/reports/queryReports/{id}/export`

## Request URL

`https://{serverurl}/dcapi/reports/queryReports/{id}/export`

`{serverurl}`: [OAuth Authentication Endpoint Domain](https://www.manageengine.com/products/desktop-central/help/api/cloud/oauth-authentication-endpoint-domain.html)

## Scope

`DesktopCentralCloud.QueryReport.READ`

### Header

`Authorization: Zoho-oauthtoken d92d4xxxxxxxxxxxxx15f52`

## Request Parameters

### Request Headers

- **Accept** `string` — **Mandatory**
  - `application/octet-stream`

### Path Parameters

- **id** `string` — **Mandatory**
  - The [unique id](https://www.manageengine.com/products/desktop-central/help/api/cloud/report-get-available-query-reports.html) retrieved for saved query report

### Query Parameters

- **format** `string` — Optional
  - The export file format. Allowed values: `pdf`, `csv`. Defaults to `pdf` if not specified

## Sample Request

```curl
curl --request GET \
  --url https://appdomains/dcapi/reports/queryReports/{id}/export \
  --header 'Accept: application/octet-stream' \
  --header 'Authorization: Zoho-oauthtoken  d92d4xxxxxxxxxxxxx15f52'
```

## Response Parameters

### HTTP Code 400

#### Response Body — application/json

`JSON Object`

- **errorCode** `string`
  - Error code for invalid export request. `INVALID_QUERY` = the requested export format is not supported (only `pdf` and `csv` are allowed)
- **errorMessage** `string`
  - Human-readable message describing why the export request failed. Example: Un-Supported format

### HTTP Code 401

#### Response Body — application/json

`JSON Object`

- **errorCode** `string`
  - Error code for unauthorized access. `REPORT_UNAUTHORIZED` = the specified report ID was not found or the user does not have permission to access it
- **errorMessage** `string`
  - Human-readable message indicating the user is not authorized to access the specified query report

### HTTP Code 500

#### Response Body — application/json

`JSON Object`

- **errorCode** `string`
  - Error code for server-side failure. `INTERNAL_ERROR` = an unexpected error occurred during query execution or file generation
- **errorMessage** `string`
  - Human-readable message describing the internal server error encountered during the export process

## Sample Responses

### HTTP 200

```text
200 OK
```

### HTTP 400

Export format is not pdf or csv

```json
{
  "errorMessage": "Un-Supported format",
  "errorCode": "INVALID_QUERY"
}
```

### HTTP 401

Report ID does not exist or user does not have permission

```json
{
  "errorMessage": "You are not authorized to access this report",
  "errorCode": "REPORT_UNAUTHORIZED"
}
```

### HTTP 500

Unexpected error during query execution or file generation

```json
{
  "errorMessage": "An internal server error occurred while exporting the query report",
  "errorCode": "INTERNAL_ERROR"
}
```

## Rate Limit

![](https://www.zohowebstatic.com/sites/zweb/images/people/ico-help.png)

**Duration:** 1 minute | **Threshold:** 30 | **Lock period:** 5 minutes

Duration - Time window for the threshold.  
Threshold - Number of API calls allowed within the specified duration.  
Lock Period - Wait time before consecutive API requests.