Worktables icon

Worktables

Interact with Monday.com boards and items
Join our community

Actions126

Overview

This node interacts with Monday.com boards and items, specifically providing the operation to search items on a selected board using filter rules. It allows users to specify a board, define filter rules with various operators, choose logical operators (AND/OR) between rules, and optionally fetch column values with control over which columns to include. The node constructs and sends GraphQL queries to Monday.com's API to retrieve items matching the filter criteria, supporting sorting and pagination. This is useful for workflows that need to dynamically find and process items based on complex filter conditions on Monday.com boards.

Use Case Examples

  1. Search for tasks on a project board where the status is 'In Progress' and the priority is 'High'.
  2. Retrieve all items from a board that have empty values in a specific column.
  3. Fetch items sorted by due date in ascending order, including specific column values.

Properties

Name Meaning
Board The Monday.com board to search items in, specified by selecting from a list or using an expression.
Logical Operator Logical operator (AND/OR) to combine multiple filter rules when searching items.
Fetch Column Values Whether to fetch detailed column values for the matched items.
Fetch All Columns When true, fetches all columns' values; otherwise, only specified columns are fetched.
Column IDs Comma-separated list of specific column IDs to fetch when 'Fetch All Columns' is false.
Filter Rules A collection of filter rules defining conditions on columns to filter items by. Each rule includes the column, operator, optional compare attribute, and compare value.
Sort Options Options to sort the search results by specified columns and directions (ascending or descending).

Output

JSON

  • items
    • ``
      * id - ID of the item.
      * name - Name of the item.
      * group - Group information of the item including id, title, color, and position.
      * state - State of the item (e.g., active, archived).
      * created_at - Creation timestamp of the item.
      * updated_at - Last update timestamp of the item.
      * column_values - Detailed column values of the item if fetched, including id, text, value, type, and additional metadata depending on column type.

Dependencies

  • Monday.com API
  • An API key credential for Monday.com

Troubleshooting

  • Ensure the API key credential is correctly configured and has necessary permissions to access the specified board.
  • Verify that the board ID is valid and accessible by the API key user.
  • Check that filter rules are correctly formatted and use valid column IDs and operators.
  • If fetching column values, ensure the specified column IDs exist on the board.
  • Handle API rate limits or timeouts by adjusting request timeout settings or limiting the number of results.
  • Common error messages include authentication errors (invalid API key), permission errors (access denied to board), and query errors (invalid GraphQL syntax or parameters). Resolving these involves checking credentials, board access, and input parameters.

Links

Discussion