How to Import Data or Tables via URL

You may wish to import data and tables via URL when you want the data to update automatically or on a schedule with whatever data is at the said URL.

Requirements

If you want Displayr to download fresh data or tables when it loads your document, then you need to provide a URL (web address) that immediately downloads the file.

• Your URL should not need a password and should be made accessible to anyone with the link.
• Your URL should immediately download the file when you paste it into a fresh copy of your web browser, leaving the web page completely blank.
• If importing data with multiple sheets, i.e., Excel or CSV, only the first sheet will be imported unless you specify the exact sheet in your URL.

Method - Find your URL

While not all cloud storage solutions will offer direct download links, the following guidance should be noted:

• For Dropbox, the direct download link will be in the format of https://www.dropbox.com/s/random-string/filename.xlsx?dl=1. See here for further details. (Note that Dropbox URLs will show a web page, but Displayr uses a Dropbox-specific trick to make it work anyway.)
• The Box.com free personal account doesn't provide a direct download link, but paid accounts do.
• For OneDrive (personal), locate the file in OneDrive in your browser, click the Embed button, and then change embed to download in the URL, which shows at the top of your browser.
• For Office 365 SharePoint (OneDrive) the direct download link is provided when the user creates a link.
• For Google Drive (personal), the direct link is created by https://drive.google.com/uc?export=download&id=FILE_ID where fileID is obtained from the Link to Share dialog.
• For Google Sheets, you will need to click the Share button and set General access to Anyone with the link. The URL will be in the format of https://docs.google.com/spreadsheets/d/worksheet_name. In order to force a direct download, append "/export?format=csv" to the URL. You can also specify a sheet by adding "&gid=id" from the sheet's URL.
• For Google Forms, the data will either be saved in Google Drive by default or else ensure you have first linked the responses to Google Sheets via Responses > Create a new spreadsheet or Select existing spreadsheet.

Method - Import your data

1. Select Data Sources > Plus (+) > Cloud Sources > URL.

2. Enter the URL where the data is stored.

3. Click OK.

If you wish to manually update the URL ahead of the automatic refresh, simply select your data file in Data Sources and then click Refresh > URL > OK from Properties .

Note, if your URL becomes invalid or permissions change, the document will be unable to open due to this data set not being downloadable. If this occurs, click Update from Properties and enter a new URL or select a different way to import your data.

Automatically update your data

If you want to automatically pull in updated data from a URL, you can set up a Schedule. You can view, update, or add a schedule to your data set from Properties when your data set is selected.

See How to Set Up Schedules in Displayr for more information and details about how to set up a schedule to automatically update your data.

Once you set up a schedule, you will need to make sure you connect the data set to a schedule. You can check this either in Properties or by going to the Schedules panel and seeing the data sets and objects included in the schedule.

Next

Once you've imported your data, it's always a good idea to Check Your Data.

Displayr Outbound IP Address