gcp.sql.backup.list

List Cloud SQL backup runs for an instance and surface the latest successful one.

List Cloud SQL backup runs without mutating resources.

Overview

Property	Value
Workflow type	Linear
Library	Base-gcp
Version	1.0

Input Schema

Field	Type	Required	Default	Description
connection_uuid	uuid	Yes	—	GCP CloudConnection UUID.
project_id	string	No	—	GCP project override.
region	string	No	—	Cloud SQL region used for credential scoping.
instance_id	string	Yes	—	Cloud SQL instance id.
page_size	integer	No	—	Provider page size.
max_results	integer	No	—	Maximum backup runs to collect across pages.
only_successful	boolean	No	—	Return only backup runs whose status is SUCCESSFUL.

Output Schema

Field	Type	Required	Default	Description
connection_uuid	uuid	No	—	Echoed connection UUID.
project_id	string	No	—	Effective project.
region	string	No	—	Cloud SQL region used for credential scoping.
instance_id	string	No	—	Cloud SQL instance id.
page_size	integer	No	—	Provider page size.
max_results	integer	No	—	Maximum backup runs to collect across pages.
only_successful	boolean	No	—	Return only backup runs whose status is SUCCESSFUL.
backup_runs	list	No	—	Sanitized backup run records.
backup_run_count	integer	No	—	Number of backup runs returned.
latest_successful_backup_run_id	string	No	—	Backup run id of the newest SUCCESSFUL run; feed to gcp.sql.backup.restore.
latest_successful_backup	json	No	—	Newest SUCCESSFUL backup run record.
failure_reason	string	No	—	Human-readable failure reason.
failed_step	string	No	—	Failed logical step.
failed_layer	json	No	—	Engine failed layer.
failed_at_state	string	No	—	State where failure occurred.
error	string	No	—	Error message.
error_type	string	No	—	Error class.

States

State	Initial	Terminal	Success	Auto-advance	Description
pending	Yes	No	—	preflight	—
listing	No	No	—	complete	—
preflighting	No	No	—	execute	—
completed	No	Yes	Yes	—	—
failed	No	Yes	No	—	—

State Diagram

Transitions

From	Action	To	Description
pending	preflight	preflighting	—
preflighting	execute	listing	—
listing	complete	completed	—
* (any state)	fail	failed	—

API Usage

POST /api/workflows/start
Content-Type: application/json

{
  "workflow_type": "gcp.sql.backup.list",
  "initial_data": {
    "connection_uuid": "value",
    "instance_id": "value"
  }
}