client.reports.put_sql_archive
A method of the Reports endpoint.
- put_sql_archive(id: int, status: bool) Response
Update the archive status of this object
API URL:
PUT /reports/sql/{id}/archiveimport civis client = civis.APIClient() response = client.reports.put_sql_archive(...)
- Parameters:
- idint
The ID of the object.
- statusbool
The desired archived status of the object.
- Returns:
civis.Response- idint
The ID of this report.
- namestr
The name of the report.
- user
civis.Response - idint
The ID of this user.
- namestr
This user’s name.
- usernamestr
This user’s username.
- initialsstr
This user’s initials.
- onlinebool
Whether this user is online.
- user
- created_atstr (time)
The creation time for this report.
- updated_atstr (time)
The last updated at time for this report.
- typestr
The type of the report. One of: ReportTypes::HTML, ReportTypes::Tableau, ReportTypes::ShinyApp, ReportTypes::SQL, ReportTypes::QuickAnalysis, ReportTypes::QuickDashboard
- descriptionstr
The user-defined description of the report.
- my_permission_levelstr
Your permission level on the object. One of “read”, “write”, or “manage”.
- archivedbool
The archival status of the requested item(s).
- configstr
The configuration of the report visualization.
- query
civis.Response - idint
The query ID.
- databaseint
The database ID.
- sqlstr
The SQL to execute.
- credentialint
The credential ID.
- result_rowsList[List]
A preview of rows returned by the query.
- result_columnsList[str]
A preview of columns returned by the query.
- errorstr
The error message for this run, if present.
- started_atstr (date-time)
The start time of the last run.
- finished_atstr (date-time)
The end time of the last run.
- statestr
The state of the last run. One of idle, pending, scheduled, queued, running, succeeded, failed or cancelled.
- running_as
civis.Response - idint
The ID of this user.
- namestr
This user’s name.
- usernamestr
This user’s username.
- initialsstr
This user’s initials.
- onlinebool
Whether this user is online.
- running_as
- query