You can schedule a query to be automatically refreshed daily, weekly or monthly. You can also run a refresh from a command line. Note that the options differ on MacOS from what is shown below (for Windows).
On Windows computers, the app uses the Windows Task Scheduler to trigger the refresh. On MacOS computers, it uses the Launch Agents functionality. Since the capabilities differ between the operating systems, the scheduling options differ as well.
Abort after – this number appears for all options. After the specified number of minutes, if the refresh has not completed, the operation will be aborted. The query itself may continue to run in the background for a while, but the process triggering it will abort (the scheduler or command line). Note that most API calls will timeout after about 100 seconds, but queries can issue multiple API calls to get all your data, so increase the default 10 minutes if you are downloading very large amounts of data.
One Time (Windows)
Refresh the file once at the specified time.
Daily Refresh
Weekly Refresh
On Windows, you can pick how often (every 2nd week) and the day of the week (Monday). On MacOS, you can pick the day of the week — it runs every week.
Monthly Refresh
On Windows, you can pick the months (usually all are selected) and days/weeks (Monday of the first week), or the day (1st of the month). On MacOS, you can pick the day of the month — it runs every month.
Remove the Scheduled Refresh
If you want the scheduled refresh to stop, you can remove it.
Command Line
Click the Copy button to copy the command lin string to the clipboard, then paste it into the application you want to use to trigger the refresh.
When the command runs, it will return without an exitcode if successful, or with an exit code if not.
Exit Codes:
0 – normal exit
1 – error
3 – cancelled
4 – query not found