Kale | Mixpanel Community

Commented on Troubleshooting Mixpanel API Request Issues in Pyt...·Posted inMixpanel Bot

Kale

kapa.ai to respond to all of your points:

1.
URL Formatting Issue: Your URL appears to have HTML encoding issues with <https:// and <redacted>. The correct format should be a plain URL without these HTML tags. - Obviously I am not using html tags. Just the project_id which works on other requests.
2.
Authentication Method: You’re using the Project Secret authentication method (which is being deprecated, though still supported). Make sure your api_secret is correct. - The api_secret is correct, I use it on other api endpoints.
3.
Date Range: You’re requesting data for April 1, 2025, which is in the future. The API can only export historical data. - Today’s date is April 4th 2025
4.
Rate Limits: The Raw Event Export API has specific rate limits that might be affecting your request - I receive a 400, not a 429
5.
Event Existence: Verify that the event “streaks_reward_page” exists in your project for the specified date range. - Yes that event exists.

Using your code, I still receive a 400 level response Error exporting events: invalid parameter: project_id

Posted in Mixpanel Bot·

Kale

Troubleshooting Mixpanel API Request Issues in Python

I am sending a request like the following in python:

url = "https://data.mixpanel.com/api/2.0/export?project_id=<redacted>&from_date=2025-04-01&to_date=2025-04-01&limit=100000&event=streaks_reward_page"

response = requests.get(
  url,
  auth=(self.api_secret, ''),
  timeout=180,
)

I have verified the project_id works because I can make requests to the engage endpoint and I get a response. What is the issue?

4Comments

Commented on Troubleshooting Mixpanel API Where Filter for Prof...·Posted inCommunity Questions

Kale

okay, it looks like datetimes need to be formatted like the following "2025-03-01T00:00:00"

Commented on Fixing the API Request for Mixpanel Profile Retrie...·Posted inMixpanel Bot

Kale

kapa.ai datetimes need to be formatted like the following "2025-03-01T00:00:00"

Posted in Mixpanel Bot·

Kale

Fixing the API Request for Mixpanel Profile Retrieval Issues

I am attempting to request profiles from the api and unfortunately are not able to get the where filter to work. I am doing the following:

last_seen_after = "2025-03-01"
params = {
  "project_id": self.project_id,
  "page_size": page_size,
  "page": page
}

if last_seen_after:
  params["where"] = f'properties["$last_seen"] > "{last_seen_after}"'

response = requests.get(
    "https://mixpanel.com/api/2.0/engage",
    params=params,
    auth=(self.api_secret, ''),
    timeout=120,
)

It is always returning 0 records. I have verified that there are users that would qualify for this request. I have also tried passing the last_seen_after as a unix timestamp and it does not work. What am I missing? How can I fix my request to work properly?

5Comments

Commented on Troubleshooting Mixpanel API Where Filter for Prof...·Posted inCommunity Questions

Kale

I just ran a search in this chat and saw that unix time was recommended by another user. However that also failed to work. For example 'where': 'properties["$last_seen"] > "1740787200"' still fails. And your docs are no help. When I view the website, the API is using this payload where the structure is completely different:

{"filter_by_cohort":{"raw_cohort":{"name":"","id":null,"unsavedId":null,"groups":[{"behavioralFiltersOperator":"and","event":{"resourceType":"cohort","value":"$all_users"},"filters":[{"resourceType":"user","propertyName":"$last_seen","propertyObjectKey":null,"propertyDefaultType":"datetime","propertyType":"datetime","filterOperator":"in the last","filterValue":{"type":"in the last","window":{"value":33,"unit":"day"}},"filterDateUnit":"day"}],"filtersOperator":"and","groupingOperator":null,"property":null,"type":"cohort_group"}]}},"sort_order":"descending","sort_column":{"dataGroupId":"","label":"Updated at","propertyDefaultType":"datetime","resourceType":"user","type":"datetime","value":"$last_seen"},"search":"","columns":[{"value":"$mp_name_with_fallbacks","resourceType":"user","dataGroupId":""},{"dataGroupId":"","label":"Email","propertyDefaultType":"string","resourceType":"user","type":"string","value":"$email"},{"dataGroupId":"","label":"Distinct ID","propertyDefaultType":"string","resourceType":"user","type":"string","value":"$distinct_id"},{"dataGroupId":"","label":"Updated at","propertyDefaultType":"datetime","resourceType":"user","type":"datetime","value":"$last_seen"},{"dataGroupId":"","label":"Country Code","propertyDefaultType":"string","resourceType":"user","type":"string","value":"$country_code"},{"dataGroupId":"","label":"Region","propertyDefaultType":"string","resourceType":"user","type":"string","value":"$region"},{"dataGroupId":"","label":"City","propertyDefaultType":"string","resourceType":"user","type":"string","value":"$city"},{"value":"$avatar","resourceType":"user","dataGroupId":""}],"tracking_props":{"is_main_query_for_report":true,"report_name":"users_sidebar"},"project_id":"PRIVATE","include_all_users":false,"limit":1000,"use_query_sampling":false,"workspace_id":"PRIVATE"}

There is no where operator or anything displaying that I am filtering by $last_seen why is this so difficult?

Posted in Community Questions·

Kale

Troubleshooting Mixpanel API Where Filter for Profile Requests

I am attempting to request profiles from the api and unfortunately are not able to get the where filter to work. I am doing the following:

last_seen_after = "2025-03-01"
params = {
  "project_id": self.project_id,
  "page_size": page_size,
  "page": page
}

if last_seen_after:
  params["where"] = f'properties["$last_seen"] > "{last_seen_after}"'

response = requests.get(
    "https://mixpanel.com/api/2.0/engage",
    params=params,
    auth=(self.api_secret, ''),
    timeout=120,
)

It is always returning 0 records. I have verified that there are users that would qualify for this request. What am I missing?

2Comments

Commented on How to Export Events from Mixpanel for the Last 30...·Posted inCommunity Questions

Kale

Thank you Andrew S.. When I hit export, it only exports the first 100 events. How can I export the whole list?

Posted in Community Questions·

Kale

How to Export Events from Mixpanel for the Last 30 Days

I would like to export a list of events tracked in mixpanel over the last 30 days. How can I do that?

3Comments

Commented on Using Mixpanel API to Retrieve MAU, WAU, and DAU U...·Posted inMixpanel Bot

Kale

I am attempting to use the engage endpoint and I find the method for filtering to be overly complex. I do not understand how to include the filter in code. Are tjere no examples of how to do this?