POST
/
v1
/
instances
/
{instance}
/
databases
/
{database}
:export
{
  "content": "<string>"
}

Path Parameters

​
instance
string
required

The instance id.

​
database
string
required

The database id.

Body

application/json
​
name
string
required

The name is the resource name to execute the export against. Format: instances/{instance}/databases/{database} Format: instances/{instance} Format: projects/{project}/rollouts/{rollout} Format: projects/{project}/rollouts/{rollout}/stages/{stage}

​
statement
string

The SQL statement to execute.

​
limit
integer

The maximum number of rows to return.

​
format
enum<string>

The export format.

Available options:
FORMAT_UNSPECIFIED,
CSV,
JSON,
SQL,
XLSX
​
admin
boolean

The admin is used for workspace owner and DBA for exporting data from SQL Editor Admin mode. The exported data is not masked.

​
password
string

The zip password provide by users.

​
dataSourceId
string

The id of data source. It is used for querying admin data source even if the instance has read-only data sources. Or it can be used to query a specific read-only data source.

​
schema
string

The default schema to search objects. Equals to the current schema in Oracle and search path in Postgres.

Response

OK

​
content
string<bytes>

The export file content.