In addition to “from and to now,” I would like to further segment the event information from the Mixpanel () API method by time (events contain the “time” property, expressed as a unix timestamp); but, for example, when I specify the "where" parameter, I get an empty answer (see below).
"where" param = 'properties ["time"]> = 1401642000'
I definitely have events that match this. Should this work?
no "where" param:
args = {'from_date': '2014-06-01', 'api_key': 'REDACTED', 'sig': 'REDACTED', 'to_date': '2014-06-04', 'expire': 1402424767}
response = [I get expected events]
'where' param = 'properties ["time"]> = 1401642000'
args = {'from_date': '2014-06-01', 'expire': 1402424767, 'sig': 'REDACTED', 'to_date': '2014-06-04', 'api_key': 'REDACTED', ' where ':' properties ["time"]> = 1401642000 '}
response = [HTTP request completed successfully, but the response is empty]
Same as above, except for the time value in quotation marks:
'where' param = 'properties ["time"]> = "1401642000"'
args = {'from_date': '2014-06-01', 'expire': 1402424767, 'sig': 'REDACTED', 'to_date': '2014-06-04', 'api_key': 'REDACTED ',' where ':' properties [ "time" ] >= "1401642000" '}
response = [HTTP- , ]
cast [ "time" ] :
'' param = 'number (properties [ "time" ]) >= 1401642000'
args = {'from_date': '2014-06-01', 'expire': 1402424767, 'sig': 'REDACTED', 'to_date': '2014-06-04', 'api_key': 'REDACTED ',' where ':' number (properties [ "time" ]) >= 1401642000 '}
response = [HTTP- , ]