STORED_PROCEDURE
CosmosDB NoSQL Plugin – STORED_PROCEDURE Action
Summary (SEO Meta Description):
The STORED_PROCEDURE Action in the CosmosDB NoSQL Plugin lets WeHub workflows execute predefined stored procedures in Azure Cosmos DB.
Use it to run server-side logic efficiently and return processed data directly into your workflow.
Overview
The STORED_PROCEDURE Action allows you to call an existing stored procedure inside a Cosmos DB NoSQL container.
This is ideal for scenarios where complex business logic or data transformations are implemented as stored procedures, enabling low-latency server-side processing.
Typical Use Cases:
- Execute custom business logic (aggregations, batch processing) inside the database
- Perform transactional operations without exposing raw queries
- Enforce data validation and transformations within Cosmos DB
- Reduce network overhead by running compute logic directly at the data layer
⚙️ Configuration
| Field | Description | Type / Options |
|---|---|---|
| Label | Custom name for the action | String |
| Select connection | Choose or create a secure Azure Cosmos DB connection | Connection |
| Partition Key | The partition key of the container where the stored procedure is executed | String |
| Stored Procedure | The name of the stored procedure to be executed | String |
| Container name | Select the target container in Cosmos DB | String |
FAQ
Q: Do I need to create the stored procedure in advance?
A: Yes. The stored procedure must already exist inside the target container in Cosmos DB.
Q: Can I pass parameters to the stored procedure?
A: Yes, you can pass parameters as part of the workflow payload.
Q: Are transactions supported?
A: Yes. Stored procedures in Cosmos DB support ACID transactions within the same partition key.
Keywords: WeHub CosmosDB NoSQL Plugin, Stored Procedure Action, Azure Cosmos DB, Execute Stored Procedure, Server-side Logic, ACID Transactions