Writing the Correct Payload for filter_by_cohort in Query Profiles Python

To write the correct payload in Python when using filter_by_cohort in Query Profiles, you need to format the cohort filter as a JSON string. Here's how you can do it: LBKSfilter_by_cohort = '{"id": 12345}'LBKSReplace 12345 with the actual cohort ID you want to use. This format is specified in the Exporting Profiles documentation, which states: "Example: filter_by_cohort='{"id":12345}'"You would then include this in your API request. For example, if you're using the requests library in Python, your code might look something like this: LBKSimport requestsLBKSurl = '[https://mixpanel.com/api/2.0/engage](https://mixpanel.com/api/2.0/engage)' headers = { 'Authorization': 'Basic YOUR_TOKEN', 'Content-Type': 'application/x-www-form-urlencoded' } data = { 'filter_by_cohort': '{"id": 12345}' }LBKSresponse = [requests.post](http://requests.post)(url, headers=headers, data=data)LBKSRemember to replace YOUR_TOKEN with your actual Mixpanel API token, and 12345 with your actual cohort ID.If you need to find the cohort ID, you can use the List Saved Cohorts endpoint, which will return a list of all cohorts in your project, including their IDs.Exporting Profiles List Saved Cohorts

kapa.ai is still learning and improving, please let me know how I did by reacting below.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

2 comments