database_query

Creates, updates, deletes, gets or lists a database_query resource.

Overview

Name	database_query
Type	Resource
Id	cloudflare.d1.database_query

Fields

The following fields are returned by SELECT queries:

query

Query response

Name	Datatype	Description
errors	array
messages	array
result	array
success	boolean	Whether the API call was successful (true)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
query	select	account_id, database_id		Returns the query result as an object.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
account_id	string	The Cloudflare account ID.
database_id	string	The D1 database ID.

SELECT examples

query

Returns the query result as an object.

SELECT
errors,
messages,
result,
success
FROM cloudflare.d1.database_query
WHERE account_id = '{{ account_id }}' -- required
AND database_id = '{{ database_id }}' -- required
;