Access a refresh schedule's frequency, which specifies how often and when to refresh.
Only use this class with data that's connected to a database.
To see the next time this refresh schedule is scheduled to run, use DataSourceRefreshSchedule.getTimeIntervalOfNextRun()
.
To update, use DataSourceRefreshSchedule.setFrequency(newFrequency)
.
Methods
Method | Return type | Brief description |
---|---|---|
getDaysOfTheMonth() | Integer[] | Gets the days of the month as numbers (1-28) on which to refresh the data source. |
getDaysOfTheWeek() | Weekday[] | Gets the days of the week on which to refresh the data source. |
getFrequencyType() | FrequencyType | Gets the frequency type. |
getStartHour() | Integer | Gets the start hour (as a number 0-23) of the time interval during which the refresh schedule runs. |
Detailed documentation
getDaysOfTheMonth()
Gets the days of the month as numbers (1-28) on which to refresh the data source. Only applies if frequency type is monthly.
Return
Integer[]
— The days of the month on which to refresh.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getDaysOfTheWeek()
Gets the days of the week on which to refresh the data source. Only applies if the frequency type is weekly.
Return
Weekday[]
— The days of the week on which to refresh.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getFrequencyType()
Gets the frequency type.
Return
FrequencyType
— The frequency type.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getStartHour()
Gets the start hour (as a number 0-23) of the time interval during which the refresh schedule runs. For example, if the start hour is 13 and the time interval's duration is 4 hours, then the data source is refreshed between 1 p.m. and 5 p.m. The hour is in the timezone of the spreadsheet.
Return
Integer
— The start hour.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets