Skip to main content

Custom

CosmosDB Table Plugin – Custom Action

Summary (SEO Meta Description):
The Custom Action of the CosmosDB Table Plugin lets your workflow run custom queries and operations directly on an Azure Cosmos DB Table.
Use it for advanced data manipulation beyond the standard CRUD actions.


Overview

The Custom Action enables WeHub workflows to execute flexible, custom table queries on Azure Cosmos DB.
This is ideal when your workflow needs logic that can’t be achieved with simple insert, update, or delete actions.

Typical Use Cases:

  • Running complex queries with filters and projections
  • Performing batch operations across multiple records
  • Automating maintenance tasks such as data clean-up or transformation
  • Building dynamic dashboards or analytics that require custom data selection

⚙️ Configuration

FieldDescriptionType / Options
LabelCustom name for the actionString
Select connectionChoose or create a secure Azure Cosmos DB connectionConnection
Table nameTarget table within the Cosmos DB accountString
Columns(Optional) Specify columns to returnString (comma-separated)
QueryThe custom SQL-like query to runString
InputsKey/value inputs used in the query. Supports manual definition.NUMBER, STRING, BYTE, DATE, DATETIME, BOOLEAN, OBJECT, ARRAY, ANY
Schema(Optional) Select an output schema or enable Truncate Fields toggleSchema

FAQ

Q: Can I use parameters in my custom query?
A: Yes. Define them in Inputs and reference them in the query.

Q: Is there any limitation on the query syntax?
A: The query must follow Azure Table Storage query syntax supported by Cosmos DB.

Q: Will the output respect the selected schema?
A: Yes, if you enable Manual or Truncate Fields, the output will match the chosen schema settings.


Keywords: WeHub CosmosDB Table Plugin, Custom Action, Azure Table Storage, Cosmos DB Query, WeHub Integrations