Cloudflare API | D1 › Database › Import Sql Into Your D1 Database

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.

Get D1 Database -> Envelope<

get/accounts/{account_id}/d1/database/{database_id}

Returns the specified D1 database.

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.

Security

The preferred authorization scheme for interacting with the Cloudflare API. Create a token.

Example: Authorization: Bearer Sn3lZJTBX6kkg7OdcBUAxOO963GEIyGQqnFTOFYY

Parameters

account_id: string

Account identifier tag.

database_id: string

Response fields

errors: Array<

ResponseInfo

messages: Array<

ResponseInfo

result: { at_bookmark, error, filename, 6 more... }

success: true

Whether the API call was successful

Request example

curl https://api.cloudflare.com/client/v4/accounts/$ACCOUNT_ID/d1/database/$DATABASE_ID/import \
    -H 'Content-Type: application/json' \
    -H "X-Auth-Email: $CLOUDFLARE_EMAIL" \
    -H "X-Auth-Key: $CLOUDFLARE_API_KEY" \
    -d '{
      "action": "init",
      "etag": "etag"
    }'

200Example

{
  "errors": [
    {
      "code": 1000,
      "message": "message"
    }
  ],
  "messages": [
    {
      "code": 1000,
      "message": "message"
    }
  ],
  "result": {
    "at_bookmark": "at_bookmark",
    "error": "error",
    "filename": "filename",
    "messages": [
      "string"
    ],
    "result": {
      "final_bookmark": "final_bookmark",
      "meta": {
        "changed_db": true,
        "changes": 0,
        "duration": 0,
        "last_row_id": 0,
        "rows_read": 0,
        "rows_written": 0,
        "size_after": 0
      },
      "num_queries": 0
    },
    "status": "complete",
    "success": true,
    "type": "import",
    "upload_url": "upload_url"
  },
  "success": true
}

List D1 Databases -> V4PagePaginationArray<{ created_at, name, uuid, 1 more... }>

get/accounts/{account_id}/d1/database

Returns a list of D1 databases.

Query D1 Database -> Envelope<Array<

QueryResult

post/accounts/{account_id}/d1/database/{database_id}/query

Returns the query result as an object.

Raw D1 Database Query -> Envelope<Array<{ 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.

Domain types

QueryResult = { meta, results, success }