PluginsPlugin Couchbase

Query​Query

Query a Couchbase database with N1QL.

yaml
type: "io.kestra.plugin.couchbase.Query"

Send a N1QL query to a Couchbase database.

yaml
id: "query"
type: "io.kestra.plugin.couchbase.Query"
connectionString: couchbase://localhost
username: couchbase_user
password: couchbase_passwd
query: SELECT * FROM `COUCHBASE_BUCKET`(.`COUCHBASE_SCOPE`.`COUCHBASE_COLLECTION`)
fetchType: FETCH
Properties
Min length 1

Connection string used to locate the Couchbase cluster.

Min length 1

Plaintext authentication password.

Min length 1

N1QL query to execute on Couchbase database.

Min length 1

Plaintext authentication username.

Default STORE
Possible Values
STOREFETCHFETCH_ONENONE

The way you want to fetch and/or store the data.

FETCH_ONE - output just the first row. FETCH - output all the rows. STORE - store all the rows in a file. NONE - do nothing.

SubType string

Query parameters, can be positional or named parameters.

See Couchbase documentation about Prepared Statements for query syntax. This should be supplied with a parameter map if using named parameters, or an array for positional ones.

Map containing the first row of fetched data.

Only populated if using FETCH_ONE.

SubType object

List containing the fetched data.

Only populated if using FETCH.

The number of rows to be fetched.

Only populated if fetchType is 'FETCH' or 'STORE'.

Format uri

The URI of the stored result in Kestra's internal storage.

Only populated if using STORE.