Actions7
- Document & Key-Value Actions
- Search Actions
Document & Key-Value → Query
AI-generatedSummary
Executes SQL++ queries against a Couchbase bucket to retrieve or manipulate documents.
Inputs
- couchbaseBucket — The Couchbase bucket to query. Optional for this operation; if omitted, the query uses the default context.
- couchbaseScope — The Couchbase scope to use for the query. Optional; only applies if a bucket is selected.
- query (required) — The SQL++ query string to execute (e.g., SELECT * FROM bucket WHERE condition).
Output shape
a list of items, each containing query results as values.
Returns query rows directly; empty results return a single item with the message 'No results found'.
Examples
Example 1: Filter a list of users by name.
Select a bucket, set query to 'SELECT * FROM users WHERE name="John"', and leave scope optional.
Example 2: Retrieve all documents from a specific collection using the default context.
Leave bucket and scope empty, and set query to 'SELECT * FROM my_collection'.