The Export API lets you export your project's event data.
This API uses basic authentication, using the API key and secret key for your project. Pass base64-encoded credentials in the request header like {api-key}:{secret-key}
. api-key
replaces username, and secret-key
replaces the password.
Your authorization header should look something like this:
--header 'Authorization: Basic YWhhbWwsdG9uQGFwaWdlZS5jb206bClwYXNzdzByZAo'
For more information, see Find your API Credentials
Region | Endpoint |
---|---|
Standard server | https://amplitude.com/api/2/export |
EU residency server | https://analytics.eu.amplitude.com/api/2/export |
server_upload_time
). The Export API returns events timestamped in UTC. Data is available to export at a minimum 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 via the Export API at 11 PM. Note that there is no delay in platform reporting. Only exports are delayed.T00
to T23
. For example, GET 'https://amplitude.com/api/2/export?start=20230101T00&end=20220101T23'
GET https://amplitude.com/api/2/export
1curl --location --request GET 'https://amplitude.com/api/2/export?start=<starttime>&end=<endtime>' \2-u '{api_key}:{secret_key}'
1GET /api/2/export?start=<starttime>&end=<endtime> HTTP/1.12Host: amplitude.com3Authorization: Basic {api-key}:{secret-key} #credentials must be base64 encoded
Example: Get data for a period
Name | Description |
---|---|
start |
Required. First hour included in data series, formatted YYYYMMDDTHH. For example, 0220201T05 . |
end |
Required. Last hour included in data series, formatted YYYYMMDDTHH For example, 20220201T05 . |
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 is there is no data for the time range you requested.
Events before November 12, 2014 are grouped by day, instead of by the hour.
The response includes one event JSON object per line in each file, with the following schema:
1{ 2 "server_received_time": UTC ISO-8601 formatted timestamp, 3 "app": int, 4 "device_carrier": string, 5 "city": string, 6 "user_id": string, 7 "uuid": UUID, 8 "event_time": UTC ISO-8601 formatted timestamp, 9 "platform": string,10 "os_version": string,11 "amplitude_id": long,12 "processed_time": UTC ISO-8601 formatted timestamp,13 "version_name": string,14 "ip_address": string,15 "paying": boolean,16 "dma": string,17 "group_properties": dict,18 "user_properties": dict,19 "client_upload_time": UTC ISO-8601 formatted timestamp,20 "$insert_id": string,21 "event_type": string,22 "library": string,23 "amplitude_attribution_ids": string,24 "device_type": string,25 "start_version": string,26 "location_lng": float,27 "server_upload_time": UTC ISO-8601 formatted timestamp,28 "event_id": int,29 "location_lat": float,30 "os_name": string,31 "groups": dict,32 "event_properties": dict,33 "data": dict,34 "device_id": string,35 "language": string,36 "country": string,37 "region": string,38 "session_id": long,39 "device_family": string,40 "sample_rate": null,41 "client_event_time": UTC ISO-8601 formatted timestamp,42}
Code | Message |
---|---|
200 | Success |
400 | The file size of the exported data is too large. Shorten the time ranges and try again. The limit size is 4GB. |
404 | No data available for the time range requested. |
504 | The amount of data is large causing a timeout. For large amounts of data, use the Amazon S3 destination. |
Thanks for your feedback!
May 21st, 2024
Need help? Contact Support
Visit Amplitude.com
Have a look at the Amplitude Blog
Learn more at Amplitude Academy
© 2024 Amplitude, Inc. All rights reserved. Amplitude is a registered trademark of Amplitude, Inc.