sql.instances.list
GET {{baseUrl}}/sql/v1beta4/projects/:project/instances?filter=<string>&maxResults=<integer>&pageToken=<string>&$.xgafv=<string>&access_token=<string>&alt=<string>&callback=<string>&fields=<string>&key=<string>&oauth_token=<string>&prettyPrint=<boolean>"aUser=<string>&upload_protocol=<string>&uploadType=<string>
Lists instances under a given project.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
filter | string | A filter expression that filters resources listed in the response. The expression is in the form of field:value. For example, 'instanceType:CLOUD_SQL_INSTANCE'. Fields can be nested as needed as per their JSON representation, such as 'settings.userLabels.auto_start:true'. Multiple filter queries are space-separated. For example. 'state:RUNNABLE instanceType:CLOUD_SQL_INSTANCE'. By default, each expression is an AND expression. However, you can include AND and OR expressions explicitly. | |
maxResults | string | The maximum number of results to return per response. | |
pageToken | string | A previously-returned page token representing part of the larger set of results to view. | |
$.xgafv | string | V1 error format. | |
access_token | string | OAuth access token. | |
alt | string | Data format for response. | |
callback | string | JSONP | |
fields | string | Selector specifying which fields to include in a partial response. | |
key | string | API key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token. | |
oauth_token | string | OAuth 2.0 token for the current user. | |
prettyPrint | string | Returns response with indentations and line breaks. | |
quotaUser | string | Available to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters. | |
upload_protocol | string | Upload protocol for media (e.g. "raw", "multipart"). | |
uploadType | string | Legacy upload protocol for media (e.g. "media", "multipart"). |
RESPONSES
status: OK
{"items":[{"backendType":"SQL_BACKEND_TYPE_UNSPECIFIED","connectionName":"sed ipsum dolor velit","currentDiskSize":"ut quis velit laboris labore","databaseVersion":"MYSQL_5_6","diskEncryptionConfiguration":{"kind":"dolore esse","kmsKeyName":"reprehenderit "},"diskEncryptionStatus":{"kind":"exercitation Lorem in","kmsKeyVersionName":"dolor cupidatat et in"},"etag":"deserunt nu","failoverReplica":{"available":false,"name":"in eiusmod esse"},"gceZone":"aute labore nisi anim","instanceType":"SQL_INSTANCE_TYPE_UNSPECIFIED","ipAddresses":[{"ipAddress":"pariatur culpa eu elit in","timeToRetire":"eiusmod","type":"PRIVATE"},{"ipAddress":"ut consectetur nulla exercitation qui","timeToRetire":"ex non","type":"PRIVATE"}],"ipv6Address":"cillum ad dolor","kind":"ipsum in aliqua fugiat","masterInstanceName":"sed consectetur","maxDiskSize":"commodo magna","name":"sed officia","onPremisesConfiguration":{"caCertificate":"sunt ea","clientCertificate":"esse nulla veniam","clientKey":"mollit dolor ex","dumpFilePath":"reprehenderit sint fugiat commodo officia","hostPort":"anim voluptate","kind":"in sunt irure","password":"sint eiusmod minim id in","username":"dolor sit"},"project":"aliqua sunt","region":"consequat","replicaConfiguration":{"failoverTarget":true,"kind":"ex minim","mysqlReplicaConfiguration":{"caCertificate":"amet aliqua ven","clientCertificate":"cupidatat anim proident","clientKey":"offic","connectRetryInterval":67430968,"dumpFilePath":"irure Excepteur","kind":"ipsum et ea","masterHeartbeatPeriod":"velit adipisicing ipsum ad","password":"amet elit adipisicing","sslCipher":"dolor irure","username":"officia","verifyServerCertificate":false}},"replicaNames":["proident laboris cil","do adipisicing veniam elit"],"rootPassword":"fugiat magna","scheduledMaintenance":{"canDefer":true,"canReschedule":true,"startTime":"occaecat minim do"},"selfLink":"incididunt consectetur dolore aliquip","serverCaCert":{"cert":"anim laborum","certSerialNumber":"Lorem pariatur non minim est","commonName":"irure","createTime":"dolor in id","expirationTime":"adipisicing qui esse enim culpa","instance":"eu Lorem enim","kind":"nisi labor","selfLink":"ut deserunt dolor nisi magna","sha1Fingerprint":"in sit"},"serviceAccountEmailAddress":"cillum veniam eu ullamco","settings":{"activationPolicy":"ON_DEMAND","activeDirectoryConfig":{"domain":"in incididunt enim magna labore","kind":"veniam consectetur"},"authorizedGaeApplications":["tempor dolore et conse","ad ex nostrud dolore Excepteur"],"availabilityType":"ZONAL","backupConfiguration":{"binaryLogEnabled":false,"enabled":false,"kind":"in","location":"ullamco fugiat Lorem","pointInTimeRecoveryEnabled":true,"replicationLogArchivingEnabled":false,"startTime":"culpa pariatur"},"collation":"aliquip voluptate enim","crashSafeReplicationEnabled":false,"dataDiskSizeGb":"non irure q","dataDiskType":"OBSOLETE_LOCAL_SSD","databaseFlags":[{"name":"ut cons","value":"incididunt amet dolore sit"},{"name":"occaecat ex non","value":"ipsum fugiat ullamco incididunt reprehenderit"}],"databaseReplicationEnabled":true,"denyMaintenancePeriods":[{"endDate":"id ipsum","startDate":"sint non","time":"enim labore nulla"},{"endDate":"et sit ad","startDate":"sint","time":"eu eiusm"}],"ipConfiguration":{"authorizedNetworks":[{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}],"ipv4Enabled":false,"privateNetwork":"mollit dolore irure","requireSsl":false},"kind":"incididunt labore aliqua Ut","locationPreference":{"followGaeApplication":"laboris fugiat","kind":"ullamco est commodo labore","zone":"eu enim dolor dolore"},"maintenanceWindow":{"day":-95303063,"hour":-13532454,"kind":"non quis nulla adipisicing","updateTrack":"stable"},"pricingPlan":"SQL_PRICING_PLAN_UNSPECIFIED","replicationType":"SQL_REPLICATION_TYPE_UNSPECIFIED","settingsVersion":"non","storageAutoResize":false,"storageAutoResizeLimit":"Duis Lorem dolor","tier":"ullamco culpa ipsum","userLabels":{}},"state":"RUNNABLE","suspensionReason":["OPERATIONAL_ISSUE","BILLING_ISSUE"]},{"backendType":"SQL_BACKEND_TYPE_UNSPECIFIED","connectionName":"nostrud laboris officia minim","currentDiskSize":"ut proident","databaseVersion":"SQLSERVER_2017_EXPRESS","diskEncryptionConfiguration":{"kind":"Ut in cillum aute","kmsKeyName":"quis mollit"},"diskEncryptionStatus":{"kind":"nisi ","kmsKeyVersionName":"do culpa aliqua"},"etag":"amet voluptate sunt occaecat","failoverReplica":{"available":false,"name":"pariatur minim"},"gceZone":"cillum","instanceType":"CLOUD_SQL_INSTANCE","ipAddresses":[{"ipAddress":"dolore sint","timeToRetire":"in sint","type":"PRIMARY"},{"ipAddress":"pariatur enim dolor","timeToRetire":"sint tempor","type":"SQL_IP_ADDRESS_TYPE_UNSPECIFIED"}],"ipv6Address":"nostrud","kind":"aute proident fugiat dolore","masterInstanceName":"velit laboris cupida","maxDiskSize":"ipsum","name":"irure eiusmod","onPremisesConfiguration":{"caCertificate":"nostrud","clientCertificate":"Lorem","clientKey":"Excepteur sunt ad","dumpFilePath":"irure sed aliquip labore","hostPort":"laboris irure consequat","kind":"sed aliquip labore","password":"amet Duis id","username":"esse sed dolor laborum"},"project":"Excepteur est aliquip","region":"commodo proident eiusmod ad","replicaConfiguration":{"failoverTarget":true,"kind":"voluptate in","mysqlReplicaConfiguration":{"caCertificate":"ad sunt cillum laboris ullamco","clientCertificate":"nisi adipisicing ven","clientKey":"et ad","connectRetryInterval":13578384,"dumpFilePath":"tempor pariatur in ipsum id","kind":"consectetur","masterHeartbeatPeriod":"commodo eu esse fugiat","password":"tempor aliquip Ut a","sslCipher":"aute mollit","username":"ut","verifyServerCertificate":false}},"replicaNames":["Duis nostrud adipisicing est","ad ullamco sed aliqua"],"rootPassword":"irure est qui non consequat","scheduledMaintenance":{"canDefer":false,"canReschedule":true,"startTime":"cillum sed aute elit incididunt"},"selfLink":"Ut deserunt esse nostrud","serverCaCert":{"cert":"ut dolore eu ad irure","certSerialNumber":"aliquip magna dolor esse Excepteur","commonName":"sit ","createTime":"adipisicing consequat","expirationTime":"ullamco et exercitation adipisicing","instance":"proident laboris culpa","kind":"no","selfLink":"fugiat Duis","sha1Fingerprint":"mollit cillum velit nulla"},"serviceAccountEmailAddress":"labore ad proident labori","settings":{"activationPolicy":"SQL_ACTIVATION_POLICY_UNSPECIFIED","activeDirectoryConfig":{"domain":"consectetur","kind":"anim qui culpa"},"authorizedGaeApplications":["consectetur sit","velit veniam exer"],"availabilityType":"REGIONAL","backupConfiguration":{"binaryLogEnabled":false,"enabled":true,"kind":"ullamco ea qui ut","location":"Excepteur qui","pointInTimeRecoveryEnabled":true,"replicationLogArchivingEnabled":true,"startTime":"ut"},"collation":"aute cu","crashSafeReplicationEnabled":true,"dataDiskSizeGb":"voluptate laborum","dataDiskType":"PD_HDD","databaseFlags":[{"name":"pariatur dolor nulla","value":"ea Excepteur amet in"},{"name":"consequat ea","value":""}],"databaseReplicationEnabled":false,"denyMaintenancePeriods":[{"endDate":"ex ut esse","startDate":"nulla consectetur sint","time":"ullamco sint magna"},{"endDate":"est dolor exercitation esse","startDate":"aute voluptate","time":"ad"}],"ipConfiguration":{"authorizedNetworks":[{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}],"ipv4Enabled":true,"privateNetwork":"ex Duis magna irure velit","requireSsl":false},"kind":"Lorem","locationPreference":{"followGaeApplication":"non aliqua culpa sunt consequat","kind":"labore consectetur","zone":"in ad deserunt"},"maintenanceWindow":{"day":-48021734,"hour":95190391,"kind":"Lorem ipsum","updateTrack":"stable"},"pricingPlan":"SQL_PRICING_PLAN_UNSPECIFIED","replicationType":"SYNCHRONOUS","settingsVersion":"quis in commodo aute","storageAutoResize":true,"storageAutoResizeLimit":"deserunt ","tier":"in ad dolor","userLabels":{}},"state":"MAINTENANCE","suspensionReason":["BILLING_ISSUE","SQL_SUSPENSION_REASON_UNSPECIFIED"]}],"kind":"ipsum sint commodo culpa","nextPageToken":"dolor eu dolor in","warnings":[{"code":"REGION_UNREACHABLE","message":"adipisicing fugiat laborum"},{"code":"REGION_UNREACHABLE","message":"proident nulla minim"}]}