How to connect to live data sources
Please note connecting to live data sources is only available on our Business Pro and Enterprise plans.
The Flourish Live CSV feature
Please note that downloading the HTML for self-hosting is not possible for visualizations created with the Live CSV feature.
Our Live CSV feature allows you to point to a
web-accessible CSV file instead of manually uploading your CSV or Excel file to Flourish. This live CSV file can be hosted on your own server or on third-party services such as Google Sheets.
Once enabled, you will receive the option to "Import from URL" alongside the "Upload data file" and "Upload and merge" options in the Data tab.
- When the "Import from URL" option is selected, you will receive the option to add a URL that links to a CSV.
- Once successfully linked, your data sheet will display greyed out and you won't be able to edit it, as it is being pulled from the live source.
- You can use the "Select columns to visualise" area to select which columns should be used for what part of the visualization. ( You can learn more about adding data and selecting columns here.)
- To edit how often your CSV is pulled through to Flourish, you need to publicly publish your visualization. You will receive the option to automatically update the URL and can supply a republishing interval in seconds. (Please note that the republishing interval settings may be dependent on your tier of pricing plan.)
- Find out more about how to connect to different live data sources in this help doc.
If you add your visualization to a Flourish story, you will receive the same publishing settings.
- ✏️Note: The republishing interval settings will not appear if you are trying to publish your project behind a password (and they will not work for self-hosted projects). We don't store the plain text version of a project password for security reasons, so each time a password protected project is republished you have to re-enter the password - that means it can't be done automatically.
- The Flourish API
Note: the Flourish API is an enterprise-level bolt-on and not available to all customers
The Flourish API allows you dynamically create and edit Flourish visualizations. With the Flourish API you can for example:
- Connect a Flourish visualization to a database or live data feed
- Control Flourish visualizations based on inputs on your webpage
- Make a custom CMS plugin that can generate Flourish charts
- Create Flourish charts as part of R, Tableau, Jupyter or Observable notebooks