search

ploner / RMixpanel

RMixpanel - Mixpanel API client package for R
Other
18 stars 6 forks source link

I am unable to pull event data for each profile #7

Open FCALVODBAMAF opened 5 years ago

FCALVODBAMAF commented 5 years ago

Hi, Thanks for developing this, its actually pretty useful! I am trying to pull event data for each profile in my Mixpanel project, however I keep getting an error message.

I am able to authenticate correctly into Mixpanel, and pull profile information with mixpanelGetProfiles(account)

Now, I am trying to pull event data for each profile (for this example, just for the first profile) by using the following command: profileIDs = profiles[, "distinct_id"] events_profile = mixpanelGetEventsForProfiles(account, profileIDs[1], from_date=2018-11-01, to_date=2018-12-01)

but I get the following text in return: ## Download https://mixpanXXXXXXXXXXX2.0/stream/query?from_date=2010-01-01&to_date=2020-01-01&distinct_ids=%5B%22165790f3f08375-0f3c30b4faed45-772b1906-5b524-165790f3f09c0%22%5D&... parse data... $request [1] "/api/2.0/stream/query?from_date=2010-01-01&to_date=2020-01-01&distinct_ids=%5B%22165790f3f08375-0f3c30b4faed45-772b1906-5b524-165790f3f09c0%22%5D&" $error [1] "Date range exceeds 365 days into the past"

I also tried running the same command but without the from and to date, and still get the same return

Would you be able to let me know what the issue is, or if there is something I am doing wrong!

Thanks, F.A.Calvo

FCALVODBAMAF commented 5 years ago

Hi, I wanted to update this issue. I managed to get event data by using the following command:

Event = mixpanelGetEventsForProfiles(account, distinctIDs = c("test@testmail.org"), from = "2018-11-1", to = "2018-12-01")

However, when I run this same query for another distinctID, for example:

Event_sofia = mixpanelGetEventsForProfiles(account, distinctIDs = c("sofia.test@testmail.org"), from = "2018-11-1", to = "2018-12-01")

I get the following error: Error: lexical error: invalid character inside string. yments for your loans, credit cards, and other de (right here) ------^

Please advice. Saludos,

F.A.Calvo