{"event":"sample_event","properties":{"time":1755781642, ...}}The above is the response structure of the GET https://data.mixpanel.com/api/2.0/export I want to apply the where parameter as properties["time"] > 1755781600, but response is not expected and the response says OK only with status code 200.
Hi Aaditya- Julianne from Mixpanel Support here!
When filtering by time with the Raw Export API, the requests should do the following:
1. Use the $time property (with the dollar sign) instead of just time.
2. Use the datetime() function to properly format the timestamp.
So, your where parameter should look something like this: properties["$time"] > = datetime("2025-04-18T00:00:00").
Mind giving that a try?
curl --request GET \
--url 'https://data.mixpanel.com/api/2.0/export?from_date=2025-09-16&to_date=2025-09-16&event=%5B%22download_data%22%5D&where=properties%5B%22%24time%22%5D%20%3E%3D%20datetime%28%222025-04-18T00%3A00%3A00%22%29' \
--header 'accept: text/plain' \
--header 'authorization: Basic <secret>'
Can u please modify this curl request to adjust the above where filter ?
Hi Aaditya, I think the error here may be that you are using the From_date and To_date for a very short period of time, and the where filter is for events in April, which do not fall in the from and to dates. In this case, you should expand the date range for the from and to dates. Additionally, when using Service account credentials, you must use the Project ID. In my example, I have used this type of authentication. If you are using just the API secret, do not include the project ID. We can see an example of the curl request here: ``` curl --request GET --url 'https://data.mixpanel.com/api/2.0/export?project_id=12345&from_date=2025-03-16&to_date=2025-09-16&event=["download_data"]&where=properties["$time"] > = datetime("2025-04-18T00:00:00")' --header 'accept: text/plain' --header 'authorization: Basic <secret> '
I hope this helps, If you have any doubts, please do not hesitate to ask! For a more in-depth explanation of this topic, you can see this [page](https://developer.mixpanel.com/reference/raw-event-export) for more information :slightly_smiling_face:
Best Regards,
--------------------
Ross Gonsolvis
Support Engineer
Mixpanel
Barcelona | Spain
Could this experience have been improved? Was my support helpful? In a few days, you'll receive a survey, and I would greatly appreciate your feedback! :slightly_smiling_face:
