Bold BI dashboard designer supports to connect live file(CSV/JSON/XML/Excel) using either web services like
Microsoft SharePoint or using
Once connected the account, select the account name and click Connect button.
In the Data source text box, enter the name for data source and select a live file(CSV/JSON/XML/Excel) to connect.
Click Refresh Settings button to update your data periodically. This will automatically trigger a call for the API configured in the data source to keep the data up to date.
Choose the schema from the tree view to design your dashboard and click Connect button.
Now the design canvas is open with select table schema. Drag and drop the table in design canvas and save your data source.
If the live data is in CSV/JSON/XML format in your REST API, then connect the API in designer using Web API connection type.
In the Data Format combo box select the format (CSV, JSON, XML) based on the response of your provided API.
To update your data automatically, click Refresh Settings button.
Now you can connect that data source to design the dashboard.