Worktables

Interact with Monday.com boards and items

Actions26

Overview

The "Search Items by Filter" operation in the Item resource allows users to search for items within a specific Monday.com board using customizable filter rules and sorting options. This node is useful when you want to retrieve items that meet certain criteria, such as filtering tasks by status, priority, or date ranges, and optionally sort the results.

Common scenarios include:

Finding all items where a status column is set to "Done".
Searching for items with due dates within a specific range.
Filtering items based on multiple column values combined with logical AND/OR operators.
Sorting filtered items by a particular column in ascending or descending order.

Example: Retrieve all items from a project board where the "Priority" column is "High" and the "Status" column is not empty, sorted by creation date descending.

Properties

Name	Meaning
Workspace Name or ID	Select the workspace containing the board. You can choose from a 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	The logical operator to combine multiple filter rules. Options: `AND`, `OR`. Determines whether all rules must be met (`AND`) or any rule can be met (`OR`).
Filter Rules	A collection of one or more filter rules. Each rule includes: - Column Name or ID: The column to filter on. - Compare Attribute (optional): Additional attribute for comparison depending on column type. - Operator: Condition for comparison. Options include: - Any Of - Not Any Of - Is Empty - Is Not Empty - Greater Than - Greater Than or Equal - Less Than - Less Than or Equal - Between - Contains Text - Does Not Contain Text - Contains Terms - Starts With - Ends With - Within the Next - Within the Last - Compare Value: The value to compare against (format depends on column type).
Sort Options	Optional collection of sorting instructions. Each includes: - Sort By (Column Name or ID): The column to sort by. - Direction: Sort direction, either `Ascending` or `Descending`.

Output

The output JSON contains the search results structured as follows:

boards: An array containing the board(s) queried.
- items_page: Contains the paginated items matching the filter.
  - items: Array of item objects, each including:
    - 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 in JSON string format.
      - type: Column type.
    - group: Group object containing id and title.
    - state: State of the item.
    - created_at: Creation timestamp.
    - updated_at: Last update timestamp.
  - cursor: Pagination cursor if applicable.

This output provides detailed information about each matched item, including its columns and metadata.

Dependencies

Requires an API key credential for Monday.com API access.
The node makes HTTP POST requests to the Monday.com GraphQL API endpoint at https://api.monday.com/v2.
Proper permissions on the API key are necessary to query boards and items.
The node uses dynamic loading methods to populate options for workspaces, boards, and columns.

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 configured in n8n credentials.
Board ID Required: The operation requires a valid board ID. If missing or incorrect, the node will error out.
Invalid Filter Rule Values: The compareValue should match the expected format for the column type. For example, date filters expect ISO date strings or JSON arrays for "between" operators.
Empty Results: If no items match the filter, the output will contain an empty items array. Verify filter rules and logical operator correctness.
Rate Limits or API Errors: Monday.com API may return errors or rate limit responses. Check API usage and retry policies.