Get Data Export Job Status

1 min

GET

https://api.us1.odp.optimizely.com/v3/exports/{exportJobId}

Fetch the status of a data export request.

Path Parameters

exportJobIdstringrequired
Description
The export job ID to check. Example: Example: "3aab9524-5248-45f9-8102-0399872a921e".

Responses

200OK

ExportJobStatus
- idstringrequired
  Example
  3aab9524-5248-45f9-8102-0399872a921e
- pathstringrequired
  Example
  s3://zaius-outgoing/kIFB_X1VG2gf6caBn8LHtg/data-exports/3aab9524-5248-45f9-8102-0399872a921e
- statestring<pending | running | completed | completed_with_errors>required
  Example
  pending
  Allowed
  pendingrunningcompletedcompleted_with_errors
- exportRowCountinteger<int64>
  Example
  14
  Format
  int64
- exportTypestring
  Example
  data
- requestedAtstring<date-time>required
  Example
  2018-09-11T02:07:10.000Z
  Format
  date-time
- startedAtstring<date-time>
  Format
  date-time
- endedAtstring<date-time>
  Format
  date-time
- presignedUrlsstring[]
  Example
```
[
  "https://s3.amazonaws.com/abc123/data-exports/abc123/has_email_0_0_0.csv.gz?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20250403T162222Z&X-Amz-SignedHeaders=host&X-Amz-Expires=3599&X-Amz-Credential=abc123%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=abc123"
]
```
- activeboolean
- formatstring<csv | parquet>
  Allowed
  csvparquet
- runningboolean
- terminatedboolean
- delimiterstring<tab | comma | pipe>
  Allowed
  tabcommapipe
- routeBasestring
- trackerIdstring
- completeboolean
- pendingboolean
- childErrorsstring[]
- detailExportDefinition
  - idstringrequired
    Example
    3aab9524-5248-45f9-8102-0399872a921e
  - formatstring<csv | parquet>required
    Example
    csv
    Allowed
    csvparquet
  - delimiterstring<tab | comma | pipe>
    Example
    comma
    Allowed
    tabcommapipe
  - selectSelect
    - objectstringrequired
      Example
      events
      Description
      Target object for this selection filter.
    - fieldsstring[]required
      Example
      [ "product.name" ]
      Description
      An array of fields to export. The array ['*'] captures all fields from select.object, but does not follow any relations.
    - filtermap<string, object>
      Example
      { "field": "product.name", "operator": "=", "value": "%shoe%" }
      Description
      Refer to "Filtering" section.
    - sortsSort[]
      Description
      Sort specification applied to each export file. A single table export may span multiple files.
  - exportTypestring
    Example
    data
  - objectsstring[]
    Example
    [ "string" ]

403Forbidden

string

Example

{
  "title": "Forbidden",
  "status": 403,
  "timestamp": "2018-09-11T02:07:10.000Z",
  "detail": {
    "message": "Insufficient privileges to access this resource."
  }
}

404Not Found

string

Example

{
  "title": "Not Found",
  "status": 404,
  "timestamp": "2018-09-11T02:07:10.000Z",
  "detail": {
    "message": "Unable to locate status for the export example."
  }
}

curl

curl --request GET \
     --url https://api.us1.odp.optimizely.com/v3/exports/{exportJobId} \
     --header 'accept: application/json'

javascript

var myHeaders = new Headers();
myHeaders.append("accept", "application/json");
myHeaders.append("content-type", "application/json");

var requestOptions = {
   method: 'GET',
   headers: myHeaders,
   redirect: 'follow'
};

fetch("https://api.us1.odp.optimizely.com/v3/exports/{exportJobId}", requestOptions)
   .then(response => response.text())
   .then(result => console.log(result))
   .catch(error => console.log('error', error));

ruby

require "uri"
require "json"
require "net/http"

url = URI("https://api.us1.odp.optimizely.com/v3/exports/{exportJobId}")

https = Net::HTTP.new(url.host, url.port)
https.use_ssl = true

request = Net::HTTP::Get.new(url)
request["accept"] = "application/json"
request["content-type"] = "application/json"

response = https.request(request)
puts response.read_body

python

import requests
import json

url = "https://api.us1.odp.optimizely.com/v3/exports/{exportJobId}"

payload = {}
headers = {
   'accept': 'application/json',
   'content-type': 'application/json'
}

response = requests.request("GET", url, headers=headers, data=payload)

print(response.text)

200

// OK
{
  "id": "3aab9524-5248-45f9-8102-0399872a921e",
  "path": "s3://zaius-outgoing/kIFB_X1VG2gf6caBn8LHtg/data-exports/3aab9524-5248-45f9-8102-0399872a921e",
  "state": "pending",
  "exportRowCount": 14,
  "exportType": "data",
  "requestedAt": "2018-09-11T02:07:10.000Z",
  "startedAt": "",
  "endedAt": "",
  "presignedUrls": [
    "https://s3.amazonaws.com/abc123/data-exports/abc123/has_email_0_0_0.csv.gz?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20250403T162222Z&X-Amz-SignedHeaders=host&X-Amz-Expires=3599&X-Amz-Credential=abc123%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=abc123"
  ],
  "active": false,
  "format": "",
  "running": false,
  "terminated": false,
  "delimiter": "",
  "routeBase": "",
  "trackerId": "",
  "complete": false,
  "pending": false,
  "childErrors": [
    ""
  ],
  "detail": {
    "id": "3aab9524-5248-45f9-8102-0399872a921e",
    "format": "csv",
    "delimiter": "comma",
    "select": {
      "object": "events",
      "fields": [
        "[\"product.name\"]"
      ],
      "filter": "{\"field\":\"product.name\",\"operator\":\"=\",\"value\":\"%shoe%\"}",
      "sorts": [
        ""
      ]
    },
    "exportType": "data",
    "objects": [
      "[\"string\"]"
    ]
  }
}

403

// Forbidden
"{\"title\":\"Forbidden\",\"status\":403,\"timestamp\":\"2018-09-11T02:07:10.000Z\",\"detail\":{\"message\":\"Insufficient privileges to access this resource.\"}}"

404

// Not Found
"{\"title\":\"Not Found\",\"status\":404,\"timestamp\":\"2018-09-11T02:07:10.000Z\",\"detail\":{\"message\":\"Unable to locate status for the export example.\"}}"