from googleapiclient import discovery

project_id = "<project_id>"
sql_api = discovery.build("sqladmin", "v1", cache_discovery=False)
request = sql_api.backupRuns().list(project=project_id, instance="-", maxResults=100)
page = request.execute()
backups = page.get("items", [])
print(f"All in one transaction. Total records: {len(backups)}")
backups = []
next_page = {}
while True:
    request = sql_api.backupRuns().list(project=project_id, instance="-", maxResults=10, **next_page)
    page = request.execute()
    items = page.get("items", [])
    print(f"transaction {next_page}. records: {len(items)}")
    backups.extend(items)
    next_page = page.get("nextPageToken", 0)
    if next_page:
        next_page = {"pageToken": next_page}
    else:
        break
print(f"Multiple transactions. Total records: {len(backups)}")

All in one transaction. Total records: 49
transaction {}. records: 10
transaction {'pageToken': '1715713200000'}. records: 10
transaction {'pageToken': '1715547600000'}. records: 10
transaction {'pageToken': '1715374800000'}. records: 10
transaction {'pageToken': '1712929640988'}. records: 5
Multiple transactions. Total records: 45

All in one transaction. Total records: 49
Multiple transactions. Total records: 48

All in one transaction. Total records: 49
Multiple transactions. Total records: 49