Worktables icon

Worktables

Interact with Monday.com boards and items

Overview

The node enables searching for items on a Monday.com board using customizable filter rules. It allows users to specify a workspace and board, then apply multiple filter conditions combined with logical operators (AND/OR) to find matching items. Additionally, it supports sorting the results by specified columns and directions.

This node is beneficial when you want to programmatically query and retrieve specific items from a Monday.com board based on complex criteria without manually browsing the board. For example, you can search for tasks assigned to a particular person, with a status of "In Progress," and due within the next week.

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 using an expression.
Logical Operator The logical operator to combine multiple filter rules. Options: AND, OR.
Filter Rules A collection of filter rules where 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 A collection of sort options where each option includes:
- Column Name or ID: Column to sort by.
- Direction: Sort direction, either Ascending or Descending.

Output

The output JSON contains the search results structured as follows:

  • items_page: An object containing:
    • items: An array of item objects matching the filter criteria. Each item includes:
      • id: Item ID.
      • name: Item name.
      • column_values: Array of column values with fields like id, text, value, and type.
      • group: Group information including 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 indicated for this operation.

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 configuration of the API key credential in n8n is necessary.

Troubleshooting

  • API Key Not Found: The node throws an error if the API key credential is missing or invalid. Ensure the API key is correctly configured.
  • Board ID Required: If the board ID parameter is not provided or invalid, the node will throw an error. Make sure to select or provide a valid board ID.
  • Invalid Filter Rule Format: The filter rules must be properly formatted. Incorrect JSON or unsupported operators may cause errors.
  • Empty Results: If no items match the filter criteria, the output will contain an empty items array. Verify filter rules and logical operator correctness.
  • Rate Limits: Monday.com API rate limits may affect large queries; consider limiting the number of filter rules or result size.

Links and References

Discussion