# Retrieve a Query Run

Fetches the current state and details of a previously created `QueryRun`. If the `QueryRun`

has succeeded, the endpoint will provide details for how to retrieve the results.

#### Running

#### Running

## Request

```curl
curl https://api.stripe.com/v2/data/reporting/query_runs/qryrun_test_xxx \
  -H "Authorization: Bearer <<YOUR_SECRET_KEY>>" \
  -H "Stripe-Version: 2026-07-29.preview"
```

### Response

```json
{
  "created": "2025-08-26T00:00:00.000Z",
  "id": "qryrun_test_xxx",
  "object": "v2.data.reporting.query_run",
  "sql": "select * from balance_transactions limit 10",
  "result": null,
  "result_options": {
    "compress_file": false
  },
  "status": "running",
  "status_details": {},
  "livemode": false
}
```

#### Succeeded

#### Succeeded

## Request

```curl
curl https://api.stripe.com/v2/data/reporting/query_runs/qryrun_test_xxx \
  -H "Authorization: Bearer <<YOUR_SECRET_KEY>>" \
  -H "Stripe-Version: 2026-07-29.preview"
```

### Response

```json
{
  "created": "2025-08-26T00:00:00.000Z",
  "id": "qryrun_test_xxx",
  "object": "v2.data.reporting.query_run",
  "sql": "select * from balance_transactions limit 10",
  "result": {
    "file": {
      "content_type": "csv",
      "download_url": {
        "expires_at": "2025-08-26T21:53:30.446396574Z",
        "url": "https://stripeusercontent.com/files/us-west-2/..."
      },
      "size": "500"
    },
    "type": "file"
  },
  "result_options": {
    "compress_file": false
  },
  "status": "succeeded",
  "status_details": {},
  "livemode": false
}
```

#### Failed

#### Failed

## Request

```curl
curl https://api.stripe.com/v2/data/reporting/query_runs/qryrun_test_xxx \
  -H "Authorization: Bearer <<YOUR_SECRET_KEY>>" \
  -H "Stripe-Version: 2026-07-29.preview"
```

### Response

```json
{
  "created": "2025-08-26T00:00:00.000Z",
  "id": "qryrun_test_xxx",
  "object": "v2.data.reporting.query_run",
  "sql": "select * from balance_transactions limit 10",
  "result": null,
  "result_options": {
    "compress_file": false
  },
  "status": "failed",
  "status_details": {
    "failed": {
      "error_code": "file_size_above_limit",
      "error_message": "The file generated by this request exceeds the 5 GB limit."
    }
  },
  "livemode": false
}
```

## Returns

Returns a [Query Run object](https://docs.stripe.com/api/v2/data/reporting/query-runs/object.md?api-version=2026-07-29.preview).

## Error Codes

| HTTP status code | Code | Description |
| --- | --- | --- |
| 403 | query_run_api_inaccessible | Returned when the query runs API is not accessible to the request. The error message provides the reason (e.g. feature not enabled, compartment not allowed). |
| 404 | not_found | The resource wasn’t found. |