CRUD Operation Node

Performs Create, Read, Update, or Delete operations on database collections.

Input Fields

Task Name: Descriptive name for this database operation.

Operation Type: Select the operation - Create (insert), Read (query), Update (modify), or Delete (remove).

Collection: Select which database collection to operate on (invoices, accounts, contracts, etc.).

Filters: JSON object to filter which records to operate on. Example: {"status": "pending", "amount": {"$gt": 100}}. Supports workflow variables: {"_id": "${workflow.variables.recordId}"}.

Data (Create/Update): For Create and Update operations, provide the data as a JSON object. Example: {"status": "completed", "completedAt": "${workflow.variables.timestamp}"}.

Limit (Read): Maximum number of records to return (for Read operations).

Sort (Read): Sort order for results. Example: {"createdAt": -1} for newest first.

MongoDB Query Operators

• $gt, $gte, $lt, $lte: Greater than, greater than or equal, less than, less than or equal
• $eq, $ne: Equal, not equal
• $in, $nin: Value in array, value not in array
• $and, $or: Logical operators for complex conditions