deploymentIdinteger required
lastRunAtstring date-time nullable
When the last run finished. null before the first.
lastSuccessAtstring date-time nullable
When the last successful run finished. null if none has succeeded.
ownerUserIdinteger nullable
The accountable user, whose Google account writes the sheet. null once that user has been deleted.
reportIdinteger nullable
The delivered report. null once that report has been deleted.
reportNamestring nullable
Name of the delivered report. null once that report has been deleted.
reportPublicIdstring nullable
Public id of the delivered report. null once that report has been deleted.
reportWorkbookIdinteger nullable
Workbook holding the delivered report. null once that report has been deleted.
runAsUserIdinteger nullable
The user whose data access the query runs with. null once that user has been deleted.
runningSincestring date-time nullable
When the run still in progress started. null while no run is going.
sheetTitlestring nullable
Current title of the destination tab, read from Google at most every few minutes. null for a new_sheet delivery, or before its title has been read.
spreadsheetTitlestring nullable
Title of the destination spreadsheet, read from Google at most every few minutes and by each run. null before then.
status'active' | 'failing' | 'needs_reconnect' | 'no_sheet_access' | 'orphaned' required
writeMode'overwrite' | 'append' | 'new_sheet' required