Troubleshooting Mixpanel API Response with Where Parameter

Aaditya S. · 2025-08-22T07:43:46.737Z

```{"event":"sample_event","properties":{"time":1755781642, ...}}``` The above is the response structure of the GET ` ` 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.

Troubleshooting Mixpanel API Response with Where Parameter | Mixpanel Community

3 comments

· Sorted by Oldest

Julianne Bozzini
APP
·
·
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?

Aaditya S.

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 ?

Ross Gonsolvis
APP
·
·
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:

Julianne Bozzini
APP
·
·
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?

Aaditya S.

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 ?

Ross Gonsolvis
APP
·
·
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: