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.