ProjectService
- GETGet v1* iampolicies:batchget
- GETGet v1projects
- POSTPost v1projects
- GETGet v1projects 1
- DELDelete v1projects
- PATCHPatch v1projects
- POSTPost v1projects webhooks :removewebhook
- POSTPost v1projects webhooks :updatewebhook
- POSTPost v1projects :addwebhook
- GETGet v1projects :getiampolicy
- POSTPost v1projects :setiampolicy
- POSTPost v1projects :testwebhook
- POSTPost v1projects :undelete
- POSTPost v1projects:search
ActuatorService
AuditLogService
AuthService
OrgPolicyService
- GETGet v1environments policies
- POSTPost v1environments policies
- GETGet v1environments policies 1
- DELDelete v1environments policies
- PATCHPatch v1environments policies
- GETGet v1instances databases policies
- POSTPost v1instances databases policies
- GETGet v1instances databases policies 1
- DELDelete v1instances databases policies
- PATCHPatch v1instances databases policies
- GETGet v1instances policies
- POSTPost v1instances policies
- GETGet v1instances policies 1
- DELDelete v1instances policies
- PATCHPatch v1instances policies
- GETGet v1policies
- POSTPost v1policies
- GETGet v1policies 1
- DELDelete v1policies
- PATCHPatch v1policies
- GETGet v1projects policies
- POSTPost v1projects policies
- GETGet v1projects policies 1
- DELDelete v1projects policies
- PATCHPatch v1projects policies
IdentityProviderService
InstanceService
- GETGet v1instances
- POSTPost v1instances
- GETGet v1instances 1
- DELDelete v1instances
- PATCHPatch v1instances
- POSTPost v1instances :adddatasource
- POSTPost v1instances :databases
- POSTPost v1instances :removedatasource
- POSTPost v1instances :sync
- POSTPost v1instances :undelete
- PATCHPatch v1instances :updatedatasource
- POSTPost v1instances:batchsync
- POSTPost v1instances:batchupdate
DatabaseService
- GETGet v1instances databases
- GETGet v1instances databases 1
- PATCHPatch v1instances databases
- GETGet v1instances databases changelogs
- GETGet v1instances databases changelogs 1
- POSTPost v1instances databases changelogs :diffschema
- GETGet v1instances databases metadata
- GETGet v1instances databases schema
- GETGet v1instances databases schemastring
- GETGet v1instances databases secrets
- DELDelete v1instances databases secrets
- PATCHPatch v1instances databases secrets
- POSTPost v1instances databases :diffschema
- POSTPost v1instances databases :sync
- GETGet v1instances databases:batchget
- POSTPost v1instances databases:batchsync
- POSTPost v1instances databases:batchupdate
- GETGet v1projects databases
- GETGet v1projects databases:batchget
- GETGet v1workspaces databases
DatabaseCatalogService
RevisionService
SQLService
- POSTPost v1instances databases :export
- POSTPost v1instances databases :query
- POSTPost v1instances :export
- POSTPost v1instances :query
- POSTPost v1projects rollouts stages :export
- POSTPost v1projects rollouts :export
- POSTPost v1queryhistories:search
- POSTPost v1schemadesign:diffmetadata
- POSTPost v1sqlaicompletion
- POSTPost v1sqlcheck
- POSTPost v1sqlpretty
- GETGet v1:adminexecute
InstanceRoleService
ChangelistService
DatabaseGroupService
IssueService
- GETGet v1projects issues
- POSTPost v1projects issues
- GETGet v1projects issues 1
- PATCHPatch v1projects issues
- GETGet v1projects issues issuecomments
- POSTPost v1projects issues :approve
- POSTPost v1projects issues :comment
- PATCHPatch v1projects issues :comment
- POSTPost v1projects issues :reject
- POSTPost v1projects issues :request
- POSTPost v1projects issues:batchupdatestatus
- POSTPost v1projects issues:search
PlanService
ReleaseService
RolloutService
- GETGet v1projects rollouts
- POSTPost v1projects rollouts
- GETGet v1projects rollouts 1
- GETGet v1projects rollouts stages tasks taskruns
- GETGet v1projects rollouts stages tasks taskruns 1
- GETGet v1projects rollouts stages tasks taskruns log
- GETGet v1projects rollouts stages tasks taskruns session
- POSTPost v1projects rollouts stages tasks taskruns :previewrollback
- POSTPost v1projects rollouts stages tasks taskruns:batchcancel
- POSTPost v1projects rollouts stages tasks:batchrun
- POSTPost v1projects rollouts stages tasks:batchskip
- POSTPost v1projects :previewrollout
SheetService
ReviewConfigService
SubscriptionService
UserService
WorksheetService
SQLService
Post v1instances databases :query
POST
/
v1
/
instances
/
{instance}
/
databases
/
{database}
:query
Copy
Ask AI
{
"results": [
{
"columnNames": [
"<string>"
],
"columnTypeNames": [
"<string>"
],
"rows": [
{
"values": [
{
"nullValue": "NULL_VALUE",
"boolValue": true,
"bytesValue": "<string>",
"doubleValue": 123,
"floatValue": 123,
"int32Value": 123,
"int64Value": "<string>",
"stringValue": "<string>",
"uint32Value": 123,
"uint64Value": "<string>",
"valueValue": "<any>",
"timestampValue": {
"googleTimestamp": "2023-11-07T05:31:56Z",
"accuracy": 123
},
"timestampTzValue": {
"googleTimestamp": "2023-11-07T05:31:56Z",
"zone": "<string>",
"offset": 123,
"accuracy": 123
}
}
]
}
],
"rowsCount": "<string>",
"masked": [
true
],
"sensitive": [
true
],
"error": "<string>",
"latency": "<string>",
"statement": "<string>",
"postgresError": {
"severity": "<string>",
"code": "<string>",
"message": "<string>",
"detail": "<string>",
"hint": "<string>",
"position": 123,
"internalPosition": 123,
"internalQuery": "<string>",
"where": "<string>",
"schemaName": "<string>",
"tableName": "<string>",
"columnName": "<string>",
"dataTypeName": "<string>",
"constraintName": "<string>",
"file": "<string>",
"line": 123,
"routine": "<string>"
},
"allowExport": true,
"messages": [
{
"level": "LEVEL_UNSPECIFIED",
"content": "<string>"
}
]
}
]
}
Body
application/json
Response
200
application/json
OK
The response is of type object
.
Was this page helpful?
Copy
Ask AI
{
"results": [
{
"columnNames": [
"<string>"
],
"columnTypeNames": [
"<string>"
],
"rows": [
{
"values": [
{
"nullValue": "NULL_VALUE",
"boolValue": true,
"bytesValue": "<string>",
"doubleValue": 123,
"floatValue": 123,
"int32Value": 123,
"int64Value": "<string>",
"stringValue": "<string>",
"uint32Value": 123,
"uint64Value": "<string>",
"valueValue": "<any>",
"timestampValue": {
"googleTimestamp": "2023-11-07T05:31:56Z",
"accuracy": 123
},
"timestampTzValue": {
"googleTimestamp": "2023-11-07T05:31:56Z",
"zone": "<string>",
"offset": 123,
"accuracy": 123
}
}
]
}
],
"rowsCount": "<string>",
"masked": [
true
],
"sensitive": [
true
],
"error": "<string>",
"latency": "<string>",
"statement": "<string>",
"postgresError": {
"severity": "<string>",
"code": "<string>",
"message": "<string>",
"detail": "<string>",
"hint": "<string>",
"position": 123,
"internalPosition": 123,
"internalQuery": "<string>",
"where": "<string>",
"schemaName": "<string>",
"tableName": "<string>",
"columnName": "<string>",
"dataTypeName": "<string>",
"constraintName": "<string>",
"file": "<string>",
"line": 123,
"routine": "<string>"
},
"allowExport": true,
"messages": [
{
"level": "LEVEL_UNSPECIFIED",
"content": "<string>"
}
]
}
]
}
Assistant
Responses are generated using AI and may contain mistakes.