How to connect to Mixpanel?

To connect to Mixpanel:

    1. Login to Mixpanel and obtain the API secret. 

    2, In the Rest Datasource setup page, supply the User Id and password as the API secret

    3. Set the Rest Host as https://mixpanel.com/api/2.0/

    4. Save the datasource. 

To call into an MixPanel API: 

    1. From the datasource setup above, create a new query. Spcify the end point. Example: events

     2. Pass in the relevant URL parameters. Example: 

event=["some event"]&type=general&from_date=2018-05-28&to_date=2018-05-28&unit=minute

(or to supply dynamic dates: event=["some event"]&type=general&from_date={$c9_today-1d:yyyy-MM-dd}&to_date={$c9_today:yyyy-MM-dd}&unit=minute

     3. Use Cloud9QL or interact with the results to transform the results appropriately.