LogoCloudflare API

D1

d1

Domain types

D1 = { created_at, file_size, name, 4 more... }

The details of the D1 database.

D1

Database

d1.database

Methods

List D1 Databases -> V4PagePaginationArray<{ created_at, name, uuid, 1 more... }>
get/accounts/{account_id}/d1/database

Returns a list of D1 databases.

Get D1 Database -> Envelope<
D1
>
get/accounts/{account_id}/d1/database/{database_id}

Returns the specified D1 database.

Create D1 Database -> Envelope<
D1
>
post/accounts/{account_id}/d1/database

Returns the created D1 database.

Update D1 Database -> Envelope<
D1
>
put/accounts/{account_id}/d1/database/{database_id}

Updates the specified D1 database.

Update D1 Database Partially -> Envelope<
D1
>
patch/accounts/{account_id}/d1/database/{database_id}

Updates partially the specified D1 database.

Delete D1 Database -> Envelope<unknown>
delete/accounts/{account_id}/d1/database/{database_id}

Deletes the specified D1 database.

Query D1 Database -> SinglePage<
QueryResult
>
post/accounts/{account_id}/d1/database/{database_id}/query

Returns the query result as an object.

Raw D1 Database Query -> SinglePage<{ meta, results, success }>
post/accounts/{account_id}/d1/database/{database_id}/raw

Returns the query result rows as arrays rather than objects. This is a performance-optimized version of the /query endpoint.

Export D1 Database As Sql -> Envelope<{ at_bookmark, error, messages, 4 more... }>
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.

Import Sql Into Your D1 Database -> Envelope<{ at_bookmark, error, filename, 6 more... }>
post/accounts/{account_id}/d1/database/{database_id}/import

Generates a temporary URL for uploading an SQL file to, then instructing the D1 to import it and polling it for status updates. Imports block the D1 for their duration.

Domain types

QueryResult = { meta, results, success }