Worktables

Interact with Monday.com boards and items

Actions29

Overview

This node enables searching for items on a Monday.com board using flexible filter rules. It allows users to specify multiple filtering conditions on item columns, combined with logical operators (AND/OR), and supports sorting the results by specified columns.

Common scenarios where this node is beneficial include:

Retrieving specific tasks or projects from a Monday.com board that meet certain criteria (e.g., status, priority, due date).
Filtering items dynamically based on user-defined rules in automation workflows.
Sorting filtered items to prioritize or organize data before further processing.

Practical example:

You want to find all items on a project board where the "Status" column is "Done" AND the "Priority" column is "High", sorted by the "Due Date" column in ascending order.

Properties

Name	Meaning
Workspace Name or ID	Select the workspace containing the board. Choose from the list or specify an ID via expression.
Board Name or ID	Select the Monday.com board to search items in. Choose from the list or specify an ID via expression.
Logical Operator	Logical operator to combine multiple filter rules: `AND` or `OR`. Determines whether all rules must match (`AND`) or any rule can match (`OR`).
Filter Rules	Collection of filter rules. Each rule includes: - Column Name or ID: The column to filter on. - Compare Attribute: Optional attribute for comparison depending on column type. - Operator: Condition such as Any Of, Is Empty, Greater Than, Contains Text, etc. - Compare Value: The value to compare against (format depends on column type).
Sort Options	Collection of sort options. Each option includes: - Sort By Column Name or ID: The column to sort by. - Direction: Ascending or Descending.

Output

The output is a JSON array containing the filtered items matching the specified filter rules and sorted according to the sort options. Each item object includes:

id: Item ID.
name: Item name.
column_values: Array of column values for the item, each with:
- id: Column ID.
- text: Display text of the value.
- value: Raw value (usually JSON string).
- type: Column type.
group: Group information containing id and title.
state: State of the item.
created_at: Creation timestamp.
updated_at: Last update timestamp.
cursor: Pagination cursor if applicable.

No binary data output is produced by this operation.

Dependencies

Requires an API key credential for Monday.com API access.
Uses Monday.com GraphQL API endpoint at https://api.monday.com/v2.
The node expects proper configuration of the API key credential in n8n.

Troubleshooting

API Key Not Found: If the API key credential is missing or invalid, the node will throw an error. Ensure the API key is correctly set up in n8n credentials.
Board ID Required: The board ID parameter is mandatory. Omitting it will cause errors.
Invalid Filter Rule Values: The compareValue must be formatted correctly depending on the column type. For example, JSON arrays for multi-select columns or properly formatted dates for date columns.
Unsupported Operators: Using unsupported operators or incorrect combinations may result in no results or errors.
Large Result Sets: The query limits results to 100 items per request. If more results are needed, pagination handling should be implemented externally.
Expression Errors: When using expressions for IDs or values, ensure they resolve correctly to valid IDs or strings.