[Dashboard REST API] event filtration

Hi all, just stacked with a small problem.

This piece of code works perfect, but if I uncomment filter clause I got an “HTTP 400: Bad Request”. Same as in documentation, but error =(

params = {<br />    "event_type":"registerComplete", <br />    # "filters": [<br />    #     {<br />    #         "subprop_type": "event",<br />    #         "subprop_key": "EmailVerified",<br />    #         "subprop_op": "is",<br />    #         "subprop_value": ["true"]<br />    #     }<br />    #     ]<br />      }<br /><br />dates = '&start=20210615&end=20210615'<br />url = SEGMENT_URI + json.dumps(params) + dates<br /><br />response = requests.get(url, auth = (api_android, secret_android))

Thanks.

Find more posts tagged with

API

Python

Accepted answers

Denis Holmes

Hi all!

It seems like the user property was causing the issue. When we use a custom user property to filter on, we have to use gp: before it. So, the chart in question would have looked like the following :

curl -u API_KEY:SECRET_KEY 'https://amplitude.com/api/2/events/segmentation?e=\{"event_type":"registerComplete","filters":\[\{"subprop_type":"user","subprop_key":"gp:country","subprop_op":"is","subprop_value":\["(none)"\]\}\]\}&start=20210608&end=20210608'

So, we must use a gp: before the event name when we use a custom event. I hope this explains the situation for everyone ! If there are any problems with it, feel free to reply/comment beneath!

Have a great weekend all!

All comments

Saish Redkar

Hey alex_t
Assuming you are using the https://amplitude.com/api/2/events/segmentation end point here, I don’t see the required event parameter ‘e’ being used in this code snippet and only the start and end parameters. Could I be missing some of the context in this snippet?

An alternate way to format this request would be to build the individual required parameters using a dictionary for the params.

params_with_filter = {<br />    'e': '{"event_type":"registerComplete","filters":[{"subprop_type":"event","subprop_key":"EmailVerified","subprop_op":"is","subprop_value":["true"]}]}',<br />    'start': '20210615',<br />    'end': '20210615'<br />}<br /><br />params_without_filter = {<br />    'e': '{"event_type":"registerComplete"}',<br />    'start': '20210615',<br />    'end': '20210615'<br />}<br /><br /><br /><br />url = 'https://amplitude.com/api/2/events/segmentation'<br /><br />r = requests.get(url, params = params_without_filter, auth = (api_android, secret_android))<br />

Let me know if this code helps.

alex_t

Hi, Saish.

The code you’ve provided returns an error

params_with_filter = {<br />    'e': '{"event_type":"registerComplete","filters":[{"subprop_type":"event","subprop_key":"EmailVerified","subprop_op":"is","subprop_value":["true"]}]}',<br />    'start': '20210615',<br />    'end': '20210615'<br />}<br /><br />url = 'https://amplitude.com/api/2/events/segmentation'<br /><br />response = requests.get(url, params = params_with_filter, auth = (api_android, secret_android))

And result is:

<Response [400]>
HTTP 400: Bad Request

I was trying several ways to pass data and didn’t provide full listing, but as I mentioned:

without filter clause - it works and I get an json with data

with filter clause - not

MikkoKarvonen

Hi all, just stacked with a small problem.

This piece of code works perfect, but if I uncomment filter clause I got an “HTTP 400: Bad Request”. Same as in documentation, but error =(

params = {<br />    "event_type":"registerComplete", <br />    # "filters": [<br />    #     {<br />    #         "subprop_type": "event",<br />    #         "subprop_key": "EmailVerified",<br />    #         "subprop_op": "is",<br />    #         "subprop_value": ["true"]<br />    #     }<br />    #     ]<br />      }<br /><br />dates = '&start=20210615&end=20210615'<br />url = SEGMENT_URI + json.dumps(params) + dates<br /><br />response = requests.get(url, auth = (api_android, secret_android))

Thanks.

Do you have an event property called EmailVerified under your registerComplete event?

MikkoKarvonen

Another thing to check would be to delete and re-type your quotation marks (“).

They are notorious for getting switched to a wrong version (there are several different versions that look pretty much the same, but are actually different characters) when copy-pasting from one program to another.

Denis Holmes

Hi alex_t , thanks for writing into the Community! Denis here and I’ll be happy to help.

A big thank you to our star repliers Saish Redkar and MikkoKarvonen , you both continue to amaze with your excellent knowledge sharing and insight. I appreciate that massively guys!!

As mentioned by Saish Redkar , I would ensure that that ?e= is added at the end of your base URL. So your base URL might look something like this

url = "https://amplitude.com/api/2/events/segmentation?e=" + json.dumps(params) + dates

Can you ensure that the ?e= is added to your SEGMENT_URI? I would add it there and to the actual params as sometimes that might cause parsing and formatting issues.

As mentioned by MikkoKarvonen , I would ensure that you have written in the double quotations again. These can cause issues when pasting from one place to another.

As Mikko also said, do you have this event registerComplete in your organization? And is it spelled the exact same way with no spaces and camelcase?

Is the property you are filtering on, EmailVerified, also spelled the same way and is an event property? If it is a user property, the subprop_type must be user but if it is an event property, subprop_type of event should work. I have attached a simple event from my own organization that I am hoping can guide you with your instrumentation. I cannot include my keys for safety reason but hopefully you will be able to work with it and get your own working.

params = {    "event_type":"AAA",     "filters":[         {             "subprop_type": "user",             "subprop_key": "City",             "subprop_op": "is",             "subprop_value": ["Amsterdam"]         }]}dates = '&start=20210608&end=20210608'url = "https://amplitude.com/api/2/events/segmentation?e=" + json.dumps(params) + datesresponse = requests.get(url,params=params,auth=("dc07d85f595a149f933f58fa3394e4f6", "5bc9b786c1dd18dc46e530040972d309"))print(response.json())

alex_t If your API call still isn’t working after checking these steps, can you please send me a private message and I will help you out with the API call. Thank you!

Saish Redkar

Hey alex_t ,

Denis Holmes and MikkoKarvonen pretty much cover the additional methods which could help in debugging your issue. Happy to share out a working code snippet via Github if that helps out further.

Denis Holmes

Hi all!

So, we must use a gp: before the event name when we use a custom event. I hope this explains the situation for everyone ! If there are any problems with it, feel free to reply/comment beneath!

Have a great weekend all!

Quick Links

Unanswered Questions

Error in Amplitude React Native SDK - "Cannot set property 'cookie' of undefined"
Hello! In React-Native mobile project we have error: Amplitude Logger [Error]: Failed to set cookie for key: AMP_TEST. Error: Cannot set property 'cookie' of undefined Error Component Stack: ``` The package version is "@amplitude/analytics-react-native": "1.5.1", Steps to Reproduce: * Initialize Amplitude with our API key…
Send IP on native events for first party tracking
We implemented first party tracking using the basic JS SDK on the browser and pointing the payload to our servers like this: amplitude.init(AMPLITUDE_API_KEY, { serverUrl: serverUrl, autocapture: { attribution: { excludeReferrers: [/domain1\.com$/, /domain2\.com$/], }, formInteractions: false, fileDownloads: false, }, });…
Events for an Android background app
My Android app is primarily a background app. Does Amplitude track events for such an app? Please let me know.
Modifed the Change over time retantion graph
here is the referance graph: https://app.amplitude.com/analytics/demo/chart/new/363tk5og In this graph, retention is currently being calculated based on the next day, but I want to analyze it based on the previous day instead. Example: For July 27, we should compare retention against July 26, not July 28. * So for 1-day…
Landing page analysis data table
Hi everybody! I need your help with a client request: my client is used to analyze landing pages performance with the standard report from GA4 and I need to create something similar in Amplitude. What I already have: * session entries grouped by page URL * purchase event calculated as session totals grouped by page URL and…