SELECT
CosmosDB NoSQL Plugin – Select Action
Summary (SEO Meta Description):
The Select Action of the CosmosDB NoSQL Plugin allows WeHub workflows to query and retrieve documents from Azure Cosmos DB using SQL-like syntax.
Ideal for building data-driven workflows that need fast, scalable NoSQL reads.
Overview
The Select Action enables WeHub to fetch data from a Cosmos DB container with powerful query options.
It supports partitioned queries, custom filters, ordering, and pagination, making it perfect for real-time applications.
Typical Use Cases:
- Retrieve patient or customer records with complex filtering
- Paginate through large datasets efficiently
- Fetch real-time analytics data for dashboards
- Integrate Cosmos DB data into downstream processing or reporting workflows
⚙️ Configuration
| Field | Description | Type / Options |
|---|---|---|
| Label | Custom name for the action | String |
| Select connection | Choose or create a secure connection to Azure Cosmos DB | Connection |
| Partition Key | (Optional) Specify a partition key. If left blank, cross-partition query will be used. | String |
| Container name | Target Cosmos DB container | Dropdown |
| Columns | Columns (fields) to select (hint: container.name) | String list |
| Condition | WHERE clause for filtering (hint: container.id=) | String |
| Order | SQL ORDER BY clause | String |
| Limit | Max number of records to return | Number |
| Offset | Number of records to skip before returning results | Number |
| Inputs (Manual) | Define input parameters for dynamic queries | Key–Value pairs (Types: NUMBER, STRING, BYTE, DATE, DATETIME, BOOLEAN, OBJECT, ARRAY, ANY) |
| Outputs | Choose to define outputs manually or let WeHub infer from schema | Manual / Truncate Fields |
| Schema | Select or define the output schema | Schema |
FAQ
Q: Can I query across multiple partitions?
A: Yes. Leave Partition Key empty to enable cross-partition queries.
Q: Does the action support parameterized queries?
A: Yes, you can define dynamic input parameters under Inputs (Manual).
Q: Are results automatically paginated?
A: You can use Limit and Offset to control pagination of large result sets.
Keywords: WeHub CosmosDB NoSQL Plugin, Select Action, Azure Cosmos DB Query, NoSQL Data Retrieval, Cross-Partition Query