# 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

### Request URL

`https://{server-hostname}:8383/dcapi/reports/queryReports/{id}/export`

### Scope

`QueryReport.READ`

### Header

`Authorization: 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/onpremise/report-get-available-query-reports.html) retrieved for saved query report.

### Sample Request

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

## Response

### 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

### Possible Response Codes

- `200` — HTTP code
- `400` — HTTP code
- `401` — HTTP code
- `500` — HTTP code

### Sample Response: HTTP 200

```text
200 OK
```

### Sample Response: HTTP 400

Export format is not pdf or csv

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

### Sample Response: 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"
}
```

### Sample Response: 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 Limits

**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.