On this page

Export API

Considerations

  • The date range refers to the time the event data was uploaded to Amplitude servers (refer to server_upload_time). The Export API returns events timestamped in UTC. Data is available to export within 2 hours of when the servers received it. For example, data sent between 8 and 9 PM begins loading at 9 PM and is available through the Export API at 11 PM. Platform reporting has no delay. Only exports are delayed.
  • The Export API doesn't support cross-project views, because the view doesn't own any data. To export all the data in the view, call the Export API on the underlying projects that ingested the data.
  • The size limit is 4GB. If the size exceeds 4GB, the request returns a 400 response. In this case, choose a smaller time range to export the data. If an hour's worth of data exceeds 4GB, use the Amazon S3 export.
  • To export a whole day, use T00 to T23. For example, GET 'https://amplitude.com/api/2/export?start=20220101T00&end=20220101T23'
  • The maximum period you can query at once is 365 days.

Request

GET https://amplitude.com/api/2/export

curl
curl --location --request GET 'https://amplitude.com/api/2/export?start=<starttime>&end=<endtime>' \
-u '{api_key}:{secret_key}'

Query parameters

NameRequiredDescription
startYesFirst hour included in data series, formatted YYYYMMDDTHH. For example, 20220201T05.
endYesLast hour included in data series, formatted YYYYMMDDTHH. For example, 20220201T05.

Response

The response is a zipped archive of JSON files. Depending on data volume, there can be several files per hour. The API returns a 404 response if there is no data for the time range you requested.

Events before November 12, 2014 are grouped by day, instead of by the hour.

Response schema

The response includes one event JSON object per line in each file, with the following schema:

plaintext
{
 "server_received_time": UTC ISO-8601 formatted timestamp,
 "app": int,
 "device_carrier": string,
 "city": string,
 "user_id": string,
 "uuid": UUID,
 "event_time": UTC ISO-8601 formatted timestamp,
 "platform": string,
 "os_version": string,
 "amplitude_id": long,
 "processed_time": UTC ISO-8601 formatted timestamp,
 "version_name": string,
 "ip_address": string,
 "paying": boolean,
 "dma": string,
 "group_properties": dict,
 "user_properties": dict,
 "client_upload_time": UTC ISO-8601 formatted timestamp,
 "$insert_id": string,
 "event_type": string,
 "library": string,
 "amplitude_attribution_ids": string,
 "device_type": string,
 "start_version": string,
 "location_lng": float,
 "server_upload_time": UTC ISO-8601 formatted timestamp,
 "event_id": int,
 "location_lat": float,
 "os_name": string,
 "groups": dict,
 "event_properties": dict,
 "data": dict,
 "device_id": string,
 "language": string,
 "country": string,
 "region": string,
 "session_id": long,
 "device_family": string,
 "sample_rate": null,
 "client_event_time": UTC ISO-8601 formatted timestamp,
}

Status codes

CodeMessage
200Success
400The file size of the exported data is too large. Shorten the time ranges and try again. The limit size is 4GB.
404No data available for the time range requested.
504The amount of data is large causing a timeout. For large amounts of data, use the Amazon S3 destination.

Was this helpful?