I'm trying to call the Mixpanel API using a python/flask web app, gather JSON data, and use the WDC to create an extract that will use the "incremental update" every day. Has anyone successfully done something similar? I know zero JS, but can understand vaguely what's going in the json_connector example file.
So far, I've built a flask web app that runs on a secure port on an ec2 server. From there, I can call the Mixpanel API and shove all of the json information onto a webpage URL. I just don't know how to use JS to grab that JSON and create the fieldNames/fieldTypes from the data on the page.
Any help/pointers would be appreciated.
I would check out the Socrata example connector. It implements incremental update and is relatively simple.