Mixpanel Export API: Querying Event Order for Pagination

·Jul 08, 2025 09:29 PM·

we're using the export API to extract some events from Mixpanel for some offline analysis and we'd like to implement pagination; the endpoint doesn't have an offset parameter for that, so I was wondering if it's guaranteed to return results ordered by date? It's not mentioned in the docs...

1 comment

· Sorted by Oldest

Andrew S.
·
·
Hey Vlad. Last time I did a major API export, there is no eplicit pagination so you have to request no more than the limit on the API. For me that meant calling 1 day at a time, which when coupled with limits on # of calls per minute and per day made exporting a large amount of a data a real PITA. Everything was sorted by timestamp in my export (albeit everything was within the day, but the first things of that day were before the last things that day).

Andrew S.
·
·
Hey Vlad. Last time I did a major API export, there is no eplicit pagination so you have to request no more than the limit on the API. For me that meant calling 1 day at a time, which when coupled with limits on # of calls per minute and per day made exporting a large amount of a data a real PITA. Everything was sorted by timestamp in my export (albeit everything was within the day, but the first things of that day were before the last things that day).