Is there a way to sync GeoJSON files to my cartoDB table?
If this is not yet supported, what would be the best way of implementing this feature (syncing the data frequently with the existing cartoDB table) myself?
Stack Exchange network consists of 181 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.Visit Stack Exchange
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
It might be worthwhile looking at the CartoDB Import API. You can set up syncing a file from a URL with a simple cURL command.
Check out the documentation and the example at this link. It may help get you started down the right track.
While the import API is one possible method, it looks like you can sync GeoJSON if it is hosted on the web somewhere. This method was outlined on the Fulcrum guides and can be seen here, read the section "Creating A Synced CartoDB Table".
Steps are as follows.
I used GeoJSON from Mapbox to test and can be found here