---
title: List warehouse export status
description: Returns daily warehouse export runs for this project. A missing date means the job did not run or exported 0 rows that day. Prefer this over GET /console/v1/…
product: general
lang: en
token_estimate: 1884
---
# List warehouse export status

> For AI agents: a documentation index is available at [/llms.txt](/llms.txt). Append `.md` to any page URL for markdown, or send `Accept: text/markdown`.

## List warehouse export status

**GET** `/console/v1/exports/status`

Full URL: `https://statsigapi.net/console/v1/exports/status`

List warehouse export status

Returns daily warehouse export runs for this project. A missing date means the job did not run or exported 0 rows that day. Prefer this over GET /console/v1/ingestion/status for export_exposures / export_events.

## Authorizations

| Name | Type | Required | Default | Description |
| --- | --- | --- | --- | --- |
| STATSIG-API-KEY | string | Yes | — | apiKey (header) |

## Query parameters

| Name | Type | Required | Default | Description |
| --- | --- | --- | --- | --- |
| startDate (query) | string | Yes | 2026-09-16 | Inclusive start date (YYYY-MM-DD, UTC). Must be a real calendar date. Range with endDate cannot exceed 90 days. |
| endDate (query) | string | Yes | 2026-09-23 | Inclusive end date (YYYY-MM-DD, UTC). Must be a real calendar date and >= startDate. Range cannot exceed 90 days. |
| dataset (query) | string | No | — | Warehouse export dataset. Omit to return both exposures and events. A missing day is either not run or exported 0 rows that day. Allowed values: exposures, events |
| status (query) | string | No | — | Uses the same rule as each row. success = ROWS_INSERTED/FILE_CREATED/%Other, or any unknown code that does not contain "error". failed = ERROR/EXPORT_ERROR/INTERNAL_SERVER_ERROR, or any unknown code that contains "error". Allowed values: success, failed |
| limit (query) | integer | No | 10 | Results per page Constraints: string, number |
| page (query) | integer | No | 1 | Page number Constraints: string, number |

## Response (application/json)

**200** — List export status success

| Name | Type | Required | Default | Description |
| --- | --- | --- | --- | --- |
| message | string | Yes | — | A simple string explaining the result of the operation. |
| data | object[] | Yes | — | — |
| data.date | string | Yes | 2026-09-21 | Export date stamp (YYYY-MM-DD, UTC). |
| data.dataset | string | Yes | — | Allowed values: exposures, events |
| data.destination | object | Yes | — | — |
| data.destination.type | string | Yes | athena | Warehouse family derived from the stored integration type (athena-echidna → athena, s3-export → s3). Constraints: nullable |
| data.status | string | Yes | — | Allowed values: success, failed |
| data.status_code | string | Yes | ERROR | Raw pipeline status (ROWS_INSERTED, ERROR, EXPORT_ERROR, …). |
| data.rows_exported | number | No | — | Constraints: format: double |
| data.message | string | Yes | — | Customer-safe sentence from ExportJobStatusNotificationHandler. Never includes rawMessage. Constraints: nullable |
| data.reported_at | string | Yes | — | Constraints: format: date-time, nullable |
| pagination | object | Yes | — | Pagination metadata for checking if there is next page for example. |
| pagination.itemsPerPage | number | Yes | — | Constraints: format: double |
| pagination.pageNumber | number | Yes | — | Constraints: format: double |
| pagination.nextPage | string | Yes | — | Constraints: nullable |
| pagination.previousPage | string | Yes | — | Constraints: nullable |
| pagination.totalItems | number | No | — | Constraints: format: double |
| pagination.all | string | No | — | — |

```json
{
  "message": "Export statuses listed successfully.",
  "data": [
    {
      "date": "2026-09-21",
      "dataset": "exposures",
      "destination": {
        "type": "athena"
      },
      "status": "failed",
      "status_code": "ERROR",
      "message": "Your Athena export_exposures export for 2026-09-21 failed. There was an error exporting exposures to your Athena warehouse: TABLE_NOT_FOUND: table exposures does not exist",
      "reported_at": "2026-09-21T00:00:00.000Z"
    }
  ],
  "pagination": {
    "itemsPerPage": 10,
    "pageNumber": 1,
    "nextPage": null,
    "previousPage": null,
    "totalItems": 1
  }
}
```

**400** — Invalid request. Please check the request input and try again.

| Name | Type | Required | Default | Description |
| --- | --- | --- | --- | --- |
| status | integer | Yes | — | Allowed values: 400 |
| message | string | Yes | — | — |

```json
{
  "status": 400,
  "message": "expected valid date in the form of YYYY-MM-DD, received: not-a-date"
}
```

**401** — This endpoint only accepts an active CONSOLE key, but an invalid key was sent. Key: console-xxxXXXxxxXXXxxx

| Name | Type | Required | Default | Description |
| --- | --- | --- | --- | --- |
| status | integer | Yes | — | Allowed values: 401 |
| message | string | Yes | — | — |

```json
{
  "status": 401,
  "message": "This endpoint only accepts an active CONSOLE key, but an invalid key was sent. Key: console-xxxXXXxxxXXXxxx"
}
```

## Code samples

### cURL

```bash
curl -X GET "https://statsigapi.net/console/v1/exports/status?startDate=2026-09-16&endDate=2026-09-23&limit=10&page=1" \
  -H "Content-Type: application/json" \
  -H "STATSIG-API-KEY: YOUR_API_KEY"
```

### Python

```python
import requests

response = requests.get(
    "https://statsigapi.net/console/v1/exports/status?startDate=2026-09-16&endDate=2026-09-23&limit=10&page=1",
    headers={
        "Content-Type": "application/json",
        "STATSIG-API-KEY": "YOUR_API_KEY"
    }
)
data = response.json()
```

### JavaScript

```javascript
const response = await fetch("https://statsigapi.net/console/v1/exports/status?startDate=2026-09-16&endDate=2026-09-23&limit=10&page=1", {
  method: "GET",
  headers: {
    "Content-Type": "application/json",
    "STATSIG-API-KEY": "YOUR_API_KEY"
  }
});
const data = await response.json();
```

### PHP

```php
<?php
$ch = curl_init("https://statsigapi.net/console/v1/exports/status?startDate=2026-09-16&endDate=2026-09-23&limit=10&page=1");
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "GET");
curl_setopt($ch, CURLOPT_HTTPHEADER, [
    "Content-Type: application/json",
    "STATSIG-API-KEY: YOUR_API_KEY"
]);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($ch);
curl_close($ch);
```

### Go

```go
package main

import (
  "bytes"
  "net/http"
)

func main() {
req, _ := http.NewRequest("GET", "https://statsigapi.net/console/v1/exports/status?startDate=2026-09-16&endDate=2026-09-23&limit=10&page=1", nil)
req.Header.Set("Content-Type", "application/json")
req.Header.Set("STATSIG-API-KEY", "YOUR_API_KEY")
  client := &http.Client{}
  resp, _ := client.Do(req)
  defer resp.Body.Close()
}
```

### Java

```java
HttpClient client = HttpClient.newHttpClient();
HttpRequest request = HttpRequest.newBuilder()
      .uri(URI.create("https://statsigapi.net/console/v1/exports/status?startDate=2026-09-16&endDate=2026-09-23&limit=10&page=1"))
      .method("GET", HttpRequest.BodyPublishers.noBody())
.header("Content-Type", "application/json")
      .header("STATSIG-API-KEY", "YOUR_API_KEY")
      .build();
HttpResponse<String> response = client.send(request, HttpResponse.BodyHandlers.ofString());
```

### Ruby

```ruby
require "net/http"
require "json"

uri = URI("https://statsigapi.net/console/v1/exports/status?startDate=2026-09-16&endDate=2026-09-23&limit=10&page=1")
request = Net::HTTP::Get.new(uri)
request["Content-Type"] = "application/json"
request["STATSIG-API-KEY"] = "YOUR_API_KEY"
response = Net::HTTP.start(uri.hostname, uri.port, use_ssl: uri.scheme == "https") do |http|
  http.request(request)
end
```