POST /accounts/{account_id}/d1/database/{database_id}/export

Returns a URL where the SQL contents of your D1 can be downloaded. Note: this process may take some time for larger DBs, during which your D1 will be unavailable to serve queries. To avoid blocking your DB unnecessarily, an in-progress export must be continually polled or will automatically cancel.

Servers

Path parameters

Name Type Required Description
account_id String Yes
database_id String Yes

Request headers

Name Type Required Description
Content-Type String Yes The media type of the request body.

Default value: "application/json"

Request body fields

Name Type Required Description
output_format String Yes

Specifies that you will poll this endpoint until the export completes

Possible values:

  • "polling"
current_bookmark String No

To poll an in-progress export, provide the current bookmark (returned by your first polling response)

dump_options Object No
dump_options.no_data Boolean No

Export only the table definitions, not their contents

dump_options.tables[] Array No

Filter the export to just one or more tables. Passing an empty array is the same as not passing anything and means: export all tables.

dump_options.no_schema Boolean No

Export only each table's contents, not its definition

How to start integrating

  1. Add HTTP Task to your workflow definition.
  2. Search for the API you want to integrate with and click on the name.
    • This loads the API reference documentation and prepares the Http request settings.
  3. Click Test request to test run your request to the API and see the API's response.